Skip to main content Skip to complementary content

Adding and linking the components

Procedure

  1. Drop the following components from the Palette onto the design workspace: tMysqlConnection, tFixedFlowInput, tMysqlOutput, tCreateTable, tCombinedSQLInput, tCombinedSQLFilter, tCombinedSQLAggregate, tCombinedSQLOutput, tMysqlCommit, tMysqlInput and tLogRow.
  2. Connect tMysqlConnection to tFixedFlowInput using a Trigger > On Subjob Ok link
  3. Do the same to connect tFixedFlowInput to tCreateTable, tCreateTable to tCombinedSQLInput, tCombinedSQLInput to tMysqlCommit, and tMysqlCommit to tMysqlInput.
  4. Connect tFixedFlowInput and tMysqlOutput using a Row > Main link.
  5. Connect tCombinedSQLInput to tCombinedSQLFilter using a Row > Combine link.
  6. Do the same to connect tCombinedSQLFilter to tCombinedSQLAggregate, and tCombinedSQLAggregate to tCombinedSQLOutput
  7. Connect tMysqlInput and tLogRow using a Row > Main link.

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 – let us know how we can improve!

Leave your feedback here