+ Start a Discussion
Suresh Kumar 34Suresh Kumar 34 

Sql integaration with salesforce

Hi guys,

I want to integrate the sql database to salesforce application,as i am new to salesforce i am not aware of this please suggest me how to achieve this requirement.

Thanks,
Suresh.
BRTRAJBRTRAJ
There are many third party products available to make the job simple and practical. The implementation purely depends on your requirement and budget.
Before you look for solution, my suggestion would be to review why you want to do this integration. Salesforce has cloud db within itself, and as you might be aware, is not designed to work as a front end of a bigger local DB.
Integration of Salesforce with other applications can depend on what kind of data you want to push to cloud and how frequently you would like to do it. At a high level, volumetric automated sync might not be a good idea as the cloud has higher restriction than local db, and there are lot of chances where we might invoke the governor. 

Also, please have a quick look at the following threads for some pointers,
https://developer.salesforce.com/forums/?id=906F00000008xnXIAQ
https://developer.salesforce.com/page/Integrate_Salesforce.com_With_Your_On-premise_Database
Rajiv Penagonda 12Rajiv Penagonda 12
Try External Objects which facilitates querying your SQL tables from within APEX! More details below.

https://help.salesforce.com/HTViewHelpDoc?id=external_object_define.htm