PLC and database

Hey there!

I'm working with Tia Portal V11, a PLC(s7-1200 CPU1215) and the webserver. I also need to log some information in the database. Sadly the webserver of the PLC isn't working with PHP, this is the programming language you use to get information from your website and insert them in a database.

So my question is: How do you log your information and set them in a database without using PHP.

Regards,

Bart

A lot of PLCs have database functions that will interface directly to an SQL server rather than trying to do SQL commands with php on the webserver.

I just looked it up and Tia Portal is a Siemens product, making everything in your question Siemens related, you should put that in the title to get better information (and probably call Siemens support).

You could log the data from the PC (can be the SQL server) with the Ignition SQL Bridge. You can download a free trial to set it up. They have a native S7 driver included.

PDSql Library for S7-1200 S-1500 in TIA Portal V13 V14 V15

PDSql Library V1.2.0 for TIA Portal

SQL Library V1.2.0 Siemens S7-1200 / 1500 TIA Portal User Guide

PDSql EventHandler Example S7-1200

PDSql EventHandler Example S7-1500

You can also use SQL4automation. You can communicate directly with SQL strings out of your Siemens S7 PLC. Almost all Siemens PLCs are supported. On the other side all SQL databases with ODBC interface are supported.


Download the demo version here: https://www.sql4automation.com/en/li...s/download.php


Look also at the video tutorials here: https://www.sql4automation.com/en/vi...rial/index.php