Access hana database for SAPUI5 Dashboards

[Former Member]

Hello community,

I have a SCP trial account (s-user) and I send sensor data to the Cloud using the HTTP-API of the Message Management Service. The data is stored in a hana mdc database. Now my problem: Is there any simple service/API I can use to access the data in a SAPUI5 dashboard? The tutorials I can find require installing SAP NetWeaver AS ABAP on a virtual machine to provide an OData-Service which seems to be very complicated to me for such a simple task. Maybe you can tell me which way this tutorial uses: https://blogs.sap.com/2015/10/26/the-cheapest-and-simplest-way-to-send-sensor-data-to-the-hana-cloud...
Unluckily I can not have a look into the .class files of the java-Application to find out.
I am very grateful for any help

Best regards,
Niclas

[anton_levin · Accepted solution]

Hello Niclas,

I encourage you to take a look at the IoT StarterKit [1] on GitHub where we provide some consumption examples for different setups:

- SAP HANA / ASE Service and Java [2]

- XSJS and/or XS OData [3] (you are using MDC already)

- MMS Built-in OData and UI5 [4]

Hope this helps,

Anton

[1] https://github.com/SAP/iot-starterkit/tree/master/neo

[2] https://github.com/SAP/iot-starterkit/tree/master/neo/apps/java/consumption

[3] https://github.com/SAP/iot-starterkit/tree/master/neo/apps/xs/consumption

[4] https://github.com/SAP/iot-starterkit/tree/master/neo/apps/ui5/consumption-advanced

[Former Member · Accepted solution]

Thank you very much! [4] was exactly what I was looking for. I have found the blog article [5] which was very useful.

Cheers,
Niclas

[5] https://blogs.sap.com/2017/09/02/sapui5-app-for-the-built-in-mms-odata-api-from-the-sap-cloud-iot-fo...

[former_member321811]

Hi,

I never used it but the following API looks like something you could use: https://api.sap.com/shell/discover/contentpackage/IOTAE

Or you could probably find the answer in one of the tutorials on developers.sap.com: https://www.sap.com/developer/tutorial-navigator.tutorials.html?tag=products:technology-platform/sap...

Cheers,

Pierre

[Former Member]

Thanks, I have checked the links. The tutorials don't suit to my problem. I don't understand what the API is doing and how to use it. I would be glad if you can tell me more about it.