Apex Code Development You need to sign in to do that
Don't have an account?
Assaf Milman MySQL SalesForce bidirectional database sync
Hi everyone,
My company needs to sync between our AWS MySQL db and the SalesForce db.
The sync will be bidirectional, and updates on both ends should have a latency of less than 1 min.
I've seen https://developer.salesforce.com/forums/ForumsMain?id=906F00000008sHdIAI, which asked the same thing 6 years ago. One of the solutions over there were to use a framewrok called CloudConnect (http://www.cloudconnect.com/). Is looks promising, but evidently SalesForce acquired them 2 years ago.
Assaf
My company needs to sync between our AWS MySQL db and the SalesForce db.
The sync will be bidirectional, and updates on both ends should have a latency of less than 1 min.
I've seen https://developer.salesforce.com/forums/ForumsMain?id=906F00000008sHdIAI, which asked the same thing 6 years ago. One of the solutions over there were to use a framewrok called CloudConnect (http://www.cloudconnect.com/). Is looks promising, but evidently SalesForce acquired them 2 years ago.
- Anybody knows if CloudConnect still exists for mySQL?
- Are there other framewroks for this purpose that you know of?
Assaf
You can also use informatica cloud for your requirement and if you want to go for open source free alternative then Talend would be the best choice.
Regards,
Vivek Patel.
Please like or mark this as best answer if this solves you problem
All Answers
You can also use informatica cloud for your requirement and if you want to go for open source free alternative then Talend would be the best choice.
Regards,
Vivek Patel.
Please like or mark this as best answer if this solves you problem
From what I see their free version does not include cron jobs to sync the DB's on some predefined time interval - it has to be done manually. Do you know if this is correct, or does the free version has the cron job feature as well?
Thanks.
Here is the link where you can check the cron job details for Talend, I don't know if any other free version tool does support this.
http://www.talendbyexample.com/talend-scheduling-jobs-with-cron-crontab-reference.html
Regards,
Vivek Patel.
Please like or mark this as best answer if this solves you problem
Skyvia can offer you advanced integration options, such as:
- One-to-many - allows you to map one Salesforce object to several MySQL ones or vice versa.
- Preserving Relations - when integrating data with different structure Skyvia is able to preserve source data relations in the target.
- Expressions - Skyvia allows using complex mathematical and string operations and conditions for mapping data.
- Lookup - you can use lookup mapping to map target columns to values, gotten from other target objects depending on source data.
- Constant - when integrating data, you can fill some Salesforce fields that don't have corresponding MySQL fields (or vice versa) with constant values.