Skip to Content
Author's profile photo Witalij Rudnicki

From Wroclaw to Berlin and back: IoT analysis with SAP Lumira via OData

This is continuation of the story that started with From Wroclaw to Berlin and back with SensorPhone and SAP HCP IoT, where I used OData API to consume messages stored in HCP IoT Service. At that time I exported JSON data into the external file to analyze in external tool, eg to draw an elevation chart.

But I could use as well little know possibility of SAP BusinessObjects Lumira, Desktop edition to acquire data from simple OData v2.0 services as shared by Tammy Powlas earlier.

Before we do that, let me point you to tutorials how to Download and install SAP BusinessObjects Lumira trial, if you are not familiar with the product and need a guide how to get started with it.

As stated in the previous blog the HCP IoT Services endpoint in trial environment can be found at

https://iotmms[account]/ So, I started similarly to Initial data acquisition in SAP BusinessObjects Lumira tutorial, but instead of “Microsoft Excel”, select “Query with SQL” as a Source. And then search for OData Connector:


Click [Next] button and populate connection attributes: OData URL as above, user and password used to logon to SAP HCP Trial. In my case I do not need any additional proxy settings or any changes to other parameters.


If everything is alright, then clicking [Connect] button should get the service metadata, like the list of tables (known as ‘entity sets’ in OData). Now I just need to find my table with SensorPhone data, which is T_IOT_A7B01790F3E80BC544A3, and select only columns I need, which are the time-stamp and the altitude:

from ""."entities"."T_IOT_A7B01790F3E80BC544A3"


Now just click [Create] and data got acquired as a Lumira’s dataset for further discovery and visualization:


But hold on… What’s that? Only 100 records are available for data analysis:


That’s right. As mentioned the previous blog the OData service in HCP IoT returns only 100 records. Well OData was not designed for massive data movements, and is not the best technology for that.

That’s why in the next blog post I will use SAP BusinessObjects Lumira to connect directly to the SAP HANA database underneath my HCP IoT Service.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Anton Levin
      Anton Levin

      Hello Witalij,

      a built-in OData Consumption API [1] may return more than 100 records. Please, use OData top and skip query options [2] for that. For example: ../app.svc/<SCHEMA>.T_IOT_<MESSAGE_TYPE_ID>?$skip=0&$top=500



      [1] SAP HANA Cloud Platform Internet of Things Services

      [2] URI Conventions (OData Version 2.0) &amp;middot; OData - the Best Way to REST

      Author's profile photo Witalij Rudnicki
      Witalij Rudnicki
      Blog Post Author

      Hello Anton. Yes, I did mention in my previous blog how to return more than default nr of entities in OData. It just does not work with SAP BusinessObjects Lumira as OData acquisition there in Lumira as only limited number of OData parameters are supported and $top is not one of them.