Confluent’s Oracle CDC Connector Now Supports Oracle Database 19c
Oct 14, 2021Nathan Nam

Summary
This post announces support for Oracle Database 19c in the Oracle CDC Source Connector (v1.3.0). It details the technical challenges and solutions for handling Oracle 19c's desupported 'continuous_mine' option in LogMiner, requiring the connector to intelligently switch between online redo logs and archived logs for CDC data. It also addresses DDL statement handling by leveraging archived redo logs for LogMiner dictionaries when the online catalog is insufficient, and introduces configurable 'oracle.dictionary.mode' ('auto', 'online', 'redo_log') to manage this behavior. The post also provides a practical example of building a CDC pipeline from Oracle to Azure Synapse Analytics using this connector.