Mssql 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:

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.