Can we connect Raspberry Pi to SAP HANA Database

[Former Member]

Hello,

I am trying to connect the raspberry pi to hana database. We are not on HANA Cloud , i wanted to send the sensor data from raspberry pi device to a database table in SAP HANA ?

Question is : If i dont have hana on cloud, will i be able to excecute this scenario.

What are the pre-requisite for the same ?

What all tools / languages we might need to use here in order to get this sensor data read into SAP HANA ?

Thanks,

Harish.

[Former Member · Accepted solution]

Hello Harish,

1. You have to create a table in your HANA system
2. You have to create a XS Project in your HANA System and create a REST odata web service for your table from step 1 - this service must be available from the internet.
3. Write a JAVA or Python script at your Raspberry and send it to your just created web service
   1. As example coding for this you can use the tutorials from the cloud and adjust is a little bit to your REST Web service.
   3. https://github.com/SAP/iot-starterkit

BR

Rafael

[Former Member · Accepted solution]

Thanks Rafael. I am going to try that method this week.

I shall keep you guys posted !!

[Former Member · Accepted solution]

Hello Harish,

Using REST services for HANA IoT project is probably good enough for low volumes of data or simple POCs, but if you're going to have higher levels of messages, using WebSockets is going to be more efficient than REST calls.

Regards,

David

[kedarT]

Hi Harish,

These might help you: