Data Governance > Third-party systems > ELT components > ELT MySQL components
Data Quality and Preparation > Third-party systems > ELT components > ELT MySQL components
Design and Development > Third-party systems > ELT components > ELT MySQL components
Last publication date
2023-09-14
Procedure
Drop two tELTMysqlInput components, a
tELTMysqlMap component, and a
tELTMysqlOutput component to the
design workspace, and label them to best describe their functionality.
Double-click the first tELTMysqlInput
component to display its Basic settings
view.
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 Managing metadata in Studio.
Set the second tELTMysqlInput component
in the same way but select dept as its schema.
Double-click the tELTMysqlOutput
component to display its Basic settings
view.
Select an action from the Action on data
list as needed, Insert in this use
case.
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.
