The SQL interface of ibaPDA forms the basis for a series of database interfaces via which ibaPDA can read data both from databases as well as write data in databases.

sing the SQL interface you configure and manage the connections to one or more databases. You can configure one or more connections per database. All DB connections can be used simultaneously. The databases can be the same or different systems.

Database systems of different vendors are supported:

• Maria DB

• MySQL

• Oracle

• PostgreSQL

• SAP HANA¹

• SQL Server

The data exchange with the databases occurs via corresponding SQL modules, which are configured according to the specific database system.

The data is accessed with SQL statements.

• Input direction (read)

  • For the reading access, custom SQL queries (e.g. SELECT) are used and their results are mapped to input signals in ibaPDA.

  • In the queries, you an optionally use parameters, which are assigned to the signals, in order to change the queries dynamically during the ongoing acquisition

• Output direction (write)

  • SQL commands (e.g. UPDATE, INSERT) are used for writing access in order to write data from ibaPDA into the database.

  • In the statements, you can optionally use parameters, which are assigned to the signals, in order to write signal actual values.

You can execute queries and commands cyclically or triggered.