Query external mysql database

1

I would like to query (and insert) data from/into an external mysql database from openremote. Does anyone have any ideas how this could be done? My current thinking is to wrap the database in an API and then use an http call to retrieve it… although not sure I can get a list of data to display in openremote…

2

Hi cheezy, I’m not really into DBs but I think you should consider to integrate your openremote instance with something like node-red. I found it really useful and easy to use, you could put it in a machine and use it to query the DB with something like

https://flows.nodered.org/node/node-red-node-mysql

And then send data via/from MQTT to openremote with the MQTT node

3

thanks, I’ll give it a try.

4

or sync openremote postgres with your mysql