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
Lily BluntLily Blunt 

Creating an Odata v2. Step by step instructions?

Hi all. How do you create your own custom database, OData v2 service, and publish it online so that it can be accessed by Salesforce?
While there is plenty of examples and instructions to consume OData v2 service in Salesforce, I was not able to find content on creating OData v2 service itself.  What is available on OData talks about creating the v4 version. That cannot be consumed by Salesforce at this point, right?
NagaNaga (Salesforce Developers) 
Hi Lily,

Lightning Connect currently supports only Odata V 2.0 . 3.0 and above and not supported and hence the error .Also the data feed has to be an ATOM feed .

you can use Windows azure platfom and deploy  webservice there and  connect and get SQL data

http://cloudyworlds.blogspot.in/2015/01/lightning-connect-and-sql-integration.html

http://cloudyworlds.blogspot.in/2015/01/lightning-connect-and-sql-integration_3.html

Please check the link below for more info

http://salesforce.stackexchange.com/questions/61435/connecting-microsofts-webapi-odata-service-via-lightning-connect

Best Regards
Naga Kiran