Procedure
-
Drop the following components from the Palette onto the design workspace: tMysqlConnection, tSQLTemplateAggregate, tSQLTemplateCommit, tMysqlInput, and tLogRow.
-
Link tMysqlConnection to
tSQLTemplateAggregate using a connection.
-
Do the same to link tSQLTemplateAggregate to
tSQLTemplateCommit and link tSQLTemplateCommit to tMysqlInput.
-
Link tMysqlInput to tLogRow using a connection.
-
Double-click tMysqlConnection to open its
Basic settings view.
-
In the Basic settings view, set the database
connection details manually.
-
Double-click tSQLTemplateCommit to open its
Basic settings view.
-
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.