on 04-14-2016 1:27 PM
Hi experts
We are currently evaluating the SAP HANA Cloud (SHC) platform for IoT integration. We are now able to send data from the IoT device to SHC and we see the received messages in a database table. It is clear for us so far.
Now we want to implement a notification (e.g. send an e-mail or an SMS) when a new defined message type or content is written to the database. Here is not clear what we have to implement and which SHC services will be involved.
Can anyone shortly explain the architecture of some application?
Thanks in advance!
QIAiot
Hello Qiagen,
for example, with the Processing API you may register a HTTP processing service. See more at [1] Then either forward a complete message or just a notification that the message has arrived to the respective/configured HTTP endpoint (backend) which will trigger an E-Mail or SMS send.
Regards,
Anton
[1] SAP HANA Cloud Platform Internet of Things (IoT) Services
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anton
Thanks for your hint! This seems to be a straightforward way to implement it.
What about when I need more logic in the application. Is it possible to implement a service running on the server and permanently pooling the database to trigger an action when a corresponding message is committed?
For example:
What will be the approach in this case?
Cheers
QIAiot
If I understood your requirements right, you may even skip step 2 with the HTTP processing service approach.
So, what you have is (correct me if I am wrong):
[1] SAP HANA Cloud Platform Internet of Things (IoT) Services
[2] SAP HANA Cloud Platform Internet of Things (IoT) Services
[3] SAP HANA Cloud Platform Internet of Things (IoT) Services
Hello Qiagen,
Did you manage to achieve this? I am also working on something similar, In my case once i get the data in MMS, I want to send it to SAP Backend. could you please help me how to achieve this.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Alternatively, if you have HANA XS DB System bound to MMS, you might want to use HANA XS Triggers [1] and call your procedure before or after INSERT "event" to the DB table i.e T_IOT_<YOUR_MESSAGE_TYPE_ID>
This is not that straightforward as the solution proposed above, of course.
[1] CREATE TRIGGER - SAP HANA SQL and System Views Reference - SAP Library
You can find more "XS Trigger" related examples either on SCN or simply with google search.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.