Moving data from SalesForce to MySQL

Posted September 29th, 2008 by ddeveaux

I'm not clear how I would transfer data from SalesForce to MySQL or vice versa. I tried using the Downloader from SalesForce, but the only MySQL connector gives an error. When I try to use the Uploader to MySQL, while it looks like I can connect to SalesForce as the Source, I get a licensing error. Since each of these databases seems to be a seperate product (SalesForce and MySQL) can data move back and forth between them?

‹ What Programming Language Are the Functions Most Similar To? Upload csv into CTree Plus ›

RE: Moving data from SalesForce to MySQL

On September 29th, 2008 jterrell said:

Both the Data DownLoader from Salesforce.com and the Data UpLoader to mySQL will allow you to transfer data from Salesforce.com to mySQL. Please note that connectivity to each has specific configuration requirements, as follows:

Salesforce.com connectivity requires an Internet connection and valid login credentials to an instance of SFDC. Access to certain data within the SFDC instance also requires that you have permissions to that data.

mySQL connectivity requires that you have version 8.17.0.2.10 of DataTools installed (earlier builds of DataTools will not connect to mySQL). A properly installed and configured mySQL ODBC v3.5 driver is also required, as well as connectivity and login permissions to the mySQL database. An ODBC driver is available at no charge on the mySQL web site.

- Jo