By Craig Cmehil
Now connect your IoT Services to an SAP HANA MDC instance and show the data using SAP HANA XS Classic
Now that your IoT Services are collecting data and you were able to view it your deployed Java application, now how about redirecting the data to a shared SAP HANA MDC instance and developing a small SAP HANA XS Classic application to show the data.

From within the cockpit now choose Databases & Schemas.
Create a new SAP HANA MDC instance. MDC stands for Multi-database Container. Your MDC instance is your own within a shared SAP HANA system.

Once the instance has fully created you will need to follow a couple of steps to allocate your user the proper authorizations.
Now select the “SAP HANA Cockpit” link where you will receive two messages indicating a missing authorization followed by authorizations being granted.

Now select the “Manage Users and Roles” where you will apply additional authorizations to your user or to a new user.

Once you here you will select the “SYSTEM” user or right click on the “SYSTEM” user and choose copy user first. Then under the first tab “Granted Roles” you will select the “+” symbol and search for “developer” then select each role listed and mark “OK” then again search for “admin” and do the same. Basically this gives your user “super user” access to the database. As you are currently the only one with access use it wisely.

Now return to your Java applications within the SAP Cloud Platform and choose the iotmms application and then the data bindings option. Delete the existing binding to XXXXXXtrial.iotmms.web database. Then create a new binding to your new HANA MDC instance.

With previous step finished you should be able to go back to your MDC instance and select the “Catalog” under the menu options along the top of the page and see your tables now listed under “SYSTEM” schema - if not return to the IoT Services and send another test message. (see tutorial). So provided you received the “200” status in your messages then you should now have data in your tables and can begin working on your XS application.
Your table T_IOT_XXXXXXXXXXXXX will be the other item you need to make note of for use in a moment.

Choose the “SAP HANA Web-based Development Workbench,” now right click on the top level, Content, and choose Create Application“. Choose the Empty Application” option and the “sub package” - codejam.iotmmsxs

Now you will use the created service in the index.html file.
You will replace the existing code with the following, which is quite a bit but should be easily readable and understandable as we are adding a table to a page.
Make sure you replace
<MESSAGE_ID>below with the name of your table with corresponding message type table, likeT_IOT_15B1E994B520C8D65A42
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta charset="UTF-8"/>
<title>My Sensor Data</title>
<script id='sap-ui-bootstrap'
src='/sap/ui5/1/resources/sap-ui-core.js'
data-sap-ui-theme='sap_goldreflection'
data-sap-ui-libs='sap.ui.core,sap.ui.commons,sap.ui.table'>
</script>
<script language="JavaScript">
var oModel = new sap.ui.model.odata.ODataModel("/codejam/iotmmsxs/services/iotservice.xsodata/", false);
var arrayHeaders = new Array();
oTable = new sap.ui.table.Table("test",{tableId: "tableID", visibleRowCount: 10});
//Bring the table onto the UI
oTable.placeAt("sensor_table");
//Table Column Definitions
var oMeta = oModel.getServiceMetadata();
var oControl;
for ( var i = 0; i < oMeta.dataServices.schema[0].entityType[0].property.length; i++) {
var property = oMeta.dataServices.schema[0].entityType[0].property[i];
oControl = new sap.ui.commons.TextField().bindProperty("value",property.name);
oTable.addColumn(new sap.ui.table.Column({label:new sap.ui.commons.Label({text: property.name}), template: oControl, sortProperty: property.name, filterProperty: property.name, filterOperator: sap.ui.model.FilterOperator.EQ, flexible: true, width: "125px" }));
}
oTable.setModel(oModel);
var sort1 = new sap.ui.model.Sorter("C_TIMESTAMP");
//Replace <MESSAGE_ID> below with the name of your table with corresponding message type table, like T_IOT_15B1E994B520C8D65A42
oTable.bindRows("/<MESSAGE_ID>",sort1);
</script>
</head>
<body>
<div id="sensor_table"/>
</body>
</html>

Example results are below.
This is not the only way to do, but that is a matter for you to explore and discover!