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.