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.
Close announcements banner

SQLTemplate components

tSQLTemplate Executes the common database actions or customized SQL statement templates, for example to drop/create a table.
tSQLTemplateAggregate Provides a set of matrix based on values or calculations.
tSQLTemplateCommit Commits a global action in one go using a single connection, instead of doing so for every row or every batch of rows separately. This provides a gain in performance.
tSQLTemplateFilterColumns Homogenizes schemas by reorganizing, deleting or adding new columns.
tSQLTemplateFilterRows Sets row filters for any given data source, based on a WHERE clause.
tSQLTemplateMerge Merges data into a database table directly on the DBMS by creating and executing a MERGE statement.
tSQLTemplateRollback Cancels the transaction committed in the SQLTemplate database.

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!