Skip to Content

Run and Test a Project in SAP HANA Smart Data Streaming

test
0 %
Run and Test a Project in SAP HANA Smart Data Streaming
Details

Run and Test a Project in SAP HANA Smart Data Streaming

2019-12-18
Part 7 of 9. Run and test the streaming project using Stream View, Manual Input, and Event Tracer tools.

You will learn

  • Running the project that you built in the previous exercises.
  • Using the Playback tool to simulate a live source and stream in data from a file at a controlled rate.
  • Using the Stream Viewer to view the output from each stream/window in your project.
  • Using the Manual Input tool to manually generate test events and send them into your project one at a time.
  • Using the Event Tracer tool to see how an event flows through the directed graph within the project.

Prerequisites

  • Files: Download the machinedata.csv file, which will be use later for playback during testing.


Step 1: Running the project

In the next steps you will run the project, play some data and view the results.

Go to SAP HANA Streaming Development perspective. Click the drop down arrow next to the Run button and select the streaming server to run this project. You will be switched into the SAP HANA Streaming Run-Test perspective after you have deployed and ran the project.

run the project
Log on to answer question
Step 2: Open the streams

Double-click on MACHINEDATA to open it in the Stream View.

Note: You won’t see any data, because we haven’t loaded any data yet.

go to stream view

Now double-click on each of the other streams/windows to open them in the Stream View tool.

open all tables
Log on to answer question
Step 3: Use the playback tool

Click the Playback tab.

playback

Click Select Project icon in the top right corner of the Playback window to connect the playback tool to the current project (if you had multiple projects running it would ask you to choose).

select project

Click Select Playback File icon shown below to select the data file to use.

select playback file

If you have not downloaded the playback data already, please download the machinedata.csv file included in the prerequisites. In the Open dialogue window, change the file type to .csv. Choose machinedata.csv included in this tutorial and then click Open. You can also press Alt+o.

open file

Click rec/ms. You want to control the playback speed so that you can watch things happen at a reasonable pace. Once it’s running you can speed it up or slow it down using the slider tool. Enter 0.005 in the rec/ms box.

rec per sec

Then click the Start Playback button with icon shown below.

play

Click each viewer tab to view the output from each stream/window.

switch tabs
Log on to answer question
Step 4: Using manual input and the event tracer tools

In the next eight steps you will use manual input and event tracer tools.

Click the Event Tracer tab to select it. Click on the Select Running Project button to connect to a running project. if you have multiple projects running, it would prompt you to choose one.

open event tracer

Click the Manual Input tab.

click manual input

Click Select Stream to connect the manual input tool to the project.

select project

Click on MACHINEDATA and then click OK.

choose project

Fill out input fields as shown in the picture. Use one of the following as the MACHINEID since these are the existing values in the "MACHINE_REF" table that you are using: 2DDDBW3TP, EKM49RTXK, RB82KMY3S, 4CBH7792RN, JMD51RTKK, GGR23RTXK, or 8HRT4WX2. You can alter the other values. Then click Publish button to send the event.

fill info

The colors in the Event Tracer (at the top of studio) diagram shows how each stream/window in the project is affected by the event you just sent. Double-click on each node to view the output generated by that node in response to the event in the Console.

event tracer

Click the Stream View tab.

stream view

Find the entry that you submitted through Manual Input.

find the event
Which stream or window are you manually inserting data into?
×

Next Steps

Back to top