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
MS SQL Node
SNAP PAC Read Node
SNAP PAC Write Node
TSQL language
Mustache formatting
State data
Report by exception (RBE node)
Insert statement

More FREE online training

OpenWeatherMap tutorials:

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

[wick_bourne]

Hi Opto team, I have one question. You have setup SQL server on AWS; So, so you have used AWS RDBMS service or you have installed MSSQL on AWS EC2 instance?

[chickenclips]

great video as always - but can you please show us how to do it the other way round? Pull data from a table in SQL and then post it back into PAC

[samirmj]

Please show how to configure MS SQL. I am using SQL 2017 and having hard time configuring it.

[RonenLin]

Great tutorial! I'm just starting with all of this, I am trying to find a way to write to MySQL via node-red my RFID tag on scan. Is there a property in node-red that can trigger a db write when rfid is triggered (USB rfid in my case)?

[rohankhut]

I am using MSSQL node and I frequently get connection closed error. Cant get rid of it. Any idea how do we handle this ?

[nntengineering]

Want you to preview To receive analog value via chip mcp3008. Thank you.

[mrahman]

Does anybody know how to add an MSSQL node when the SQL runs on my local machine? I tried npm install node-red-contrib-mssql but I don't see any MSSQL element under storage? Any idea?

[fbarranha]

Is it possible to use MariaDb or Mysql Database?

[jonny]

do I always need to be logged into node red to run the program or can I compile the program and export it elsewhere, so that I can run it without needing the use of the internet. As my internet isn't the best but I want to control my I/O relays of my ds3484 without needed to be connected to the internet. Is this something node red is able to do?
or does it run on a server-based system?

[benzemamumba]

That's NOT mySql that is MSSQL (Microsoft Sql). I do not know how you got those confused