A use case of system SQL templates - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-13

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: