Database poller

Poll Oracle, SQL Server, DB2 z/OS, or IBM i DB400 on a schedule, feed each result row into a method flow, and optionally update or clear rows after processing.

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.