Basic procedure

1. Check whether additional software and/or licenses of the database manufacturer are required for the planned database connection.

2. If necessary, install the required software on the ibaPDA computer, e.g. the software "ADO.NET Data Provider" for SAP HANA connections.

3. In ibaPDA, open the I/O Manager, Inputs tab, and configure one or more database connections on the SQL interface. See Creating a database connection

For database queries (read access)

1. Under the SQL interface on the Inputs tab, add a module SQL query and select one of the previously configured database connections for the module.

2. Formulate an SQL statement for the database query with or without parameters.

3. If you use parameters: Assign the corresponding analog and/or digital signals to the parameters whose values you want to use for the query.

4. Configure the analog and/or digital input signals.

For database commands (write access)

1. Under the SQL interface on the Outputs tab, add a module SQL command and select one of the previously configured database connections for the module.

2. Formulate an SQL statement as an SQL command with or without parameters.

3. If you use parameters: Assign the corresponding analog and/or digital signals to the parameters whose values you want to write in the database.

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. For example, the DB user used in ibaPDA for the DB connection should only have 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.