Move your data from Oracle Database (Batch) with your free account

The Oracle Database Batch Query connector in Estuary captures data by periodically querying Oracle tables and views and loading the results into Estuary collections. It supports several query patterns, making it useful when LogMiner-based CDC is unavailable, when capturing from database views or read replicas, or when you need custom SQL queries.

• ROWSCN-based incremental capture using Oracle’s ORA_ROWSCN to identify rows modified since the previous poll
• Cursor-based incremental capture using fields such as update timestamps, creation timestamps, or incrementing IDs
• Full-refresh capture for tables or views without a suitable cursor
• Custom SQL queries for filtering, aggregations, or capturing specific subsets of data
• Configurable polling schedules, with a default interval of 5 minutes
• Automatic table discovery across accessible Oracle schemas
• Primary-key-aware collections, using discovered primary keys when available
• Support for Oracle Database 11g and later, including self-hosted databases, Amazon RDS, Oracle Cloud Infrastructure, and other managed platforms

For discovered tables, the connector can use ORA_ROWSCN to perform an initial full backfill and then capture only new or updated rows on subsequent polls. When no cursor is configured, the full table or view is re-read during each polling cycle.