August 15, 2023

Inserting data into the source table – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Inserting data into the source table – Docs for ESB 6.x

Inserting data into the source table

  1. Double-click tFixedFlowInput to open its
    Basic settings view.

    components-toraclecdcoutput_s1_tfixedflowinput.png

  2. Click the […] button next to Edit schema to open the schema editor.

    components-toraclecdcoutput_s1_tfixedflowinput_schema.png

    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:

  4. Double-click tOracleOutput to open its
    Basic settings view.

    components-toraclecdcoutput_s1_toracleoutput.png

  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.

    components-toraclecdcoutput_s1_toracleoutput_schema.png

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x