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]/com.sap.iotservices.mms/v1/api/http/app.svc. 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:

LumiraNewOData.png

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.

LumiraNewODataConnection.png

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:


select C_TIMESTAMP, C_ALTITUDE
from "com.sap.iotservices.mms.SYSTEM"."entities"."T_IOT_A7B01790F3E80BC544A3"


LumiraNewODataEntitySelection.png

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

LumiraNewODataEntityDataSet.png

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

LumiraNewODataEntityDataSet100.png

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.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

    1. Witalij Rudnicki 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.

      (0) 

Leave a Reply