Databases
The TwinCAT Database Server is the link between the TwinCAT PLC and database systems. It supports a wide range of databases. In addition to conventional databases such as Microsoft SQL or Oracle, XML and ASCII files can also be used as databases. With ODBC databases it is even possible to enter database connection strings for communication with databases that are not listed as supported database types.
The two tables below show an overview of which databases are supported on which operating system platforms and which databases are available for data export and import for the TwinCAT Scope.
KaPlatform support
Overview of which database connections are supported by which platform.
Database | Windows | Windows CE | TwinCAT/BSD | |||
---|---|---|---|---|---|---|
| Local | Remote | Local | Remote | Local | Remote |
MS SQL | X | X | - | X | - | X |
MS SQL Compact | X | - | X | - | - | - |
MySQL | X | X | - | X* | X | X |
Oracle DB | X | X | - | - | - | - |
SQLite | X | - | X** | - | X* | - |
ASCII-File | X | - | X | - | X | - |
XML | X | - | X | - | X | - |
ODBC | X* | X* | - | - | X* | X* |
MS Access | X* | - | - | - | - | - |
MS Excel | X* | - | - | - | - | - |
MongoDB | X | X | - | - | X | X |
PostgreSQL | X | X | - | - | - | X |
InfluxDB 1.7 | 1.8 | X | X | - | - | X | X |
InfluxDB 2 | X | X | - | - | - | X |
*additional server or client drivers for the database must be installed on the device
**applies only to devices with ARM architecture
TwinCAT Scope support
Overview of which databases are supported for data import and export in TwinCAT Scope. The TwinCAT Scope always works together with the TwinCAT Database Server.
Database | Scope Export | Scope Import |
---|---|---|
MS SQL | X | X |
MS SQL Compact | - | X |
MySQL | - | X |
Oracle DB | - | X |
SQLite | - | X |
ASCII-File | X | X |
XML | - | X |
ODBC | - | X |
MS Access | - | X |
MS Excel | - | X |
MongoDB | - | - |
PostgreSQL | - | X |
InfluxDB 1.7 | 1.8 | - | X |
InfluxDB 2 | - | X |
The configuration of the individual databases and mapping of the data sets in the PLC is explained on the following sections.