Configuring a connection to a MySQL database - 7.3

Talend Open Studio User Guide
Version
7.3
Language
English
Product
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Module
Talend Studio
Content
Design and Development
Last publication date
2023-10-11
Available in...

Open Studio for Big Data

Open Studio for Data Integration

Open Studio for ESB

Procedure

  1. Drop the following components from the Palette onto the design workspace: tMysqlConnection, tSQLTemplateAggregate, tSQLTemplateCommit, tMysqlInput, and tLogRow.
  2. Link tMysqlConnection to tSQLTemplateAggregate using a Trigger > On Subjob Ok connection.
  3. Do the same to link tSQLTemplateAggregate to tSQLTemplateCommit and link tSQLTemplateCommit to tMysqlInput.
  4. Link tMysqlInput to tLogRow using a Row > Main connection.
  5. Double-click tMysqlConnection to open its Basic settings view.
  6. In the Basic settings view, set the database connection details manually.
  7. Double-click tSQLTemplateCommit to open its Basic settings view.
  8. On the Database Type list, select the relevant database type, and from the Component List, select the relevant database connection component if more than one connection is used.