SAP Hana 2.0 SP1 – Smart Data Streaming & DT Combined with Raspberry Pi Part-2

Continued SAP Hana 2.0 SP1 – Smart Data Streaming & DT Combined with Raspberry Pi Part-1

Install Smart Data Streaming and add the service to the tenant

Smart Data Streaming installation for my scenario consist of several package software to downloads such as:

Note: I will not cover the SDS Studio installation portion but it’s already installed on my side

Once all downloaded, I start to run the installation of the server part from the cockpit

Note: You need to specify the Hana client source install folder if it’s not already installed

Continue and add the new role to the dedicated host

Review the configuration and update the system

The installation is completed successfully

My Streaming service is ready; I will then add it to my tenant database. I run the following statement

And we can see my Streaming link from the Tenant cockpit now

Now I need to initialize it since it not done yet.

To initialize my tenant i run the statement below from the console on the tenant database

And I can see now that streamingserver service appear as “master”

To make further validation, at OS layer 2 new folder should have been created “cluster” and “hb1”, which is what I can see

Smart Data Streaming based installation is now completed; from a summary perspective, all the server portion are completed such as:

• Dynamic Tiering
• Hana Cockpit
• And Smart Data Streaming

From a VMware point of view here is the consumption on memory and cpu side per vms

I will now proceed with the Streaming Lite Specialized Component setup

Configure Raspberry PI with Streaming Lite Specialized Component

Streaming lite is a to-the-edge component designed to deploy streaming projects on remote gateway devices such as Raspberry PI.

For my configuration, I’m using a Raspberry PI 3 Model B in conjunction with GrovePI+, I will use 3 type of sensors from Seeed to capture data:

Air Quality Sensor v1.3 – SKU 101020078

Temp&Humi Sensor – SKU 101020011

Gas Sensor(MQ3) – SKU 101020006

Reference and website can be found from the link at the beginning of my document at “Link used”

In term of component deployment point of view, Streaming Lite will be install on my Raspberry PI and will streams output via WebSocket to Smart Data Streaming

This portion of setup will consist of:

1. Deploy Streaming Lite component on my Raspberry PI
2. Check Smart Data Streaming Web service enablement
3. Build Smart Data Streaming project
4. Build Streaming Lite project
5. Retrieve sensor data and load them into Streaming Lite project
6. Check live data streamed and received in Hana

Deploy Streaming Lite component on my Raspberry PI

The Streaming Lite component is a tar package that need to be decompress at the location of your choice, once done the “install” will be there.

To run Streaming Lite script i must set the variable environment “STEAMING_HOME” accordingly. I will do it in root user .bashrc

And I run I quick check on startup project, it’s good

Check Smart Data Streaming Web service as enablement

Now done, from the cockpit I will make sure the Web Service is enable for Smart Data Streaming

Note also the port used because it will be use later for the web output adapter

Now checked I can start to build my project in Hana studio for Smart Data Streaming

Note: Make sure to install the plug-in as “Administrator” for windows client machine