Node-RED: Get Data from PAC to MS SQL



Introduction to Node-RED tutorial shows how to to send data to an MS SQL database from an Opto 22 SNAP PAC controller.

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.

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: