Hello SIOS forum community,

The question about how the SIMATIC S7-1200/S7-1500 controllers are connected to an SQL database has often been asked. Various options are available for this:

1. The following application example is available for connecting an S7-1200/S7-1500 controller to a Microsoft SQL server. The application example must be adapted to the application. All data are processed on the controller.

Connecting a S7-1200 / S7-1500 to a SQL Database

2. A connection to an SQL database is possible via the WinCC option WinCC/IndustrialDataBridge (IDB). This solution is suitable for quick integration without knowledge of high-level languages. A license is required for the IDB. The customization options are limited with the IDB. Further information can be found in the following entry:

WinCC/IndustrialDataBridge: Writing data from SIMATIC WinCC or from SIMATIC controllers in MS Office files

3. WinCC PC Runtime can be used as a gateway for communication with the SQL database via a script. This solution enables dynamic adaptation. High-level language skills are required for this. WindowsCE-based panels cannot access an SQL database.

In WinCC (TIA Portal) and WinCC flexible how do you access an SQL database via a script?

4. The following SQL driver is available for an S7-1500 software controller. This possibility can be adjusted dynamically. A license is required for the SQL driver.

SIMATIC ODK 1500S SQL driver

With best regards

SIMATIC International Technical Support Hub