Skip to main content
  • New archived content: Talend MDM, Talend Data Catalog 8.0, and Talend 7.3 products reached their end of life in 2024. Their documentation was moved to the Talend Archive page and will no longer receive content updates.

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:

In this section

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!

Leave your feedback here