function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
dallasclarkdallasclark 

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 salesforce.com, but I would like to know if it is possible to sync the data between Salesforce.com and my MySQL database?

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

Thanks in advance !
dallasclarkdallasclark
Or if someone can tell me how to simply connect to my MySQL database from Salesforce?
cbrowncbrown
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.
CloudIntegratorCloudIntegrator

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