Make queries to databases (MySQL, MS SQL or whatever) from a Beckhoff-PLC through The ADS-Communication and a script in python. The script can be deploy in the same PLC if it has an operation system to allow it, or somewhere else.
- PLC-Program in Codesys 3
- Script in python
$ pip install pyads
$ pip install pyodbc
$ pip install mysql-connector-python