Practical Tips and Techniques
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 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
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
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
We will now be installing the Node-RED software on our Windows 10 computer. 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 … Read more