You need to sign in to do that
Don't have an account?

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?
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?
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