TWO DATABASES SYNC PROCESS

[Anonymous]

Hi all,

how to two different databases automatically SYNC process.
ex:
1)MYSQL----------------(dept table)
2)MS SQL SERVER ----(dept table)
if one row inserted into dept table in mysql db then automatically inserted into dept table in ms sql server database.
note:CDC concept is not work because CDC concept only one database.

[Anonymous]

Hi,
There is no such automatically "Sync" process between two Databases.
You have to compare tables to get the updated data then insert it to another DB by manual.
For example:
t<DB>input(targetDB Mysql)-->main-->tMap-->t<DB>output(Mssql)
t<DB>input(sourceDB)-->lookup-->
Make a inner join and set "Catch Look up inner join reject " as true and the processed data should be updated data, then insert it into another to keep the two database "Sync".
Best regards
Sabrina

[Anonymous]

Hi ,
Thanks for your reply,any CDC component available in Talend.
i need auto sync process.with out look up process........




Thanks &regards
NEHA

[Anonymous]

Hi,

note:CDC concept is not work because CDC concept only one database.

As we known that CDC can not work on two different servers(Mysql-->Mssql). You cannot use CDC in your current job situation. TalendHelpCenteretting up a CDC environment.
Best regards
Sabrina

[Anonymous]

hi,
tMysqlCDC component is not find in talend open studio. how can i sync mysql database in talend open studio

[Anonymous]

Hi miraclecartes,
Talend CDC feature is only available in Talend Subscription Product not open source.
Best regards
Sabrina

[Anonymous]

hi,
as sabrina says, CDC is only available with subscription.
but you can use the same by writing your own trigger to catch change on data from somes tables.
google search o 'mysql  DML statements trigger'
Or go to an enterprise Talend version
regards
laurent