IIoT System: Node-Red - Python OPCUA "Server & Client" - PLC S71500 "Python Snap7 - MySQL - AWS

Here we have:
Python OPCUA Server With Two Clients:
• Python Client
• Siemens PLC S71500
The Server has two parameters:
• D1: Linked with The Python Client
• D2: Linked With Siemens PLC S71500
The Parameter values can be changed from the Server and also from the Clients.


Here is a question When Changing the value of D2 in the OPCUA Sever, How does the Value of D2 change in the PLC Datablock?
I use Snap7 Python Library for that. The new Value of D2 will go to Snap7 Python Library and send it to the Siemens PLC S71500 using S7 Communication, as I don't have a real PLC I use PLC Sim Advanced.


After That, We have a simple GUI To write the values of D1, D2 Using Python Tkinter Library.


After That, I designed a Dashboard using Node-Red To:
• Read & Write & Monitor & Apply Queries on the Data D1, D2.
• Store the Values in MySQL Database.
• Send the Data to AWS using IOT CORE and MQTT then store it in DynamoDB Database inside AWS.
• Store the Data in the InfluxDB Timeseries Database.
• Design another Dashboard on Grafana to Monitor the Data in a better way than Node-Red, with this Dashboard It's easy to select the period you wanna monitor the Data in.
• Create Excel Reports containing the Current Data Values.
• Send E-mails Reports containing the Current Data Values.
• Telegram Bot to Monitor the Current Data Values.

Check my Linkedin Profile:
https://www.linkedin.com/in/basel-abdallah-11b1b318a/