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
MriduMridu 

how to connect SQL server to salesforce

 

hi

i have installed SQL Server 2005  and visual web developer express 2005 .i want to get data from SQL say one table account-accountname and address  into salesforce.How we can connect sqL server to salesforce.Is it possible.Give me  a solution asap

aalbertaalbert

A free option would be to use the Data Loader. You could manually extract the data from your DB into CSV files, then import those files into salesforce.com objects with the data loader. If you want to automate that, you could use the Command Line Interface of the Data Loader.

 

Depending on the complexity of your requirements, you could also try out Informatica's cloud-based Data Loader Service.

 
forceAMPforceAMP

Over a 1000 companies use DBAmp to connect SQL Server to salesforce.com

More details at http://appexchange.salesforce.com/listingDetail?listingId=a0N300000016bWzEAI
SFDC_LearnerSFDC_Learner

We can do this using Jitterbit.

 

 

 
COZYROCCOZYROC

Check COZYROC SSIS+ library. It is a third-party extension library for SQL Server Integration Services (SSIS). It does include Salesforce adapters and many other useful additions. When you test and develop from Visual Studio (BIDS), no license key is required. The adapters are very easy to use and completely integrated in SSIS.
Adele MornackAdele Mornack
To integrate SQL Server with Salesforce, you can try Skyvia (https://skyvia.com/data-integration/integrate-salesforce-sql-server). It is a completely no coding web service with an intuitive interface.
SergeiSergei
This article shows top 5 ways how to connect Salesforce and SQL Server and automate data export/import with no coding skills: https://skyvia.com/blog/5-ways-to-connect-salesforce-to-sql-server