Skip to Content
avatar image
Former Member

How to retrieve entities directly bypassing the service URI

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 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 ( for example), it throws a "OpenConnectivity driver error" exception because of Bad URL$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.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers