Get access to more than 50+ HQ videos with quiz and resources tp learn how to store PLC data in MySQL database via Node-RED
🗒️ Introduction
The industry data is playing a significant role in the decision-making process. It is very important to know how to fetch data from the shop floor and convert it into information.
There are thousands of sensors on the shop floor which are reading data from the process every millisecond. As a PLC Programmer, we know we cannot store all the information in the PLC memory as it has some limitations. To store the data from the last 5-10 years or more, we need an external database.
In this course, you will learn how to store the data from Siemens S7-1200 PLC or any other controller in an external database like MySQL with the help of Node-RED.
You will learn how to search, insert, update, or delete data from the database via Node-RED programming.
📚 Curriculum
Section 1: Introduction
Section 2: Understanding basic MySQL commands
Section 3: Database management via Node-RED
Section 4: MySQL Dashboard on Node-RED
Section 5: Project 1: Tank Level - Log PLC data in MySQL database
Section 6: Synchronize Data between PLC and MySQL
Section 7: Project 2: 3D Camera/RFID - Log real world data in MySQL database
Section 8: Project 3: Login/Logout using database
Section 9: How to generate reports in Node-RED
Section 10: How to read/write PLC info with Google SQL
Preview
👨🏻💻 Hardware & Software
The following is the recommended hardware and software to use along with this course:
| Name | Type | Remarks |
|---|---|---|
Computer or Laptop | Hardware | Well, I hope you would be having it 😎 |
S7-1200 PLC | Hardware | It's optional. If you do not have a PLC, you can also use PLCSIM from TIA Portal and interface with OPC UA inside Siemens PLC via Net2PLC. You can also use any other PLC which supports OPC UA or MODBUS |
Node-RED | Software | An open-source software |
FACTORY I/O | Software | 3D Simulation software to visualize industrial control system |
MySQL Workbench | Software | To store the PLC or controller information in the database |
Check the web-links for hardware and software at this page
💲 Price and Enrollment
Get 10% off by using the coupon code WIKI while checking out
| Course name | Type | Validity | Price | Enroll |
|---|---|---|---|---|
Interface MySQL with PLC via Node-RED | ||||
Interface MySQL with PLC via Node-RED |
📚 Resources
The students get access to all the presentation, project and Node-RED code used in the lessons