August 16, 2023

Outputting the result of the preparation into a database – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Outputting the result of the preparation into a database – Docs for ESB 6.x

Outputting the result of the preparation into a database

  1. In the design workspace, select tRedshiftOutput and click the
    Component tab to define its basic settings.

    Use_Case_tDataprepRun_dynamic_prep_11.png

  2. In the Property Type list, select
    Built-in to set the database connection details
    manually.
  3. In the Host, Port,
    Database, Schema,
    Username and Password fields, enter the
    Redshift connection details and the user authentication data for the database,
    between double quotes
  4. To fill the Table field, with the expression that will
    dynamically reuse the input file name and give it to the table, drag it from the
    tFileList_2 list of expressions in the
    Outline panel.

    Use_Case_tDataprepRun_dynamic_prep_12.png

  5. From the Action on table drop-down list, select
    Create table if does not exist.
  6. From the Action on data drop-down list, select
    Insert.
  7. Click Sync columns to retrieve the new output schema,
    inherited from the tDataprepRun component.
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