Skip to Content
0

How to retrieve entities directly bypassing the service URI

Sep 20, 2017 at 05:04 PM

31

avatar image
Former Member

I have a question about OData connectivity. We are OData providers and our OData implementations requires direct OData entity retrieval because of the dynamic nature of our data.

However, I am unable to connect to our data sources using SAP Lumira OData connector, as it wants to access via Service Root URI and then selecting entities.

Here is an example from the Northwind database to clarify it further.

If I use http://services.odata.org/Northwind/Northwind.svc URL with SAP Lumira OData connector, it gives me the list of the tables and I am able to select tables of my choice. Basically, behaves as expected. However, if I connect directly to the entity URL (http://services.odata.org/Northwind/Northwind.svc/Categories for example), it throws a "OpenConnectivity driver error" exception because of Bad URL http://services.odata.org/Northwind/Northwind.svc/Categories/$metadata


The entity URL works fine with other applications like Power BI, Tableau, Excel and Chrome.

What am I missing here? Is there a way to connect directly to the entity URL.

Regards

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers