2

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.

1
  • 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
    May 10 '19 at 13:52
1

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

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

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

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

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");
builder.EntitySet("myTable");
builder.EntitySet("myTable2");
...
config.Routes.MapODataServiceRoute("odata", "odata", builder.GetEdmModel());

that solved my problem.

1
  • brilliant .Thanks for sharing some code on this forum Jan 29 '15 at 18:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.