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: