Apex Code Development You need to sign in to do that
Don't have an account?
blakem Query local MS SQL database from salesforce
I am on enterprise edition and am trying to investigate the ability of saleforce to access a SQL server database and run a query. I've searched everywhere to get a walkthrough or even a snippet on how to create a visualforce page that calls a query of a local database. Right now I am just trying to read data from a MSSQL database, but I wonder if this will lead to update, insert, or delete ability.
Can anyone help?
You won't be able to directly call your local DB from salesforce.com. You can call a web service that you host and then that service performs the SQL. But again, you will need to use web services to integrate to/from salesforce.com.
I think the answer goes back to "Why" you want to connect back to your SQL Server.
If you are looking to do Events or single transactions, the web service approach is a good one. Here you can push a button on your SFDC page to call out to your custom web service to get or put data into your back-end system. You can also setup outbound messages in SFDC workflow to postback to your webservice (schema defined by SFDC though) based on events. Creating a webservice in your enterprise is pretty easy. Most languages, you just specify the method as a webservice. (.NET shown)
[WebMethod]
public Customer[] GetCustomersByName(string Name)
{}
Don't forget that once you make a web service, you also need to expose it in your DMZ and give it a name so that SFDC can access it.
If you are interested in synchronizing data between SFDC and your backend database, you should probably look at some of the free Data Loader tools out on App Exchange which have all of the abilities that you specified. Insert, Update, Delete, Upsert.
SFDC Data Loader with Databases
HowTo Free IOD DLS and SFDC DL
Best Apps of 2008 (find Integration)
Regards,
CloudIntegrator
www.InformaticaOnDemand.com
We are aquiring a business that is exporting all of their information out of Junxure into a MS SQL database. We are very basic users when it comes to developing and even uploading data into SFDC. Would you have any resources that may be able to help us get the information uploaded from the MS SQL database format into SFDC.
Thanx!