SQL Collection Agent in Batch Workflows
The SQL collection agent collects rows from any database table and inserts them as UDRs into a workflow.
When the workflow is executed the agent will execute a query in SQL, based on the user configuration, and retrieve all rows matching the statement. For each row, a UDR is created and populated according to the assignments in the configuration window.
Note!
Supported database commands depend on the JDBC driver of the database.
The section contains the following subsections:
- SQL Collection Agent Configuration - Batch
- SQL Collection Agent Transaction Behavior - Batch
- SQL Collection Agent Input/Output Data and MIM - Batch
- SQL Collection Agent Events - Batch