
10/14/2021 · Nathan Nam
What this post added
The Confluent Oracle CDC Source Connector now supports Oracle Database 19c. This involved adapting to the deprecation of LogMiner's 'continuous_mine' option by implementing a looping query mechanism for online and archived redo logs. Handling DDL statements like ALTER TABLE was improved by allowing LogMiner to use dictionaries from archived redo logs when the Online Catalog is insufficient, with configurable modes ('auto', 'online', 'redo_log') to manage this behavior. The post also includes a demonstration of a CDC pipeline from Oracle to Azure Synapse Analytics.