function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Cathy Kelly 4Cathy Kelly 4 

MS SQL Server 2012 Integration with Salesforce without Middleware/ETL

Hi, 

I am new to Salesforce Integration. 
Can anyone explain on how to establish a two-way integration between MS SQL Server 2012 and Salesforce without any ETL Tools /Middleware?
Can MS SQL Server 2012 expose its table data as a public webservice so that Salesforce can consume? If Yes, what type of Webservice( REST or SOAP) does it support.
 
Abi V 4Abi V 4
Odata is the protocal for which will generate the URL when u set up the Odata for your MS SQL Server 2012.
The generated URl can be use in salesforce and set up the external data sources in salesforce using the Lightining Odata Connect.
Please refer the link https://developer.salesforce.com/trailhead/en/module/lightning_connect  
Limitation will apply for lightining connect and it is one way communication with read only access to data.
Cathy Kelly 4Cathy Kelly 4
Thanks Abi V 4 for your input. Currently we are focussing on Salesforce classic.
Please share your ideas if any that focuses on Salesforce Classic Integration with MS SQL Server 2012 without any ETL/Middleware

Thanks