August 16, 2023

Scenario: Inserting data in mother/daughter tables – Docs for ESB 6.x

Scenario: Inserting data in mother/daughter tables

The following Job is dedicated to advanced database users, who want to carry out
multiple table insertions using a parent table id to feed a child table.

As a prerequisite to this Job, follow the steps described below to create the relevant
tables using an engine such as innodb:

  1. In a command line editor, connect to your Mysql server.

  2. Once connected to the relevant database, type in the following command to
    create the parent table:

  3. Then create the second table:

Back in
Talend Studio
, the Job requires seven components including
tMysqlConnection and tMysqlCommit.

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