Real-Time analytics on SAP ESP’s streaming data using SAP BusinessObjects Design Studio for IoT use cases.

IoT (Internet of Things) is where the huge network of devices are connected to the Internet, including smartphones and tablets and almost anything with a sensor on it – cars, machines in production plants, jet engines, oil drills, wearable devices, and more. These devices send high-velocity data at real time.

One of the most advanced tools from SAP is the ESP (Event Streaming Processor) which can capture, analyze and alert/act on this high-velocity data. This helps to monitor the real-time data streams, produce real-time alerts and respond immediately. It can run real-time stream processing and analytics on huge volumes of complex event data.

Here in this blog, I will explain how I was able to do reporting on real-time high-velocity data using SAP BusinessObjects Design Studio. This is the architecture of how the SAP IoT streaming application would look.iot_hana_arch

High-velocity data coming from sensors (Raspberry PI) is captured by smart data streaming. Smart data streaming stores the data into SAP HANA. This data can be moved to dynamic tiering once the data becomes warm. Real-time reporting on this high-velocity data (Short term analytics) can be performed using SAP Design Studio. The long-term analysis is done using SAP Lumira reporting tool. Long-term analysis is done on the SAP HANA data and also on the warm data stored in dynamic tiering.

 

Product version: SAP Design studio version is: 16.2.1

In order to do the real time reporting on the high-velocity data using smart data streaming do the following steps:

  1. Configure the web service provider (WSP) for the SDS project.

Basically, in this step, I am configuring the web service provider (WSP) for my Smart data streaming project. This will enable me to connect the SAP Design studio to smart data streaming project windows on which real time reporting can be performed. For SAP Design studio I will be using the Rest port.

Go to $STREAMING_HOME/wsp/wsp.xml to enable the Web services. Do the following changes to the wsp.xml as shown below.

  • Change the value of the “enabled” attribute of the webService tag to “true” : <webService enabled=”true”>
  • Change the value of the protocol tag to “http”: <protocol>http</protocol>.
  • Within the webService tag change the resPort tag value or use the default REST port to 9091.

wsp_xml2.Run the WSP

In this step, we will run the web service provider. In order to run it do the following steps:

  • JAVA_HOME should be set before we can run the web service provider. As you can see the java run time is used to run the web service provider.

JAVA_HOME= $STREAMING_HOME/lib/jre

  • You can run it in either foreground or background. It is preferred to run it in the background using “&” at the end. Here I have run it in the foreground. This will enable the rest port that can be used to connect to the SAP Design studio.run_wsp

3.Configure the smart data streaming source in SAP Design studio:

In the SAP Design Studio select the streaming source as shown below.streamingds

4.Configure and test the streaming source in SAP Design studio:

Go to the additional properties of the streaming source and provide the following information.

  • Provide the hostname or IP address of the smart data streaming host.
  • Provide the rest port which we have configured for the web service provider. This was configured in step 1.
  • Provide the credentials and say connect/reconnect. It should turn green.
  • Then you can select the workspace, Smart data streaming project. After that select the window (topic) which is present in the smart data streaming project on which we want to do real time reporting. Then select the retention policy.

In the next tab model the dimensions and measures. Add the chart and use these dimensions and measures.additionalprop 5.Run the SAP Design Studio report

Build a report and now you should see a real-time streaming data in your report as shown below.pd_dVp

Happy streaming !!!!!!!!!!!!!!!!!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s