Database poller

Poll Oracle, SQL Server, DB2 z/OS, or IBM i DB400 on a cron, process each row in a method flow, then run optional SQL after the row or the batch.

OL Integration Database poller runs a SQL query on a cron and sends each result row through a method flow. After a row finishes the flow, an optional row processing statement can update or delete that row (for example a processed flag). An optional end processing statement runs once the batch is done. Supported sources: Oracle, Microsoft SQL Server, DB2 z/OS, and IBM i DB400.