August 15, 2023

Writing the data into Amazon Aurora – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Writing the data into Amazon Aurora – Docs for ESB 6.x

Writing the data into Amazon Aurora

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

    components-tamazonaurorainput_s1_tfixedflowinput.png

  2. Click the […] button next to Edit
    schema     and in the pop-up window define the schema by adding three
    columns: id of Integer type, and name and city of
    String type.

    components-tamazonaurorainput_s1_tfixedflowinput_schema.png

    Click OK to validate the changes and accept
    the propagation prompted by the pop-up dialog box.
  3. In the Mode area, select Use Inline Content (delimited file) and enter the
    following user information in the Content
    field.

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

    components-tamazonaurorainput_s1_tamazonauroraoutput.png

  5. Select the Use an existing connection check
    box and in the Component List that appears,
    select the connection component you have configured.
  6. In the Table field, enter or browse to the
    table into which you want to write the data. In this example, it is TalendUser.
  7. Select Drop table if exists and create from
    the Action on table drop-down list, and select
    Insert from the Action on data drop-down list.
  8. Double-click tAmazonAuroraCommit to open its
    Basic settings view.

    components-tamazonaurorainput_s1_tamazonauroracommit.png

  9. Clear the Close Connection check box if it is
    selected.
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