Node-RED is an enabling software for IoT. (Internet of Things) This means that we can communicate to control and read information from industrial equipment. Logging of information to databases and analyzing this information is easily achieved. Node-RED provides an efficient and easily implemented control solution.
Node-RED IoT Enabling Software Series
Installing the Software
Modbus RTU / TCP Communication
– Display Information on a user interface, HMI, or dashboard
We will be controlling the Solo Set Value through the local dashboard interface or with the information read from the Click PLC.
Node-RED User Interface – Dashboards – Video
Node-RED SQL Database Log
Node-RED can easily log data to a database. SQL (Structured Query Language) can be used to communicate to a SQL database.
We will be creating an SQLite SQL database. SQLite Studio will be used to design the structure of the database. (Tables) Installing the node-red-sqlite-node palette will allow us to log the information from our Solo process temperature controller, Click PLC, and dashboard variables.
Node-RED SQL Database Log – Video
Node-RED SQL Database Spreadsheet Connection
We will now look at the connection to our SQL database using a spreadsheet application. Previously we used Node-RED to communicate Modbus TCP and RTU to our Click PLC and Solo Temperature Controller. The information collected from the controllers was then put into an SQLite SQL database.
Spreadsheets like Excel are great for the analysis of the data. We will be connecting to our SQLite SQL database with WPS spreadsheets. This will be accomplished by using an ODBC driver as the translator between the database and spreadsheet.
Node-RED SQL Database Spreadsheet Connection – Video
Additional Node-RED Links:
Install Node-RED on Raspberry Pi 4
Simple Click Data Logging
Node-RED is a powerful and easy programming tool that will allow you to join together hardware devices, APIs (Application Programming Interface), and online services. This joining of information is part of the smart factory. Internet of Things (IoT), Industrial Internet of Things (IIoT), Industry 4.0, and Smart Production are just a few of the other labels that have been applied to this type of technology.
Node-RED provides a browser-based flow editor. This provides an easy way to visually see and modifies your program flow. Flows can then be deployed to the runtime in a single click. Node-RED is built on Node.js. This lightweight runtime can be deployed on low-cost hardware (Raspberry Pi ) or cloud services (Microsoft Azure). This has the ability to bring data collection, analysis, and storage closer to the actual device. Real-time edge computing can then be achieved without latency issues.
If you’re like most of my readers, you’re committed to learning about technology. Numbering systems used in PLCs are not difficult to learn and understand. We will walk through the numbering systems used in PLCs. This includes Bits, Decimal, Hexadecimal, ASCII, and Floating Point. To get this free article, subscribe to my free email newsletter.Use the information to inform other people how numbering systems work. Sign up now.