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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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?