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
MS SQL Node
SNAP PAC Read Node
SNAP PAC Write Node
TSQL language
Mustache formatting
State data
Report by exception (RBE node)
Insert statement
Learn more at http://developer.opto22.com
http://workshops.opto22.com
http://www.opto22.com
https://nodered.org
https://discourse.nodered.org/
https://forums.opto22.com/
More FREE online training
https://training.opto22.com/
OpenWeatherMap tutorials:
https://www.youtube.com/watch?v=B–x7…
https://www.youtube.com/watch?v=dZiqR…
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