August 15, 2023

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

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

Populating data in a MySQL database table

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

    components-textractdelimitedfields_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 DelimitedField of String type.

    components-textractdelimitedfields_s1_tfixedflowinput_schema.png

    Click OK to close the schema editor and
    accept the propagation prompted by the pop-up dialog box.
  3. In the Mode area, select Use Inline Content(delimited file). Then in the
    Content field displayed, enter the data to
    write to the database. This input data includes a delimited string column. In
    this example, the input data is as follows:

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

    components-textractdelimitedfields_s1_tmysqloutput.png

  5. Fill the Host, Port, Database, Username, Password
    fields with the MySQL database connection information.
  6. Fill the Table field with the name of the
    table to be written. In this example, it is employee.
  7. Select Drop table if exists and create from
    the Action on table list.
  8. Double-click the first tLogRow to open its
    Basic settings view.

    components-textractdelimitedfields_s1_tlogrow1.png

    In the Mode area, select Table (print values in cells of a table) for better
    readability of the result.
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