August 15, 2023

Populating the database table with input data – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Populating the database table with input data – Docs for ESB 6.x

Populating the database table with input data

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

    Use_Case_tCombinedSQLAggregate_10.png

  2. In the Basic settings view, in the Number of rows field, enter 500.
  3. In this scenario, the source database table has seven columns: id, first_name, last_name, city, state, date_of_birth,
     and salary

    Click the […] button next to Edit schema to define the following data
    structure.
    Use_Case_tCombinedSQLAggregate_9.png

  4. Click the floppy disk icon to save the schema as a generic schema for later
    reuse.
  5. In the Select folder window, select default and click OK.
  6. Choose a name for your generic schema and click Finish.
  7. Click OK.
  8. The first column of the Values table
    automatically reflects the data structure you entered previously.
  9. In the Values table, enter a value for each
    column.
  10. In the design workspace, select tMysqlOutput
    and click the Component tab to define its basic
    settings.

    Use_Case_tCombinedSQLAggregate_11.png

    The output schema will automatically be the same as the previous component, in
    this case tFixedFlowInput.
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