Building a Job - 7.3

ELT Sybase

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 Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > ELT components > ELT Sybase components
Data Quality and Preparation > Third-party systems > ELT components > ELT Sybase components
Design and Development > Third-party systems > ELT components > ELT Sybase components
Last publication date
2024-02-21

Procedure

  1. Drop two tELTMysqlInput components, a tELTMysqlMap component, and a tELTMysqlOutput component to the design workspace, and label them to best describe their functionality.
  2. Double-click the first tELTMysqlInput component to display its Basic settings view.
  3. Select Repository from the Schema list, and define the DB connection and schema by clicking the three dot button preceding Edit schema.

    The DB connection is Talend_MySQL and the schema for the first input component is employees.

    Note:

    In this use case, all the involved schemas are stored in the Metadata node of the Repository tree view for easy retrieval. For further information concerning metadata, see Talend Studio User Guide.

  4. Set the second tELTMysqlInput component in the same way but select dept as its schema.
  5. Double-click the tELTMysqlOutput component to display its Basic settings view.
  6. Select an action from the Action on data list as needed, Insert in this use case.
  7. Select Repository as the schema type, and define the output schema in the same way as you defined the input schemas. In this use case, select result as the output schema, which is the name of the database table used to store the mapping result.

    The output schema contains all the columns of the input schemas plus a ManagerName column.

    Note: Leave all the other parameters as they are.