📄️ Oracle CDC configuration
The Oracle CDC (Change Data Capture) is a powerful tool that enables you to capture and track changes made to your Oracle Database. To use this feature, you must enable the Archivelog mode in your Oracle Database, which is essential for the CDC mechanism to function effectively. This mode ensures that all changes to the data are preserved and retrieved in the event of a system failure.
📄️ Oracle CDC overview
Data Integration uses the capabilities of Oracle LogMiner to establish a robust and effective Change Data Capture (CDC) feature for Oracle databases. Our internally developed solution maximizes the potential of Oracle LogMiner, ensuring a dependable and precise method for capturing and handling alterations within the Oracle database. By capturing table inserts, updates, and deletes, CDC enables applications to efficiently use real-time data changes.
📄️ Oracle CDC DDL and flashback query
Oracle CDC Source connector supports native Data Definition Language (DDL) synchronization. The connector automatically detects the schema modificationssuch as adding or widening columns and refresh its metadata cache without requiring a manual restart.
