Reading the target database and listing the Job execution result

Procedure

Double-click tMysqlInput to open its Basic settings view.
Select the Use an existing connection check box to use the database connection that you have defined on the tMysqlConnection component.
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.
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.
In the Query area, enter the query statement to select the columns to be displayed.
Save your Job and press F6 to execute it.
The source table is deleted.

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.

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