Drop the following components from the Palette onto the design workspace: tMysqlConnection, tSQLTemplateAggregate, tSQLTemplateCommit, tMysqlInput, and tLogRow.
Link tMysqlConnection to
tSQLTemplateAggregate using a Trigger > On Subjob Ok connection.
Do the same to link tSQLTemplateAggregate to
tSQLTemplateCommit and link tSQLTemplateCommit to tMysqlInput.
Link tMysqlInput to tLogRow using a Row > Main 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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
