Extracting and synchronizing data changes using XStream 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.

This scenario describes a Job that inserts data into an empty source table PERSON in one Oracle database on which the XStream outbound server is configured, then extracts and synchronizes the data changes into an empty target table PERSON_BAK in another Oracle database on which the XStream inbound server is configured using Oracle CDC XStream mode, and finally displays the data in the source and target tables on the console.

Prerequisites: The Oracle database connections dedicated to the XStream outbound and inbound servers have been set up in the Repository tree view in the Studio, and the CDC has been added to the empty source and target tables. For more information about how to set up an Oracle database connection and configure CDC in Oracle XStream mode, see Talend Studio User Guide.