Database, Client

Database, Client enables the export of process data to a database. The module supports secure data transfer and authentication for all database types.

Supported databases:

• MSSQL Version MSSQL 2000 (TDS 7.1) or newer
• MySQL
• MongoDB
• Microsoft Azure 'Cosmos DB' via MongoDB

Operating mode

The current process image is written during startup or when the connection is interrupted, i.e. the current values of all configured data points are sent to the database.

After the initialization of the process image, only data point changes are written.

All data point entries have the following attributes:

• Timestamp
• Value
• Quality
• Data point type
• Data point designation
• Transmission direction
• Module or protocol stack

In case of connection errors or delayed data writing, the data point changes are chronologically buffered and processed in the buffer. A buffer overflow is treated like a connection termination, so that the buffer is deleted, and the entire process image is written.