Skip to main content Skip to complementary content

Retrieving data from the source and target table

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.

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 – please let us know!