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

Click Plus PLC MQTT Communication

Click Plus PLC MQTT Communication

We will now look at the MQTT communication capability using our Click plus PLC. MQTT stands for Message Queuing Telemetry Transport. This simple ‘publish and subscribe’ communication protocol, does not take too many resources. Constrained devices with low bandwidth are ideal for MQTT. This protocol provides machine-to-machine (M2M) connectivity which is ideal for the Internet … 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

Click Plus Software Installation Version 3.00

Click Plus Software Installation

The Click Plus PLC has now been released. This can only be programmed with version 3.00 or higher of the Click Programming Software. Version 3.00 will program all of the Click PLC CPU units and add additional features to the Click Ethernet CPU units. Features of the new Click PLUS PLC (C2-0xCPU) includes the following: … Read more