What is the most efficient means for using SQL Server as an External Data Source in Salesforce? We are using SQL Server 2012. I realize I can create a services project to act as a go between but looking for a solution that doesn't require coding if possible.

I would like full CRUD capabilities from Salesforce to my SQL Server data.

Thank you.


We cannot directly connect SQL Server Using External data Source. But it is possible to create an OData Wrapper around SQL Server and then connecting to SQL Server using OData. See below link for exposing SQL Server as an OData Server.


  • Thank you anmrk. However, I think you forgot to post the actual link. Would you mind updating your answer? Nov 8 '14 at 13:11

I used DataDirect Cloud for my Lightning Connect POC with our on-premise data warehouse and it supports SQL Server. https://developer.salesforce.com/blogs/developer-relations/2015/03/external-objects-lightning-connect-poc-in-5-days.html

We are also awaiting write support for some future integration projects.


Looks like CRUD is not possible at this Stage, It is Read only at this time. Need to Check with you Saleforce Account Exe


There are several ways to connect Salesforce to MS SQL, such as SQL Server Import and Export Wizards, SSIS, ODBS Drivers, Data Loaders, etc.To find the most appropriate for your business needs, take a look at this article:


We use Skyvia ETL tool, it supports full CRUD operations.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.