Skip to Content

Store sensor data in SAP Vora in SAP Data Hub, developer edition 2.3

test
0 %
Store sensor data in SAP Vora in SAP Data Hub, developer edition 2.3
Details
// Explore More Tutorials

Store sensor data in SAP Vora in SAP Data Hub, developer edition 2.3

11/08/2018

Use SAP Vora to store sensor data by using SAP Data Hub, developer edition 2.3.

You will learn

During this tutorial, you will store sensor data in SAP Vora. Thereto you will load the data which you have stored in HDFS to SAP Vora.


Step 1: Add and configure SAP Vora Loader

Open the pipeline which you have created during the previous tutorials (test.myFirstPipeline) in the modelling environment http://localhost:8090.

Add a ToString Converter operator and a SAP Vora Loader operator to the pipeline by drag & drop. Then connect the outFilename out port of the Read File operator to the ininterface in port of the ToString Converter operator and also connect the outstring out port of the ToString Converter to the filename in port of the SAP Vora Loader.

picture_01

Configure the SAP Vora Loader operator. You need to maintain the following properties:

Property                                    Value
initStatements CREATE TABLE IF NOT EXISTS VORA.SENSORDATA (counter INTEGER, deviceid INTEGER, temperature DOUBLE, humidity DOUBLE, co2 DOUBLE, co DOUBLE, lpg DOUBLE, smoke DOUBLE, presence INTEGER, light DOUBLE, sound DOUBLE) TYPE DATASOURCE STORE ON DISK;
tableName VORA.SENSORDATA

Click on the text box for Vora Connection. Select Manual as the Configuration Type and maintain the following configuration :

picture_03

Click on Save. Scroll down in the configuration list and select HDFS as Storage Service (1). Then click on the text box for HDFS Connection (2). Now maintain the following configuration :

picture_04

Afterwards press the Save (3) button. Also Save the changes to the graph.

Log on to answer question
Step 2: Execute the data pipeline and check result in SAP Vora

Press the Run button to execute the pipeline.

When the Status tab indicates that the pipeline is running, wait a moment and then open the SAP Vora Tools http://localhost:9225.
Find table SENSORDATA on the left (1) under the VORA schema and click on the table name. Then press the Data Preview (2) button.

picture_02

Stop the pipeline by pressing the Stop button.

Attention: If no data is stored in SAP Vora, you can add a Terminal operator to the pipeline and connect it with the result out port of the SAP Vora Loader operator. If you see an error message like could not handle api call, failure reason : execution of scheduler plan failed, you might have incorrectly connected the Kafka Consumer2 operator and the ToString Converter operator. Please review the previous tutorial.

Log on to answer question

Next Steps

Back to top