My requirement :- Synchronize between both Database Salseforce and Maria DB (MYSQL)
questions;-
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.
