Question / Problem:
Would a workflow agent be suitable to connect to an external database using an ODBC connection to send select query to retrieve records?
Answer / Solution:
A workflow agent would not be suitable for this function as a workflow agent is a custom application that you can create to examine and modify batch data, change the routing of a batch, restrict access to a batch in certain modules, and obtain the status of a batch. Workflow agents are attached at the batch class level and invoked whenever a batch is closed from a module.
A Validation Script or the built-In Kofax Capture Database Validation is recommended for this function.