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

Connecting to a remote MySQL database

Hi, I would like to create an application that connects to a remote MySQL database.  I've seen apps that can schedule jobs to send the data to, but I would like to know if it is possible to sync the data between and my MySQL database?

As I will be making changes within salesforce and my MySQL database.

Thanks in advance !
Or if someone can tell me how to simply connect to my MySQL database from Salesforce?
Take a look at the free tool called dataloader, you can point this at any JDBC or CSV source, it has docs on how to do this as well as set this up to run automatically using cron/windows scheduler.

Beyond this you can consumer REST/SOAP services from within Apex on the platform using SOA Connect.
Aysnchronous Apex in the coming release will assist in scheduling this approach as well.

Dataloader from Salesforce is a great free tool for flat files, but for databases, it is actually pretty tough to configure and schedule.   


There are a couple of great how-to articles on how to accomplish this integration.


Running from the Command Line


Step by Step how to configure DB


Also take a look at other Free App Exchange tools