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
bujjibujji 

How to create external data source for SQL Server

Hi Guys,

I have scenario like, i need to connect SQL Server with out using any SSRS,SSIS. I thought external data source will be helpful.
Please suggest a way to connect to SQL Server from Salesforce.....

Thanks,
Bujji.
ShashankShashank (Salesforce Developers) 
Please see this link:
http://salesforce.stackexchange.com/questions/55572/connecting-sql-server-as-an-external-data-source
 
Bethan WilkinsBethan Wilkins
Hello!

There are 2 approaches: the first one - it's using ETL cloud tools for transferring data between apps and DB (depends on your needs it could be different scenarios, for example import, sync, replication etc). You can choose any of these 3rd parties to speed up the process: Dell Boomi, Skyvia or JitterBit.

Another approach is to expose the data via OData and display it as external Object in Salesforce. The main disadvantage of such approach for me is a high price for Salesforce Connect, which allows accepting OData on Salesforce side. By the way Skyvia can also be helpful in the 2nd approach (https://skyvia.com/connect/sql-server-odata). Good luck!