Confluent

Confluent’s Oracle CDC Connector Now Supports Oracle Database 19c

Oct 14, 2021Nathan Nam
Confluent’s Oracle CDC Connector Now Supports Oracle Database 19c
SummaryAI, from the source post

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.

More from the Confluent Connectors Portfolio trail