When an action occurs, the result may need to be processed in the selected database connection definition.

Supported databases: Oracle, DB2, PostgreSQL, DB2, MySQL, SQL Server, SAP Database, Apache Hive, Apache Impala.

The picture below shows the Database Connector Configuration settings:


The fields used for the Database Connector configuration are shown in the table below.

Field

Description

TypeThe database type is selected.
Connection Pool Definition

Depending on the selected database type, the definition of the database connection is selected from the pool. Click for detailed information about creating a connection.

OperationThe operation type is selected.

Query Timeout (sec)

The expiry time of the query's working time is entered.
The query to be run in the action is written.

Variables can be used in the SQL field.