Micro-Integration for Oracle Bulk CDC

The Solace Micro-Integration for Oracle Bulk CDC bridges data between a Solace event broker and Oracle. The Micro-Integration for Oracle Bulk CDC provides you (as an operator) a flexible and efficient way to load Oracle Bulk CDC data to your Solace-backed, event-driven architecture and the event mesh. This Micro-Integration supports one workflow (source-to-target pipeline). Only header mapping is supported; payload mapping is not available for this Micro-Integration.

Spring Framework technologies make it easy to configure the Micro-Integration, perform advanced logging capabilities, and export live metric data to external monitoring solutions.

To get started deploying a Micro-Integration locally or within a container, see:

• Getting Started with the Self-Managed Micro-Integrations

• Modifying the Container Configuration

For common configuration details, see:

• Configuring the Datapath for Your Self-Managed Micro-Integration

• Managing and Deploying Your Self-Managed Micro-Integration

For configuration settings that are specific to Oracle Bulk CDC, see:

• Configuring Connection Details

• Message Batching

• Message Headers

• Dynamic Producer Destinations

• Adding a Monitoring System

• Asynchronous Publishing

Supported Versions

• Oracle Database: 19c, 21c, 23ai (tested with 23ai)

• JDBC Driver: 19.x, 21.x, 23.x

Unsupported Features

• Advanced Queuing (AQ) operations

• Oracle Spatial (limited SDO_GEOMETRY support)

• XML DB (partial XMLType support)

• User-defined object types and nested tables

• Materialized view changes

• Oracle Text and CONTEXT indexes

• Flashback operations

• Oracle Label Security row-level operations

Performance Limitations

• Very large tables (>100M rows) require special configuration for snapshots

• High transaction volume (>10K TPS) may require tuning

• Long-running transactions (>4 hours) may cause memory issues

• LOBs bigger than 100 MB may impact performance