Hi all, does anyone have experience using Node-RED, MSSQL (or any on-premises database), and Grafana? I have successfully pushed our sensor readings and log data into MSSQL using Node-RED from Epic. We are planning to create a dashboard to visualize this data for our customers, which is a long-awaited request. I am looking for some suggestions. Additionally, we are not allowed to use any cloud services due to the customer portals, so we are fully limited to on-premises databases only.
@naren
Check out this recent thread on using Grafana, Influxdb and Node-Red, we discuss at length strategies for data collection including local hosting. Using MySQL will be very similar to what is discussed here.
