Connecting the components - 7.3

ELT MSSql

Version
7.3
Language
English
Product
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 Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > ELT components > ELT MSSql components
Data Quality and Preparation > Third-party systems > ELT components > ELT MSSql components
Design and Development > Third-party systems > ELT components > ELT MSSql components

Procedure

  1. Connect the two tELTMysqlInput components to the tELTMysqlMap component using Link connections named strictly after the actual input table names, employees and dept in this use case.
  2. Connect the tELTMysqlMap component to the tELTMysqlOutput component using a Link connection. When prompted, click Yes to allow the ELT Mapper to retrieve the output table structure from the output schema.
  3. Click the tELTMysqlMap component and select the Component tab to display its Basic settings view.
  4. Select Repository from the Property Type list, and select the same DB connection that you use for the input components.
    All the DB connection details are automatically retrieved.
    Note: Leave all the other parameters as they are.