Skip to main content Skip to complementary content

Inserting data into the source table

Procedure

  1. Double-click tFixedFlowInput to open its Basic settings view.
  2. Click the [...] button next to Edit schema to open the schema editor.
    Click four times the [+] button to add four columns: id and age of the integer type, name and sex of the string type.
    Click OK to close the schema editor and accept the propagation prompted by the pop-up dialog box.
  3. Select Use Inline Content(delimited file) in the Mode area, and then enter the following input data in the Content field:
    1;Ford;Male;25
    2;Rose;Female;30
    3;Sabrina;Female;28
    4;Teddy;Male;32
    5;Kate;Male;35
  4. Double-click tOracleOutput 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 outbound server is configured, Oracle12_XStreamOut in this example. The connection type, database version and other connection details information will be completed automatically.
  6. In the Table field, enter the name of the table into which the input data will be inserted. In this example, it is PERSON.
  7. Click the [...] button next to Edit schema to open the schema editor to ensure the schema has been synced up.

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!