Skip to main content Skip to complementary content

Configuring the components

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 automatically 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!