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.