IOT in Hana MDC(Multitenant Database Containers)

[Former Member]

Hi Experts,

     As you all know SAP HANA  Instance feature has going to shut down, I am trying to Implement IOT with Hana MDC Database. Earlier we have implemented the whole IOT thing using XS. Now we have changed the Database binding to HANA MDC.

    We have imported all the datas into MDC but during development we are facing issue while activating hdbrole.

     This is new approach for me please guide me here.

Thanks,

Shalini T

[anton_levin · Accepted solution]

I just tried the IoT setup myself. Some of the parts are not required anymore on MDC. So, the minimum setup is:

.xsapp

{}

.xspriviliges

{
  "privileges" : [ {
  "name" : "Basic",
  "description" : "Basic IoT MMS privilege"
  } ]
}

.xsaccess

{
  "exposed" : true,
  "authentication" : [ {
  "method" : "Form"
  } ],
  "authorization" : [ "pXXXXXtrial.iotmmsxs::Basic" ]
}

iotaccess.hdbrole

role pXXXXXtrial.iotmmsxs::iotaccess
{


application privilege: "pXXXXXtrial.iotmmsxs::Basic";


}

iotservice.xsodata

service {
  "SYSTEM"."T_IOT_M0T0Y0P0E1" key generate local "GEN_ID";
}

Do not forget rom ../sap/hana/ide/security/ UI for your SYSTEM user assign an Application Privilege 'pXXXXXtrial.iotmmsxs::Basic'

Then OData service is accessible https://iotmmsxspXXXXXtrial.hanatrial.ondemand.com/pXXXXXtrial/iotmmsxs/iotservice.xsodata/T_IOT_M0T...

Regards,

Anton

[anton_levin · Accepted solution]

P.S. IoT StarterKit has been updated iot-starterkit/src/apps/xs/consumption at master · SAP/iot-starterkit · GitHub

[Former Member · Accepted solution]

Thanks Anton. Working Fine...:)

[anton_levin]

Hello Shalini,

please ensure you have all the roles required for Web based tools granted to your user like described in the documentation [1]

Regards,

Anton

[1] SAP HANA Cloud Platform

[Former Member]

Hi Anton,

I have already set this role for work bench. Please Find Attached Screenshot for reference.

Thanks,

Shalini T