Retrieving data from the source and target table - 6.5

Change Data Capture

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
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
task
Data Governance > Third-party systems > Database components > Change Data Capture
Data Quality and Preparation > Third-party systems > Database components > Change Data Capture
Design and Development > Third-party systems > Database components > Change Data Capture
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the first tOracleInput to open its Basic settings view.
  2. Set Property Type to Repository and select the connection metadata corresponding to the Oracle database on which the XStream outbound server is configured, Oracle12_XStreamOut in this example. The connection type, database version and other connection details information will be completed automatically.
    Set Schema to Repository and select the source table from the Repository. In this example, it is PERSON.
  3. In the Query field, enter the following SQL statement to retrieve all the data from the source table:
    select * from PERSON
  4. Double-click the second tOracleInput to open its Basic settings view.
  5. Set Property Type to Repository and select the connection metadata corresponding to the Oracle database on which the XStream inbound server is configured, Oracle12_XStreamIn in this example. The connection type, database version and other connection details information will be completed automatically.
    Set Schema to Repository and select the target table from the Repository. In this example, it is PERSON_BAK.
  6. In the Query field, enter the following SQL statement to retrieve all the data from the target table:
    select * from PERSON_BAK
  7. Double-click the first tLogRow to open its Basic settings view.
    In the Mode area, select Table (print values in cells of a table) for a better display of the result.
  8. Do the same to configure the second tLogRow.