Use Node-RED to Send I/O Data to MS SQL

This Node-RED tutorial shows how to to send data to an MS SQL database from an IoT controller. In this video you will learn how to use Node-RED to get physical I/O data from a PAC controller & log it to an MS SQL database.

Tips include:
Logging I/O data to a time series data table in an MS SQL database on an Amazon Web Services cloud.
Time series data table
SNAP PAC Read Node
SNAP PAC Write Node
TSQL language
Mustache formatting
State data
Report by exception (RBE node)
Insert statement

Learn more at

More FREE online training

OpenWeatherMap tutorials:–x7……

All Opto 22 products are designed, manufactured, and supported in the U.S.A. from our Temecula, California headquarters and factory.
#api #nodered #node #groov #JSON #IoT #Tutorial #learnprogramming #programming #IIoT #automation #javascript

Comments are closed.