function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Justin DJustin D 

Data import from SQL Server to Salesforce

I have trying to find an option in Salesforce that I could schedule a time on a daily basis to import/update data from Microsoft SQL Server to Salesforce.
Is there any tool inside Salesforce?
If I use SSIS package, I am afraid that I need to host a server.
I am trying to utilize as much as possible at Salesforce instead of using other third-party tool or host a sever.
Thanks in advance.
 
Daniel BallingerDaniel Ballinger
I'm not aware of a native Salesforce solution for this. Salesforce certainly provides all the APIs you need, but you will need some code to access them.

In that past I've used DBAmp (http://www.forceamp.com/). It integrates Salesforce into SQL Server as a linked server. You can then perform CRUD operations directly from SQL. We have a scheduled job that fires off some stored procedures to perfrom the required sync from SQL to Salesforce.
David_GardelDavid_Gardel
This option is not available inside Salesforce. Try this 3rd party - Skyvia. It allows to easily automate the process of direct data loading between SQL Server and Salesforce. Read more here: https://skyvia.com/data-integration/integrate-salesforce-sql-server
Roksi KerychRoksi Kerych

You can create CSV(comma delimited) file from your SQL database and use Data loader to upload this to Salesforce. But the API access is not available for Professional edition and there is no support other than a help file. To see the Data Loader’s documentation, you can go here - https://help.salesforce.com/help/pdfs/en/salesforce_data_loader.pdf
You can also use ETL tools like Informatica, DBSync, Jitter bit for the migration and also the good part with these tools is that you can use these on a regular basis without much manual work after initial configuration. Sync can be set on schedulers.

Regards,
Ergonized https://www.ergonized.com/