Retrieving modified data using Oracle CDC Redo log mode - 7.3

Change Data Capture

Version
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Database components (Integration) > Change Data Capture
Data Quality and Preparation > Third-party systems > Database components (Integration) > Change Data Capture
Design and Development > Third-party systems > Database components (Integration) > Change Data Capture
Last publication date
2024-02-21

This scenario applies to all Talend products.

For more technologies supported by Talend, see Talend components.

Warning:

Before modifying data in the LEADFACT table and retrieving these modifications using the tOracleCDC component, you must activate the Redo log mode in the Oracle database that holds the table to monitor. For more information on how to activate the Redo log mode, see Talend Studio User Guide.

This scenario is based on the preceding one. It continuously populates and modifies the data stored in the LEADFACT table, and retrieves and saves, every night, these modifications in a dedicated table using the CDC function. These modifications could be then extracted by the various concerned departments.