July 31, 2023

Inserting data in bulk in MySQL database – Docs for ESB Snow Flake 7.x

Inserting data in bulk in MySQL database

This scenario describes a two-component Job which carries out the same
operation as the one described for tMysqlOutputBulk Standard properties
and tMysqlBulkExec Standard Properties, although no data is

Inserting data in bulk in MySQL database_1.png
  • Drop a tRowGenerator and a
    tMysqlOutputBulkExec component from
    the Palette to the design workspace.

  • Connect the components using a link such as Row > Main.

  • Set the tRowGenerator
    parameters the same way as in Inserting transformed data in MySQL database. The schema is made of four columns including: ID, First Name, Last Name, Address and City.

  • In the workspace, double-click the tMysqlOutputBulkExec to display the Component view and set the properties.

Inserting data in bulk in MySQL database_2.png
  • Define the database connection details in the corresponding
    fields, if necessary. Consult the recommendations detailed in Inserting transformed data in MySQL database, concerning the conservation of connection details in the Repository, under the Metadata node. In the component view, select Repository in the Property Type field and then select the appropriate connection
    in the adjacent field. The following fields will be filled in automatically.

For further information, see
Talend Studio

User Guide.

  • In the Action on table
    field, select the None option as you want
    to insert the data into a table which already exists.

  • In the Table field, enter
    the name of the table you want to populate, the name being clients in this example.

  • In the Local filename
    field, indicate the access path and the name of the file which contains the data
    to be added to the table. In this example, the file is clients.txt.

  • Click on the Advanced
    tab to define the component’s advanced parameters.

Inserting data in bulk in MySQL database_3.png
  • In the Action on data
    list, select the Insert records in table
    to insert the new data in the table.

  • Press F6 to run the

The result should be pretty much the same as in Inserting transformed data in MySQL database, but the data might differ as these are regenerated randomly everytime the Job is

Document get from Talend https://help.talend.com
Thank you for watching.
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x