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
Course Content
- What is database?
- Installing database software - MySQL
- How to create your first database and table
Section 2: Understanding basic MySQL commands
Course Content
- How to INSERT values in the database via query
- How to SELECT values in the database via query
- How to UPDATE values in the database via query
- Accessing OPC UA server in PLCnext via Node-RED
- How to DELETE values in the database via query
Section 3: Database management via Node-RED
Course Content
- How to connect Node-RED to MySQL
- How to execute SELECT and INSERT query via Node-RED
- How to execute INSERT query via Form in Node-RED
- How to view information on the table in Node-RED
- How to execute UPDATE and DELETE query via Node-RED
Section 4: MySQL Dashboard on Node-RED
Course Content
- Node-RED MySQL Dashboard
Section 5: Project 1: Tank Level - Log PLC data in MySQL database
Course Content
- Exercise 1- How to store PLC data in the database
- Exercise 2 - Making UI
- Exercise 3 - Adding timestamp to the database value
- Exercise 4 - Adding timestamp from PLC Controller
- Exercise 5 - Logging only when value changes via 'Subscription'
- Exercise 6 - Logging only when value changes via 'rbe' node
- Exercise 7 - Logging only when value changes - Industrial Example
- Exercise 8 - Making a chart from database values - Industrial Example
- Exercise 9 - Adding another value in a chart - Industrial Example
- Exercise 10 - Comparing values from two processes in a Graph
- Exercise 11 - Sorting values based on timestamp
Section 6: Synchronize Data between PLC and MySQL
Course Content
- Exercise 1- Sync from PLC to Database - Case 1
- Exercise 2 - Sync from PLC to Database - Case 2
- Exercise 3 - Sync from Database to PLC
Section 7: Project 2: 3D Camera/RFID - Log real world data in MySQL database
Course Content
- Exercise 1 - Understanding the project of object measurement and RFID tag reading
- Exercise 2 - Write PLC data to MySQL Database - 1
- Exercise 3 - Write PLC data to MySQL Database - 2
Section 8: Project 3: Login/Logout using database
Course Content
- Introduction to the Login/Logout Project
- Understanding Password Encryption
- User registration
- User login
- User management
- Interlocking screens
Section 9: How to generate reports in Node-RED
Course Content
- Understanding the project
- How to make a simple pdf file
- How to generate reports of real time values in pdf
Section 10: How to read/write PLC info with Google SQL
Course Content
- Understanding the project
- Setting up database in Google cloud
- Interfacing Google Cloud MySQL with Node-RED
- Understanding the Project Part - 1 and 2
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 | Online | One year | €39.00 | |
Interface MySQL with PLC via Node-RED | Online | Lifetime | €49.00 |
📚 Resources
The students get access to all the presentation, project and Node-RED code used in the lessons