function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Assaf MilmanAssaf 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.
  1. Anybody knows if CloudConnect still exists for mySQL?
  2. Are there other framewroks for this purpose that you know of?
Thanks a lot,
Assaf
Best Answer chosen by Assaf Milman
Vivek_PatelVivek_Patel
Hi 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

Vivek_PatelVivek_Patel
Hi 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
This was selected as the best answer
Assaf MilmanAssaf Milman
Thanks for your quick reply Vivek!
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.
 
Vivek_PatelVivek_Patel
Hi Assaf,

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
 
Róża JabłońskaRóża Jabłońska
You can easily integrate Salesforce and MySQL directly with the help of Skyvia (https://skyvia.com/data-integration/integrate-salesforce-mysql).

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.