ibaPDA-Interface-MySQL

​​General information

- ​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 interface has the following functions and configuration options.​

You can test SQL statements for queries as well as for commands by using the <Test statement> button.

Technically, the statement is executed during the test in a transaction, which is then undone subsequently (rollback).

In a normal case, this avoids the tested execution of an SQL statement leading to changes in the database.

This is especially important for writing SQL commands.

Depending on the complexity of the SQL statement and the structure of the database, however, it cannot be completely ruled out that changes remain in the database after the rollback.

Unlike SQL command modules (outputs), there is an area with SQL query modules at the bottom in the SQL query tab where the test results are displayed.