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
sfdc2705sfdc2705 

How can i get the data from SQL server to salesforce via dataloader or jitterbit or any middleware tools..?

Please share ideas and step by step process to get this done if anybody has implemented this before..?
Does the data get stored in salesforce ?

Any help is greatly appreciated..
Jean-NoelJean-Noel
From DataLoader, you'll need to use it with CLI.
Download and install DataLoader
For SQL Server, you'll need to download and install the JDBC driver, copy the file sqljdbc4.jar to \Data Loader\Java\lib\ext
Create a dedicated user / security settings in SQL server.
From the /bin folder, create a encryption key with encrypt and use that key to encrypt you Salesforce user password.
Update the database-conf.xml and process-conf.xml to create the bean for the operation you want to perform, there is sample in the /sample folder.

With all of that you should be able to transfer records from SQL to Salesforce and/or from Salesforce to SQL.
James DornJames Dorn
You can choose different third-party apps for this task. I recommend reading this (https://skyvia.com/etl-tools-comparison/jitterbit-alternative-skyvia)article. It describes the pros and cons of different applications