Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Sample Brainvire 1Sample Brainvire 1 

I need to transfer data from SQL server to salesforce.........

hello
      i need to transfer bulk ok sql data to the salesforce custome filds if anybuddy having solution please help me out 
KaranrajKaranraj
Following are the approaches you can able to do data transfer between SQL server and Salesforce 

1. You can use any ETL tools like Informatica or Jitterbit or Dell boomi which has the in build connector for Salesforce and SQL server where you can transfer the data from SQL server to Salesforce easily with the one time configuration. In this approach you have the real time data integration also. note that you have to buy licences for the ETL tool.
2. Extract the data from SQL server into csv file then using the data loader you can map the field and upload the data into salesforce. This approach has manual activities like extrat , map and importing. If you to do regularly and you has more number of table to do then it going to painfull.https://developer.salesforce.com/page/Data_Loader
3. You can build your own custom code to connect SQL server and Salesforce using webservice. Refer this link for more details https://developer.salesforce.com/page/Integrate_Salesforce.com_With_Your_On-premise_Database
Sample Brainvire 1Sample Brainvire 1
hey karanraj thanks for the reply 
is there any other way to pass the SQL data through C# code as a web or windows service.
 
IPFramptonIPFrampton
If you're doing it through C# code I would suggest using the Enterprise API which is extremely powerful. All you need to do is download the WSDL from your org, add it as a Web Reference and then code against it.
  • Here's a good getting started link: http://www.c-sharpcorner.com/UploadFile/kbpatel/integrating-salesforce-with-microsoft-net-C-Sharp/
  • And the SFDC documentation: https://developer.salesforce.com/page/Integrating_Force.com_with_Microsoft_.NET
Alternatively you can use the Data Loader with SQL Server which is another way in which I've been able to connect to Salesforce. You'll need to use the console for that approach:
  • Basics of the Command Line: https://developer.salesforce.com/page/Using_Data_Loader_from_the_command_line
  • Connecting to SQL Server http://highwaytoconcord.blogspot.co.uk/2013/07/data-loader-bean-for-sql-server-2012.html
Sample Brainvire 1Sample Brainvire 1
i have used Enterprise API to insert data but i can able to insert ~2300 data entries only i need to transfer over 40000 data entries but salesforce.com saying that ur data limit exceeded. is there any alternative way to insert 40000 data entries in salesforce custome object.........   
dillip nayak 3dillip nayak 3
HI Its better you just use Bulk Api that solve your problem.please check this link
https://github.com/lfreeland/Salesforce-Bulk-API-Starter
https://developer.salesforce.com/page/Bulk_API
Jacob C. MartinJacob C. Martin
Hi there,
On my opinion, there is two way how to solve your problem:
First, you can use SSIS component for SQL server, I recommend you this one (https://www.devart.com/ssis/salesforce.html). But, as you know, using SSIS component for SQL server requires quite impressive skills in programming
The second option is to use the no-coding solution, such as Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server), good result, without extra pain.