A use case of system SQL templates

As there are many common, standardized SQL statements, Talend Studio allows you to benefit from various system SQL templates.

This section presents you with a use case that takes you through the steps of using MySQL system templates in a Job that:

• opens a connection to a Mysql database.

• collects data grouped by specific value(s) from a database table and writes aggregated data in a target database table.

• deletes the source table where the aggregated data comes from.

• reads the target database table and lists the Job execution result.

To connect to the database and aggregate the database table columns: