Adding and linking the components - 6.5
CombinedSQL
- EnrichVersion
- 6.5
- EnrichProdName
- Talend Big Data
- Talend Big Data Platform
- Talend Data Fabric
- Talend Data Integration
- Talend Data Management Platform
- Talend Data Services Platform
- Talend ESB
- Talend MDM Platform
- Talend Open Studio for Big Data
- Talend Open Studio for Data Integration
- Talend Open Studio for ESB
- Talend Open Studio for MDM
- Talend Real-Time Big Data Platform
- EnrichPlatform
- Talend Studio
- task
- Data Governance > Third-party systems > ELT components > CombinedSQL components
- Data Quality and Preparation > Third-party systems > ELT components > CombinedSQL components
- Design and Development > Third-party systems > ELT components > CombinedSQL 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.