We are investigating if we can receive MQTT-messages in Thinkwise somehow.
So we'd like to subscribe to a MQTT topic which has been published by a device, and based on the message execute some logic in our application.
Someone has setup this in Thinkwise somehow and provide some guideline how to achieve it ?
Thanks.
I have investigated a function like this by using NodeRed (https://nodered.org/)
There you can easily manage the subsicirptions on the MQTT topics, and if needed add some logic there (on MQTT level), and with the MSSQL node you can pass any data to the SQL server.
Another option would be to let NodeRed post the message with an API to your endpoint.
Bases on logic in your Thinkwise Application you can activate flows in NodeRed as well, wich is basically the other way around.
Some links I found earlier:
https://thriveread.com/node-red-with-mssql-sql-server-example/|
Another options is to make a python script to subscribe to MQTT topics with Mosquito, or a similar broker.
Maybe this can help you a bit!
Tried to set it up yesterday and within a couple of hours I had a nice POC up and running.
Visually my POC looks like:
For now I will continue investigating this setup more to see if it is mature enough to run in a production environment.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.