The Database collection agent collects rows from a database table on a remote or local database and inserts them as UDRs into a workflow.
When the workflow is executed the agent will create 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 dialog.
The agent use and require a transaction ID column to utilize a rollback functionality. Additionally, based on configurations, the agent deletes the data in the table after it has been inserted into the workflow. When all the matching data has been successfully processed, the agent stops to await the next activation, scheduled or manual initialization.
The section contains the following subsections:
The Database collection agent collects rows from a database table on a remote or local database and inserts them as UDRs into a workflow.
When the workflow is executed the agent will create 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 dialog.
The agent use and require a transaction ID column to utilize a rollback functionality. Additionally, based on configurations, the agent deletes the data in the table after it has been inserted into the workflow. When all the matching data has been successfully processed, the agent stops to await the next activation, scheduled or manual initialization.
The section contains the following subsections:
Add Comment