+ Start a Discussion
santoshsantosh 

Query external Database from Salesforce 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.
sfdcfoxsfdcfox
Salesforce can't do this at the moment. The correct method would be to create a service on the MySQL server that periodiocally queries the MySQL server then calls insert(), update(), delete(), or upsert() (as appropriate) on the appropriate records in Salesforce.

~ sfdcfox ~
Again AgainAgain Again

You could use a program like DBAmp. Create tables in SF that mimic the external data source, then create DTS packages to push the data to SF using DBAmp. This way you can do different calculations, summary fields etc. before you push the data through also.

I'm not sure if DBAmp works with other databases also; I use it with SQL Server.

RenatKhRenatKh
Hello, santosh.

Perhaps, you could take a look at Apatar Open Source, a data integration tool that links databases, files and applications. It enables connectivity to MySQL, PostgreSQL, Oracle, MS SQL, Sybase, FTP, HTTP (POST and GET), SugarCRM, Goldmine CRM, XML (local and web-based), flat files (CSV, TXT), Webdav, Buzzsaw, LDAP, Amazon and even Flickr.

Using Apatar's Scheduling function, you can schedule one-time or recurring data transformations. That would allow you to automate data export and import.

You can find online demos that explain how to integrate SalesForce.com with other data sources here: http://www.apatar.com/web_demo.html

For more information, or to download a copy of Apatar, visit http://www.apatar.com

Hope, this tool would help you. Should you have questions, I can be reached through my blog 'Naked Open Source', found at http://www.nakedopensource.com/.

Renat Khasanshyn
Wizard, Apatar Data Integration for Salesforce.com