topic How to real time continously sync schema and data from MSSQL to MySQL? in Talend Studio

How to real time continously sync schema and data from MSSQL to MySQL?

Anonymous — Sat, 16 Nov 2024 02:16:59 GMT

Hello all,

I am the newbie. I am googling the ETL tool, then I found Talend, downloaded "Data Integration" from Open Source Solutions (https://www.talend.com/products/talend-open-studio/), actually I don't know which product fit for my situation. I want to real time continuously synchronize schema and data from MSSQL to MySQL, when the user insert, update or delete data in MSSQL via a program, the manipulation can nearly the same time updated to MySQL. Also the same if added and/or deleted any table and/or column.

If it possible, which product of Talend i should use and how to implement it? It is not suitable for me to use Cloud solution this moment.

Thanks and Best regards,

Kenneth

Re: How to real time continously sync schema and data from MSSQL to MySQL?

Anonymous — Tue, 02 Jun 2020 11:02:36 GMT

Hi Kenneth
The CDC (Change Data Capture) functionality in Data Integration product can meet your needs, for more information about CDC, see
https://help.talend.com/reader/93olCfmQi615MRwYBjy30g/Ni3tTLbdYnf7GCwNT5F5rQhowever, this feature is only available in Talend enterprise subscription product. You can request a free trial.
https://www.talend.com/free-trial/

Regards
Shong

Re: How to real time continously sync schema and data from MSSQL to MySQL?

Anonymous — Mon, 15 Jun 2020 17:17:40 GMT

Hi Shong,

Thanks for your guiding, and sorry for the late reply.
Is the Talend enterprise subscription product a cloud platform or On-Premises version?