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
santoshsantosh 

Query extrenal DB periodically

Hi,
 
I've rather run in to an unique scheme of things here.
I need my SF to periodically query an external MySQL DB and pull data from the MySQL DB and push it in to SF. Can someone guide me through this with some initial ideas?
 
Can a workflow achieve this or maybe an s-control that auto-runs periodically?
Thanks, very much.
Ron HessRon Hess
you will have to establish an external process which queries your mySQL and then inserts it into salesforce, you can use most any language you are comfortable with.

The recently announed Salesforce SOA is intended to query external web-services, so would not work for your case.