SAP Lumira Error: OData connection error (since last week!) with cbs.nl

[Former Member]

Question from a Customer:

Dear SAP Lumira Customer Care,

I try to report on the open cbs data with the local SAP Lumira tool to connect to these services.

However the connection is not possible anymore.

I tried to open a connection based on Odata V2.

First on version 1.30, and even after update to version 1.31 of Lumira it failed.

“Unable to connect to server”.

It looks like, the current version is not supported. This sounds odd to me.

Can you help me out?

I used this table:

http://opendata.cbs.nl/ODataFeed/odata/82218NED

with metadata available see link:

http://opendata.cbs.nl/ODataFeed/odata/82218NED/$metadata

So I connect to the first link, (no user/password required).

However the connection is not established, see error message:

“ OpenConnectivity driver error: A problem occurred while communicating with the provider. Detailed message: Server error: (response: status=404. reason=’Not

Found, request=’/ODataFeed/odata/82218NED/$metadata’) ”

Windows 10, SAP Lumira version info: 1.31.0 build: 121

Thank you,

Valerie

SAP Customer Care Specialist

[Former Member · Accepted solution]

Hello Valerie

Please note that retrieving data from CBS via Odata  was working in week 23 2016, and sadly not anymore. As far as I am aware CBS data format has not changed, this data can be accesed via the Power Pivot Add on in Microsoft Excel.

Regards

Phillip

[TammyPowlas]

Valerie - is it something with the Netherlands OData provider?

Because I just tried the standard Northwinds http://services.odata.org/Northwind/Northwind.svc/ provider and it works fine.

Could you try Northwinds on your version of Lumira, and if that works, I assume it may have something to do with your Netherlands OData data source?