Node-RED SQL Database Spreadsheet Connection

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 analysis of … Read more

Node-RED SQL Database Log – Modbus Logging

Node-RED SQL Database Log - Modbus Logging

Node-RED can easily log data to a database. SQL (Structured Query Language) can be used to communicate to a SQL database. Databases separate analysis from the data unlike spreadsheets like Excel. The database is designed to hold more information than spreadsheets and allow multiple users to access the information. We will be creating an SQLite … Read more

Click Plus Establish Communication

Click Plus Establish Communication

We will now establish communication using four different methods from our computer to the new Click Plus controller. The click programming software version 3.00 will be used for the communication methods. Click Plus controllers allow you to program them through the micro USB port on every CPU. WiFi (Bluetooth Provisioning) is also available on some … Read more

Node-RED User Interface – Dashboards

Node-RED User Interface - Dashboards

Node-RED can easily display interactive information to the user or operator using a web browser on your phone, tablet, or computer. Any device that has access to the network in which node-red is running. We will be installing the node-red-dashboard palette. This allows us to create a live data dashboard user interface. (UI) The information … Read more

Node-RED Modbus RTU / TCP Communication

Node-RED Modbus RTU / TCP Communication

Node-RED can easily connect to industrial controls using Modbus communication. Modbus is a master-slave type of communication. Masters will always send the commands to read or write to the slaves on the network. The slaves will respond if the communication is directed at them. We will be installing the node-red-contrib-modbus palette. This will allow us … Read more

Productivity Open P1AM Arduino Modbus TCP Client to Click PLC

Productivity Open P1AM Arduino Modbus TCP Client to Click PLC

We will now connect our Productivity Open P1AM Arduino to a Click PLC. Using Modbus TCP the Arduino will be the Client (Master) and the Click will be the Server (Slave). We will explain how to connect our P1AM-ETH Industrial Arduino Ethernet Shield to the Click PLC. The protocol will be Modbus TCP on an … Read more