Talend CDC salesforce and Maria DB

Anonymous — Fri, 03 May 2019 08:58:41 GMT

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.

Anybody have suggestion please let me know

Re: Talend CDC salesforce and Maria DB

Anonymous — Tue, 28 May 2019 10:06:01 GMT

Hello,

Could you please have a look at this online documentation about:TalendHelpCenter: Database support for CDC?

Best regards

Sabrina

topic Re: Talend CDC salesforce and Maria DB in Talend Studio

Talend CDC salesforce and Maria DB

Re: Talend CDC salesforce and Maria DB