Database Connector
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 |
|---|---|
| Type | The 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. |
| Operation | The 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.