Friday, January 25, 2013

To integrate Salesforce with an External database

Scenario :-

To interact Salesforce with any external database like SQL server to get the real time data into the Salesforce for the Sql server database.


There is no facility to connect directly to your database with salesforce. However, using an integration service (or web-services, REST API, etc.), you can connect or sync to an external database.

Please refer to 2 below mentioned points :-

1. Integrate the data into salesforce.com and store the data using the Force.com Web Services API and then build your Visualforce page on that data as needed or you could use the Data Loader to update the data. More Info

2. Web-service enable your backend data and have apex make "callouts" (web service calls) to retrieve the data. There are some constraints about request and response size so please refer to below mentioned links for better understanding :-

2.1) If your web service provides a WSDL, you can try to import it to Apex and Apex will auto-generate the apex classes. More Info here

Or

2.2) You can construct the web service message using the HTTP (RESTful) apex classes.More Info Here


Other APIs which can be referred to integrate Salesforce with other databases :-

  • Salesforce Web Services API 
  • Salesforce Bulk API 
  • Salesforce Rest API 
8 different APIs, click on it to find out which API should you use?


Following are the mentioned list of integration services:

1) Informatica Cloud
2) Cast Iron
3) SnapLogic
4) Boomi
5) JitterBit
6) Sesame Relational Junction