Skip to main content Skip to complementary content

Extracting and synchronizing data changes to the target table

Procedure

  1. Double-click tOracleCDC to open its Basic settings view.
  2. Set Property of the CDC connection 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.
  3. Select LCR Object from the Generate LCR type drop-down list.
    In the Table using CDC field, enter the name of the source table from which changes made to data are to be captured. In this example, it is PERSON.
    In the Outbound server name field, enter the XStream outbound server name. In this example, it is xout.
  4. Click the [...] button next to Edit schema to open the schema editor, and you will see that the schema has been set by default.
  5. Click Advanced settings to open its view.
    In the Idle timeout(seconds) field, enter the number of seconds of idle time that the outbound server waits for an LCR before terminating the call to get or receive an LCR stream. Considering the network latency and the database response rate, the idle time is set to 60 seconds in this example.
  6. Double-click tOracleCDCOutput to open its Basic settings view.
    Set Property of the CDC connection 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 database version and other connection details information will be completed automatically.
  7. In the Inbound server name field, enter the XStream inbound server name. In this example, it is xin.
    Select the Set data table schema check box and specify the schema of the CDC table. In this example, it is TALEND.
    Select the Set target table check box and specify the table to which data changes from the inbound server will be replicated. In this example, it is PERSON_BAK.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here