how to read data from mssql and send to groov view
how to read data from mssql and send to groov view
From a high level here is how I would go about it…
Running Node-RED on EPIC, RIO or PC on the same network as the MSSQL server and groov View.
Again, from a high level, there are a bunch of threads to help with this:
https://forums.opto22.com/search?q=mssql
You will have an inject node, then a function node with a select statement, the mssql node, another function node to clean up the data, then finally a groov write node, add a few debug nodes, but really those 5 nodes will select and format your data for display in groov View.
This thread does as much: Writing a groov table with a single node
Have a read, do some testing and then let us know how you get on.