Has anyone tried connecting a Microsoft OData service via External Data Source (Lightning Connect).

I'm trying to achieve this (my OData service is deployed on top of MS WebAPI infrastructure), and when I try to validate & sync the External Data Source, I get this status:

The external data source isn't using the specified version 2.0.

  • I think everything posted here was true at the time, but there is now new type of connector that probably wasn't available originally Salesforce Connect: OData 4.0. I've currently got my Web API OData controllers on version 4 of OData and am able to have data read successfully via the External Data Source
    – bkwdesign
    Commented May 10, 2019 at 13:52

2 Answers 2


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 .

I tried using Windows azure platfom and deployed my webservice there and was able to successfully connect and get SQL data

Here is the blogpost from me on this



You may need to lower the Odata version to 2 to get it working .

  • Thank you, I'll try to publish an OData version 2 service Commented Jan 4, 2015 at 11:57

After getting Mohithes answer, I've looked by myself the appropriate way to make the WebAPI service to use Odata v2 and found this: you're setting the version in the Register method of your WebAPIConfig file:

ODataConventionModelBuilder builder = new ODataConventionModelBuilder();
builder.DataServiceVersion = new Version("2.0");
config.Routes.MapODataServiceRoute("odata", "odata", builder.GetEdmModel());

that solved my problem.

  • brilliant .Thanks for sharing some code on this forum Commented Jan 29, 2015 at 18:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .