consumption

This directory has the sources for a Python application that prints out the table data sent on behalf of the devices via SAP Cloud Platform Internet of Things to console.

Prerequisites

1. You have SAP Cloud Platform SDK installed https://tools.hana.ondemand.com
2. You have Python installed https://www.python.org (use version 2.7 to make PyHDB work)
3. You have PyHDB (SAP HANA Database Client for Python) installed https://github.com/SAP/PyHDB

Opening a tunnel

• With the help of SDK tools open a tunnel to your IoT MMS schema by executing the following command:

	neo open-db-tunnel --account <user_id>trial --host hanatrial.ondemand.com --id <user_id>trial.iotmms.web --user <user_id>

More you can find at https://help.hana.ondemand.com/help/frameset.htm?9e3f90f2ead74229ac5c8848ed5bf292.html

Running Python script

• Adapt the script with the username and password your received (for example)

	connection = pyhdb.connect(
    	host="localhost",
    	port=30015,
    	user="DEV_C5B3HYBVRENFOUEGJOHDLKC88",
    	password="Mb431JTeboI1l1K"
	)

• Adapt the script with the actual schema name and table name (for example)

	cursor.execute("SELECT * FROM NEO_BBLYMLZWO9ALBF4K93YNMRYW9.T_IOT_M0T0Y0P0E1")

• Use Python (2.7) to run the script by execute the following command:

	python C:\<user_path>\git\iot-starterkit\src\apps\python\consumption\pyhdb\iotpyhdb.py