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.
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:
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:
select C_TIMESTAMP, C_ALTITUDE from "com.sap.iotservices.mms.SYSTEM"."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.