August 15, 2023

Writing data in a database table – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Writing data in a database table – Docs for ESB 6.x

Writing data in a database table

  1. Double-click the tRowGenerator component
    to open the Row Generator editor.

    use_case-tmemsqlinput2.png

  2. Add three columns as shown below to generate 10 data
    rows:

    • id, Integer type, using
      Numeric.sequence from the
      Function list to generate
      sequence numbers.

    • firstName, String type, using TalendDataGenerator.getFirstName from the Function list to generate random first
      names.

    • lastName, String type, using
      TalendDataGenerator.getLastName
      from the Function list to generate
      random family names.

  3. In the Basic settings view of tRowGenerator in the Component tab, click the Edit
    Schema     button to open the schema editor. Set the length of
    the id, firstName, lastName
    column to 4, 10, and
    10.

    use_case-tmemsqlinput9.png

    When done, click OK to close the editor
    and click Yes when prompted to propagate
    the schema to the next component.
    For more information about how to configure the tRowGenerator component, see tRowGenerator.
  4. Double-click tMemSQLOutput to open its Basic Settings view in the Component tab.

    use_case-tmemsqlinput4.png

  5. Select the Use Existing Connection check
    box. The Component List is filled in
    automatically with tMemSQLConnection_1.

    Fill the Table field with the database
    table, customers in this example.
    Select Drop table if exists and create in
    the Action on table list, and Insert in the Action on
    table     list.
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