Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?