Skip to main content

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 – let us know how we can improve!