You need to sign in to do that
Don't have an account?
Will Boyce
How to sync data from a mysql db on a linux box to SFDC enterprise environment?
We have a mysql database on a linux box and we would like to sync changes to that data into our SFDC environment. Data does not need to go both ways at this time, just from the linux box to SFDC. I have seen a number of Apps for this but I was hoping someone could help me with coding this. I am fairly new to coding but I am a quick study and unfortunately this problem has me stuck. I have searched this Forum for answers to this question but they all lead to partial answers and I feel like I am missing something at the end of each tutorial I watch on SOAP/REST APIs.
Can someone please, pretty please point me in the correct direction? Thank you in advance for your time and guidance!
Can someone please, pretty please point me in the correct direction? Thank you in advance for your time and guidance!
- You can write a program in say, PHP to read your new data and write to Salesforce using Salesforce SOAP APIs. You can go to developer.force.com and find out resources related to salesforce api and PHP, and there would be some samples there. Though you would need to know how to program in PHP and also how to access MySQL data in PHP.
- You can write a program in say, PHP to read your database and create a CSV file at a location, at regular intervals. Then, you can compile salesforce data loader on Linux and schedule it to read that file and write to Salesforce at regular intervals as well.
Hope this helps a tiny bit.