how to active auto sync with database

modara — Wed, 23 Sep 2020 03:28:09 GMT

Hi there,

I have mysql database and i want to activate auto sync using talend.

So when some entry inserted into mysql talend will automatically sync and pick that entry and put it into other location or convert to excel file

if there is a process then please help me how and also tell how long every after talend will pull data from mysql

thanks

Re: how to active auto sync with database

Anonymous — Thu, 24 Sep 2020 03:11:57 GMT

Hello,

With talend open source, 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".

With talend subscription solution, here is a CDC feature which is an advanced technology for data replication and loading in order to keep multiple systems in sync with all the data changes.

For more information, please refer to this online documentation about: TalendHelpCenter: Change Data Capture

Best regards

Sabrina

topic Re: how to active auto sync with database in Talend Studio

how to active auto sync with database

Re: how to active auto sync with database