TWO DATABASES SYNC PROCESS

One Star

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.
Moderator

Re: TWO DATABASES SYNC PROCESS

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: TWO DATABASES SYNC PROCESS

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




Thanks &regards
NEHA
Moderator

Re: TWO DATABASES SYNC PROCESS

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. TalendHelpCenterSmiley Frustratedetting up a CDC environment.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: TWO DATABASES SYNC PROCESS

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

Re: TWO DATABASES SYNC PROCESS

Hi miraclecartes,
Talend CDC feature is only available in Talend Subscription Product not open source.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seventeen Stars

Re: TWO DATABASES SYNC PROCESS

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 Smiley Wink
regards
laurent

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch