Loading Data into SalesForce from SQL Server

On a nightly basis we’re uploading contacts, financial accounts, holdings, etc. into SalesForce from our brokerage platform with the aid of DBAmp (a data integration tool between SalesForce and SQL Server). This process is working fairly well but as we continue to grow we’re noticing that it’s taking longer and longer for this process to complete. Furthermore, the most recent upload of holdings took over 2 hours to load into SalesForce (approx. 620,000 rows).

Does anyone have any suggestions of a more efficient way of loading data in Salesforce or maybe some information on some other third-party vendors that could help us?

I appreciate any guidance you can provide, thanks!

May 8, 2014
·
Like
1
·
Follow
1

Best Answer chosen by Chris Husted

Amit (Salesforce Developers)
Hello,

Please refer following links for more information :

http://www.salesforce.com/us/developer/docs/async_processing/salesforce_async_processing.pdf

https://developer.salesforce.com/page/The_Salesforce_Bulk_API_-_Maximizing_Parallelism_and_Throughput_Performance_When_Integrating_or_Loading_Large_Data_Volumes

http://help.salesforce.com/help/pdfs/en/salesforce_query_search_optimization_developer_cheatsheet.pdf

https://help.salesforce.com/apex/HTViewSolution?urlname=Best-Practices-for-Loading-Data-1327108675445&language=en_US

Thanks,

Amit Bhardwaj

May 8, 2014
·
Like
0
·
Dislike
0

This was selected as the best answer

Luis Gab
You can load data into SalesForce from SQL Server with Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server). It is no-code Saas

June 7, 2023
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Loading Data into SalesForce from SQL Server

All Answers

You need to sign in to do that.