I have a requirement where in we need to push data from sql server to Salesforce on daily basis. Can anybody suggest me the best possible way to do the same ?

Also After googling things, it seems like the only possible way for this kind of setup is to purchase a connector (not sure) however we are thinking of setting this up on our own and keeping the third party softwares as our last option. So are they any docs to start with.

Thanks in Advance

closed as too broad by Vijay Ganji, battery.cord, Derek F, glls, salesforce-sas Aug 27 at 18:05

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


The Salesforce method for such a connection is through Salesforce Connect. You can find information about that here: https://help.salesforce.com/articleView?id=salesforce_connect.htm&type=5.

Another Salesforce offering is the Data Loader. This can be scheduled to import data into Salesforce. You can find the guide for Data Loader here: https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/data_loader.htm

If you're looking for something more bespoke, I suggest you look into the APIs that are available for Salesforce. You can find all of the developer documentation here: https://developer.salesforce.com/docs/.

I would focus first on the Bulk 2.0 and Bulk API Developer Guides. Then I would look at the REST API Developer Guide and the SOAP API Developer Guide.

Not the answer you're looking for? Browse other questions tagged or ask your own question.