skills.rest
redpanda-data
redpanda-dataOFFICIAL
Explore all skills by this author →
Website𝕏@redpandadataGitHub

connect-cdc-oracle

Stream Oracle CDC changes into Redpanda or Kafka via oracledb_cdc input.

6|3|Updated May 31, 2026
Search Tags:#pipeline#oracle#checkpoint#cdc#connect#logminer#scn
One-click install
npx skills add https://github.com/redpanda-data/skills --skill connect-cdc-oracle
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: connect-cdc-oracle
Source: https://github.com/redpanda-data/skills/tree/main/skills/connect-cdc-oracle
Command: npx skills add https://github.com/redpanda-data/skills --skill connect-cdc-oracle

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Streams Oracle CDC changes into Redpanda or Kafka using the oracledb_cdc input, enabling real-time data replication, auditing, and downstream processing without custom coding.

Core Features & Use Cases

  • Supports ARCHIVELOG mode and minimal supplemental logging for comprehensive CDC
  • Streams changes via the oracledb_cdc input with optional LogMiner-based snapshot, per-table routing, and LOB handling
  • Enterprise features like Iceberg topics, server-side schema validation, Tiered Storage, and secrets management for secure pipelines

Quick Start

Install Redpanda Connect, configure the oracledb_cdc input with your Oracle DSN, enable ARCHIVELOG and supplemental logging, and start the pipeline.

Frequently Asked Questions about connect-cdc-oracle

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I stream Oracle CDC changes to Redpanda or Kafka?▼

Stream Oracle CDC changes to Redpanda or Kafka by configuring the oracledb_cdc input with your Oracle DSN, enabling ARCHIVELOG mode and supplemental logging, then starting the pipeline to capture real-time data modifications.

Does Oracle CDC with LogMiner require supplemental logging to be enabled?▼

Yes, Oracle CDC with LogMiner requires minimal supplemental logging to be enabled on the database alongside ARCHIVELOG mode, ensuring the transaction logs contain the necessary column data for comprehensive change data capture operations.

How does checkpointing work when capturing Oracle CDC changes using SCN windows?▼

Checkpointing tracks System Change Number windows during Oracle CDC capture, allowing the pipeline to save its exact position in the transaction log and resume streaming without data loss after interruptions or restarts.

Can I route captured Oracle CDC records to separate topics per table?▼

Yes, you can route captured Oracle CDC records to separate topics per table, enabling targeted downstream processing while also handling LOB data types and managing CDB and PDB monitoring configurations.

What enterprise features are available for securing Oracle CDC pipelines?▼

Enterprise features for securing Oracle CDC pipelines include wallet and SSL configurations, secrets management, server-side schema validation, Iceberg topics, and Tiered Storage to build robust and compliant data replication workflows.

Do I need ARCHIVELOG mode to capture real-time data replication from Oracle?▼

Yes, you need ARCHIVELOG mode enabled to capture real-time data replication from Oracle databases, as it preserves completed transaction logs required by LogMiner to extract continuous change events for downstream processing.

Related Skills

Explore More Data & Analytics Skills→
Snowflake-LabsSnowflake-Labs
1

oracle-connection

Configure and verify Oracle database connections for schema extraction.

Official
Intermediate
ivanshamaevivanshamaev
14

cdc-debezium

Set up Debezium CDC pipelines exporting database row changes to Kafka.

Community
Advanced
redpanda-dataredpanda-data
6

connect-cdc-mysql

Stream MySQL and MariaDB CDC changes into Redpanda/Kafka via mysql_cdc input.

Official
Advanced
anton-abyzovanton-abyzov
156

confluent-kafka-connect

Configure and manage Kafka Connect source and sink connectors.

Community
Advanced