Node-RED: Get Data from PAC to MS SQL

Summary

Summary

In this video, you'll learn how to use Node-RED to get physical data with I/O and log it to an MS SQL database and about: 

  • 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