Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Synchronize two different database

how to  synchronize data between two database in talend open studio for data integration
Labels (2)
4 Replies
Anonymous
Not applicable
Author

Hi,
With Talend Open Studio, it doesn't support for batch synchronization of databases. You must creat jobs by mapping tables.
If you are using Talend Enterprise Subscription Version, it is possible to synchronize data from a source table to a destination table with CDC feature.
TalendHelpCenter:CDC architectural overview
Best regards
Sabrina
Anonymous
Not applicable
Author

Thanks Sabrina...
However, the situation is in specific is that , I have a source table and the data in that table has changed. ( for e.g. Date of Birth of a Customer). Now how do i synchronize this change in date between the Source table and my target (ODS) table.
So the situation regarding synchronization of database is with respect to above example in specific.
Anonymous
Not applicable
Author

following error comes when using tmysqlscd component in job. please help me to resolve
sk1 cannot be resolved or is not a field
    scd_start cannot be resolved or is not a field
    scd_start cannot be resolved or is not a field
    scd_end cannot be resolved or is not a field
    scd_end cannot be resolved or is not a field
    scd_version cannot be resolved or is not a field
    scd_active cannot be resolved or is not a field
Anonymous
Not applicable
Author

Hi,
Have you already checked component reference TalendHelpCenter:tMysqlSCD with SCD management methodologies?
Best regards
Sabrina