TwinCAT Database Server
Many applications require backup of current variables from the PLC in databases. Conversely, recipe values often have to be loaded from a database during operation and processed directly in the PLC. The TwinCAT Database Server is used for logging PLC data in a database. Different database variants are available:
- SQL/SQL Compact (previously “SQL Mobile”)
- Access
- ASCII
- ODBC
- Oracle/DB2/MySQL
- PostgreSQL/Firebird/Interbase
The TwinCAT Database Server enables:
- cyclical logging of PLC values,
- cyclical checking of PLC values and logging of modified values only, and
- logging of event-driven data from the PLC cycle via a function block.
Individual PLC variables and also structures can be exchanged with the database.
The database server supports authenticated access to the database. PLC function blocks for creating a database, a table and logging of data (appending or overwriting of data sets in the database or in ring buffer mode) are available. The system can optionally be configured with a user-friendly configurator. A corresponding XML file with databases, ADS devices (e.g. PLC run-time) and transactions is described.
| Ordering information | |
|---|---|
| TwinCAT Database Server | licence for using the TwinCAT Database Server for logging of PLC data in a database |
| TwinCAT Database Server CE | licence for using the TwinCAT Database Server CE for logging of PLC data in a database for Windows CE platforms |