Where does mms store push messages to device for MQTT protocol?

[Former Member]

For HTTP it stores push messages (to device)to T_IOT_HTTP_PUSH table, but for MQTT where does it store?

Also for HTTP data service, it has endpoint to access messages like this:

https://iotmms<accountid>.hanatrial.ondemand.com/com.sap.iotservices.mms/v1/api/http/data/<deviceId>;

Does MQTT data service have any endpoint like the above to access messages pushed to device?

If not, is there anyway to store pushed messages into database through endpoint?

[anton_levin]

Hello Hiral,

for WS and MQTT messages addressed for the device are not stored by the IoT MMS but pushed to the device directly [1]. A device must be connected, otherwise IoT MMS will respond with "Device Not Connected" response.

If you would like to store the messages sent to the device over MQTT and WS, you would need to do it yourself after device receives them.

Please also be aware that for HTTP case, MMS keeps those messages in the *PUSH* table for 1 hour (default value). This could be changed in the MMS Configurations > "Clean-Up Interval for HTTP Push Messages" property.

Hope this helps,

Anton

[1] https://help.sap.com/viewer/7436c3125dd5491f939689f18954b1e9/Cloud/en-US/9da1c18f6ab947c58052f4d0749...

[Former Member]

Yes!!! Thanks for it, but now, how can I store the messages sent to the device over MQTT,after device receives them. Is there any endpoint to store those messages in table (like T_IOT_pushMessages) of SAP database and then access it through the following endpoint:

https://<host>/com.sap.iotservices.mms/v1/api/http/app.svc/<table name>

[Former Member]

Hi Anton Levin,

Thanks for the reply, is there a way to store the messages sent to the device over MQTT(after device receives them), in SAP database table like T_IOT_MYTABLE, and then access it with endpoint like : https://<host>/com.sap.iotservices.mms/v1/api/http/app.svc/<table name>

[anton_levin]

Hello Hiral,

consider to use SAP HANA / SAP ASE Service [1] for persistency in SAP Cloud Platform. You may expose that data with RESTful or OData API then.

Regards,

Anton

[1] https://help.sap.com/viewer/d4790b2de2f4429db6f3dff54e4d7b3a/Cloud/en-US/e7b3c275bb571014a910b3fb432...

[Former Member]

Thanks!!it worked