Skip to main content Skip to complementary content

Reading the target database and listing the Job execution result

Procedure

  1. Double-click tMysqlInput to open its Basic settings view.
    Basic settings view.
  2. Select the Use an existing connection check box to use the database connection that you have defined on the tMysqlConnection component.
  3. To define the schema, select Repository and then click the [...] button to choose the database table whose schema is used. In this example, the target table holding the aggregated data is selected.
  4. In the Table Name field, type in the name of the table you want to query. In this example, the table is the one holding the aggregated data.
  5. In the Query area, enter the query statement to select the columns to be displayed.
  6. Save your Job and press F6 to execute it.
    The source table is deleted.
    Screenshot of the console results after successfully running the Job.
    A two-column table citizencount is created in the database. It groups citizens according to their nationalities and gives their total count in each country.

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!