Adding and linking the components
Procedure
- Drop the following components from the Palette onto the design workspace: tMysqlConnection, tFixedFlowInput, tMysqlOutput, tCreateTable, tCombinedSQLInput, tCombinedSQLFilter, tCombinedSQLAggregate, tCombinedSQLOutput, tMysqlCommit, tMysqlInput and tLogRow.
- Connect tMysqlConnection to tFixedFlowInput using a Trigger > On Subjob Ok link
- Do the same to connect tFixedFlowInput to tCreateTable, tCreateTable to tCombinedSQLInput, tCombinedSQLInput to tMysqlCommit, and tMysqlCommit to tMysqlInput.
- Connect tFixedFlowInput and tMysqlOutput using a Row > Main link.
- Connect tCombinedSQLInput to tCombinedSQLFilter using a Row > Combine link.
- Do the same to connect tCombinedSQLFilter to tCombinedSQLAggregate, and tCombinedSQLAggregate to tCombinedSQLOutput
- Connect tMysqlInput and tLogRow using a Row > Main link.