Databases

In WinCC OA, process data is recorded initially in the internal database. The DBLogger provides the additional facility of transferring data to relational databases via standard interfaces (ADO, ODBC, Qt), where the data transferred there by the process control system can be selected and prefiltered (mean values etc.).

The following database systems are supported under Windows by the DBLogger:

  • MySQL 5.6.20

  • MS SQL-Server 2014

  • Oracle Client 12.1.0.2

The following database systems are supported under Linux by the DBLogger:

  • MySQL 5.6.20

  • Oracle Client 12.1.0.2

The required DBs must be installed correctly for the DBLogger to be operational (authorizations, hard-disk space, etc.). All three types of DB can be used in the DBLogger at once, although the number of DBs used in parallel is limited to five for programming reasons. There is no restriction on the number of tables that can be used, and is only limited by the available memory space or the internal limitations of the database systems concerned.

Note: The database names used in the DBLogger must be unique because these names are also used as DP names.

In order to configure a Linux MySQL database from a remote Windows computer execute the following steps:

  1. Install MySQL ODBC driver on the Windows computer.

  2. Add and configure a new data source for MySQL ODBC in the ODBC data source administrator. It is also important that the MySQL database user has the necessary rights to access the database from a remote Windows computer. This can be defined in the MySQL server on the Linux computer.

  3. When creating a new MySQL database you have to enter the name of the ODBC database connection, user name and password. The path is not necessary here anymore. The MySQL database source (host name, port number, user name, password ...) on the Windows computer is configured in the ODBC data source administrator.

After the MySQL ODBC driver was installed on the Windows computer and the database source is configured right you can access the MySQL database from a VISION and create tables (see also Configuring the DBLogger).