
Anonymous
Not applicable
2013-12-30
02:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
TWO DATABASES SYNC PROCESS
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.
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.
246 Views
6 Replies

Anonymous
Not applicable
2013-12-30
02:37 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
246 Views

Anonymous
Not applicable
2013-12-30
03:46 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ,
Thanks for your reply,any CDC component available in Talend.
i need auto sync process.with out look up process........
Thanks ®ards
NEHA
Thanks for your reply,any CDC component available in Talend.
i need auto sync process.with out look up process........
Thanks ®ards
NEHA
246 Views

Anonymous
Not applicable
2013-12-30
04:00 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
As we known that CDC can not work on two different servers(Mysql-->Mssql). You cannot use CDC in your current job situation. TalendHelpCenter
etting up a CDC environment.
Best regards
Sabrina
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. TalendHelpCenter
Best regards
Sabrina
246 Views

Anonymous
Not applicable
2015-09-14
03:13 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi,
tMysqlCDC component is not find in talend open studio. how can i sync mysql database in talend open studio
tMysqlCDC component is not find in talend open studio. how can i sync mysql database in talend open studio
246 Views

Anonymous
Not applicable
2015-09-15
06:13 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi miraclecartes,
Talend CDC feature is only available in Talend Subscription Product not open source.
Best regards
Sabrina
Talend CDC feature is only available in Talend Subscription Product not open source.
Best regards
Sabrina
246 Views

Anonymous
Not applicable
2015-09-15
06:55 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
246 Views
