My requirement :- Synchronize between both Database Salseforce and Maria DB (MYSQL)
1. Can Talend support CDC feature between SalesForce(Cloud Instance) and Maria DB ? only the delta change from Salesforce to be applied to Maria DB and vice versa.
2.Can Talend give delta modified records of Source DB without validating with destination DB? I mean, if say 10 records are in source and read/synced, 2 modifications and 1 new record are added, can Talend give these 3 records to sync based on last read.
3) My assumption:-
Salsforce supported SOQL Query And Maria Db supported MYSQL query
I think its not supported CDC process going this way, or else any option its available please let me know
4) I have one option:-
But i dont know how much complex to develop mapping, below mentioned this ways.
step1) salesforce to ---> MariaDb (one loaded) dump data
step2) Synchronize between both schema Maria Db and Maria DB
In that step i am going to implement the CDC concept
step3) Maria Db to ---> sales force (one loaded) dump data for reverse process
please let me know the complex to develop the job.
Anybody have suggestion please let me know
Could you please have a look at this online documentation about:TalendHelpCenter: Database support for CDC?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables