SQL database interface

Description

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.

The connections to one or more databases are configured and managed with the SQL interface. One or more connections can be configured per database. All DB connections can be used simultaneously. The databases can be of the same or different types.

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 type. The data is accessed with SQL statements.

• Input direction (read)

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

  • Optional parameters assigned to signals can be used in the queries in order to thus change the queries dynamically during the ongoing acquisition.

• Output direction (write)

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

  • In the commands, optional parameters assigned to signals can be used in order to therefore write signal actual values.

The execution of queries and commands can be cyclical or triggered.

Caution

The network and DB can be overloaded by highly cyclical DB accesses and/or very large data volumes. In the SQL statements, any SQL commands can be used and therefore cause damage (e.g. “delete table,” “drop database,” etc.). Therefore... Only have qualified users create/change SQL statements (-> user management, security administration). Involve your DB administrator for questions about configuring the SQL statements. This way, for example, the DB user used in ibaPDA for the DB connection only has the rights that are actually required. Set an appropriate update time (as short as necessary, as long as possible). Assess and test the results of your SQL statement.

Available modules

SQL query (read from a database using SQL statement)

SQL command (write to a database using SQL command)

Product name

• ibaPDA-Interface-MySQL (Art. no. 31.001116)

• ibaPDA-Interface-Oracle (Art. no. 31.001113)

• ibaPDA-Interface-PostgreSQL (Art. no. 31.001115)

• ibaPDA-Interface-SAP-HANA (Art. no. 31.001117)

• ibaPDA-Interface-SQL-Server (Art. no. 31.001114)

Other documentation
	A detailed description of these interfaces and their configuration can be found in the corresponding product manuals for ibaPDA-Interface-MySQL, ibaPDA-Interface-Oracle, ibaPDA-Interface-PostgreSQL, ibaPDA-Interface-SAP-HANA oder ibaPDA-Interface-SQL-Server..