Configuring the components - 6.5

MySQL

author
Talend Documentation Team
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
task
Data Governance > Third-party systems > Database components > MySQL components
Data Quality and Preparation > Third-party systems > Database components > MySQL components
Design and Development > Third-party systems > Database components > MySQL components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the tRunJob component to open its Basic settings view.
    If a child Job has been already specified in the component, you can open its Basic settings view by right-clicking it and selecting Settings from the contextual menu, or by clicking the component and then selecting the Component tab.
  2. Click the [...] button next to the Job field and select the child Job from the [Repository Content] dialog box. Leave all the other parameters as default.
  3. In the Basic settings view of the tMysqlConnection component, select the Use or register a shared DB Connection check box. Then, in the Shared DB Connection Name field, enter the name of the shared connection defined in the child Job, shared_mysql_connection in this example.
    Leave all the other parameters blank or as default.
  4. Double-click the tMysqlInput component to open its Basic settings view.
  5. Select the Use an existing connection check box and, in case you have more than one connection component in the Job, select the connection component to be used from the Component List drop-down list.
  6. Click the [...] button next to Edit schema to open the [Schema] editor, and define the same data structure as in the child Job.
    When done, click OK to close the dialog and click Yes when prompted to propagate the schema to the next component.
  7. Specify the table name in the Table Name list, and click Guess Query to get the query statement automatially filled in the Query field.
  8. In the Basic settings view of the tLogRow component, select the Table mode to display the execution result in table cells.
    Leave the settings of the tMysqlCommit component unchanged.