Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
0 Kudos
Hello everyone! This is the forth blog post based on the following table.

HCP IoT Showcase using Sphero
Part 1: Overview
Part 2: Controlling Sphero using Raspberry Pi and Xbox 360 controller
Part 3: Maze Setup (Hardware)
Part 4: Unit Test (Gathering & Sending Data)
Part 5: Unit Test (MQTT)
Part 6: Integration Test
Part 7: XS Application
Part 8: UI

In this table, I slightly changed names and add one more part to clarify the process clearly.

This blog also explains the highlighted section in the overall architecture.

For your reference, the architecture was also slightly modified because HCP IoT Services recently started to support MQTT protocol (WSS) and I believe adjusting our architecture and codes accordingly would be better.

Through previous blog posts, now we're ready to do some unit tests for gathering sensor data and sending data to HCP IoT Services.

Let's do those 2 unit tests and then bind a new data source (HANA MDC) with IoT MMS (Message Management Service) for developing XS application.

Unit Test 1: Gathering Sensor Data

In order to test on gathering sensor data via GPIO, the first thing you need to do is connecting prepared cables to Rapsberry Pi.

Since there are 16 pairs of infrared sensors, I'll use GPIO 4 to 19. And here is the Python code SAP Korea team used for testing.
import RPi.GPIO as GPIO
import time
# init RPi GPIO
GPIO.setup(4, GPIO.IN)
GPIO.setup(5, GPIO.IN)
GPIO.setup(6, GPIO.IN)
GPIO.setup(7, GPIO.IN)
GPIO.setup(8, GPIO.IN)
GPIO.setup(9, GPIO.IN)
GPIO.setup(10, GPIO.IN)
GPIO.setup(11, GPIO.IN)
GPIO.setup(12, GPIO.IN)
GPIO.setup(13, GPIO.IN)
GPIO.setup(14, GPIO.IN)
GPIO.setup(15, GPIO.IN)
GPIO.setup(16, GPIO.IN)
GPIO.setup(17, GPIO.IN)
GPIO.setup(18, GPIO.IN)
GPIO.setup(19, GPIO.IN)
# display GPIO input data every second
while 1:
oSensor_data_4 = GPIO.input(4)
oSensor_data_5 = GPIO.input(5)
oSensor_data_6 = GPIO.input(6)
oSensor_data_7 = GPIO.input(7)
oSensor_data_8 = GPIO.input(8)
oSensor_data_9 = GPIO.input(9)
oSensor_data_10 = GPIO.input(10)
oSensor_data_11 = GPIO.input(11)
oSensor_data_12 = GPIO.input(12)
oSensor_data_13 = GPIO.input(13)
oSensor_data_14 = GPIO.input(14)
oSensor_data_15 = GPIO.input(15)
oSensor_data_16 = GPIO.input(16)
oSensor_data_17 = GPIO.input(17)
oSensor_data_18 = GPIO.input(18)
oSensor_data_19 = GPIO.input(19)
oSensor_data = str(oSensor_data_4) + str(oSensor_data_5) + str(oSensor_data_6) + str(oSensor_data_7) + str(oSensor_data_8) + str(oSensor_data_9) + str(oSensor_data_10) + str(oSensor_data_11) + str(oSensor_data_12) + str(oSensor_data_13) + str(oSensor_data_14) + str(oSensor_data_15) + str(oSensor_data_16) + str(oSensor_data_17) + str(oSensor_data_18) + str(oSensor_data_19)
print oSensor_data
except KeyboardInterrupt:

Once you run the code as below, you can test whether each infrared sensor works correctly or not.

If the sensor detect something such as Sphero, it will show 1 otherwise it will show 0 as below.

All data will be updated every second as below.

0010000000000000 < if the third infrared sensor (GPIO 6) detects Sphero on the maze

Unit Test 2: Sending Data to HCP IoT Services

Now, let's sending data to HCP IoT Services. The first thing you need to do is activating HCP IoT Services as below.

Then Go to Service and Create Message Types, a Device Type and a Device.

Here are what we created.

  • Message Type for Gathering Data

    • - Name: Sphero_msg

    • - Field 1: username, string (30)

    • - Field 2: companyname, string (30)

    • - Field 3: sensordata, string (30)

    • - Field 4: timestamp, date

  • Message Type for Pushing Data (Not used in this IoT showcase but we just created)

    • - Name: Sphero_push

    • - Field 1: pushvalue, string (50)

    • - Field 2: timestamp, date

Each message type will generate ID. Please copy them somewhere such as notepad.

  • Device Type

    • - Name: Sphero_devicetype

    • - Assigned Message Type 1: Sphero_msg, From Device

    • - Assigned Message Type 2: Sphero_push, To Device

  • Device

    • - Name: Sphero_devices

    • - Device Type: Sphero_devicetype

Please also copy generated ID, Token somewhere.

For this testing, since I'll leverage Python examples in iot-starterkit, clone it on your Rapsberry Pi as below.
git clone

Now, what we will use is under ~/iot-starterkit/src/examples/python/mqtt-over-python.
In addition to that, installing Python MQTT library is required. Please see the instruction in the below link.
Instructions for installing / using the MQTT client

After installing library, we modified the code based on what we created on HCP IoT Services as below (line 74 to 79).
sudo nano

And you also need to rename or copy to and modify it according to your information as below.
# print("Please configure appropriately and then remove this line !"); exit();
# ===== Your specific configuration goes below / please adapt ========
# the HCP account id - trial accounts typically look like p[0-9]*trial
# you only need to adapt this part of the URL if you are NOT ON TRIAL but e.g. on PROD
# hcp_landscape_host='' # this is used on PROD
ndpoint_certificate = "./"
# you can download this certificate file with your browser from the app server in your landscape - it is used to check that the server is authentic
# we also provide the certificate that is valid in July 2016 at our github repo
# the following values need to be taken from the IoT Cockpit
# the device specific OAuth token is used as MQTT password
# ===== nothing to be changed / configured below this line ===========

Once you run the as below, you'll see messages are sending to HCP IoT Services.

If you check the table from HCP IoT Services Cockpit, you can find the data sent from Raspberry Pi as below.

Then if you click OData API upper right, it provides API that you can easily consume OData from this table.

In this way, we did 2 unit tests for gathering and sending data.

Binding a new data source (HANA MDC) with IoT MMS

The next thing is unbind current data source for IoT MMS and bind a new data source for developing XS application.

We will create some additional tables in upcoming blog post to build our XS application by joining tables. And the first thing you need to do is creating a new database/schema using HANA MDC.

Since SYSTEM don't have enough roles for SAP HANA Web-based Development Workbench, you need to assign roles.

In my case, I just assigned all roles with "ide" via SAP HANA Cockpit as below.

Then delete the current binding in your_hcp_account_id.iotmms.web via Persistence - Databases & Schemas - your_hcp_account_id.iotmms.web - Data Source Bindings as below.

In the same menu, Persistence - Databases & Schemas, choose HANA MDC you created this time and bind the iotmms with your HANA MDC.

Then restart your iotmms via Applications - Java Applications and do the run again on your Raspberry Pi.

If you check HCP IoT Services Cockpit again, you can see the data as below.

Now, you can also check the data via SAP HANA Web-based Development Workbench - Catalog as below.

That's it. Thank you for reading this blog. Let me get back to you soon with next posting.