+ Start a Discussion
Bhushan Mahajan 5Bhushan Mahajan 5 

how many way of integration with SQL Server.

I want to integration with sql server to salesforce,tell me which types of way i am integrate with salesforce to sql server.
KaranrajKaranraj
Bhusan - You can integrate salesforce with SQL server in the following ways

1. Lightning Connect - Using connect you can able to connect to SQL server easily, you have to purchase lightning connect licenses for that.Using that you can able to bring the data from SQL server into Salesforce easily.
Here is the blog posts -
 http://cloudyworlds.blogspot.in/2015/01/lightning-connect-and-sql-integration.html 
 https://developer.salesforce.com/blogs/developer-relations/2015/03/accessing-sql-server-azure-database-lightning-connect.html (https://developer.salesforce.com/blogs/developer-relations/2015/03/accessing-sql-server-azure-database-lightning-connect.html)

2. You can also use any Data integration tools like Informatica, Dell Boomi, jitterbit etc., which contains inbuilder builder to connect salesforce and SQL server, using that you can have two way data integration between salesforce and SQL server.

Thanks,
Karanraj
Cathy Kelly 4Cathy Kelly 4
@ Karanraj

Hi Karanraj, 

Can we have integrate Salesforce with MS SQL Server 2012 without any ETL Tools/Middleware?
Note: we are not planning for Lightning Experience currently. any other possibilities?
David ArchibaldDavid Archibald
Hi Bhushan,

To integrate Salesforce with MS SQL Server 2012 you should either use the SSIS component. In this topic, you will find the list of the most popular one: https://success.salesforce.com/ideaview?id=08730000000BpZWAA0

Or you can use the 3rd party services to integrate SQL Server and Salesforce without coding at all. My personal choice is Skyvia: https://skyvia.com/data-integration/integrate-salesforce-sql-server (https://skyvia.com/data-integration/integrate-salesforce-sql-server)

Hope it helps!
Michael TomarMichael Tomar
H1! As it was mentioned earlier, a direct way to connect SQL server to Salesforce doesn't exist. So you can use an online third-party tool Skyvia which supports all CRUD operations. Check their stepwise tutorial here: https://skyvia.com/blog/5-ways-to-connect-salesforce-to-sql-server