You need to sign in to do that
Don't have an account?
DavidKY
Syncing MySQL data with Salesforce using REST
We are developing a php/ html5/css3 application running on our own LAMP server.
At this point we would like to be able to connect the mysq database php app on our web server to SF.
Our intention is to have our contacts utilize the php app and portal running on our server and then use the REST API to sync contact data with SF so that we can utilize the CRM functionality.
Is this possible and if so could you suggest the best method to accomplish this?
Thanks,
David
Have you checked out the PHP toolkit? Link to PHP toolkit
Thanks Nick.
One thing to keep in mind is that REST can only act on one resource at a time. If you have a MySQL database full of data, you're going to want to upload it to Salesforce with the Bulk API the first time. You'll also want your design to consider which REST posts need to be synchronous, and which ones can be batched up posted all at once on the Bulk API. 1 REST call gets counted the same as 1 Bulk call for up to 10,000 records, in terms of your daily API limits.
http://www.salesforce.com/us/developer/docs/api_asynchpre/api_bulk.pdf