tSQLTemplate
Executes the common database actions or customized SQL statement templates, for
example to drop/create a table.
tSQLTemplate offers a range of SQL
statement templates for a number of DBMSs to facilitate some of the most common database
actions. These templates are accessible via the SQL
Template view. Additionally, you are allowed to customize the SQL statement
templates as needed.
tSQLTemplate Standard properties
These properties are used to configure tSQLTemplate running in the Standard Job framework.
The Standard
tSQLTemplate component belongs to the ELT family.
The component in this framework is available in all Talend
products.
Basic settings
Database Type |
Select the database type you want to connect to from the |
Component List |
Select the relevant database connection component in the list if you use more than one |
Database name |
Name of the database. |
Table name |
Name of the table on which the SQL statement templates will be executed. |
Schema and Edit |
A schema is a row description, that is to say, it defines the number of fields that Click Edit
|
 |
Built-in: You create and store the schema locally for |
 |
Repository: You have already created the schema and |
Advanced settings
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at a |
Global Variables
Global Variables |
NB_LINE: the number of rows read by an input component or
QUERY: the query statement being processed. This is a Flow
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
As a start component, this component is used with other database components, especially |
SQL Template |
SQL Template List |
Dynamic settings |
Click the [+] button to add a row in the The Dynamic settings table is For examples on using dynamic parameters, see Reading data from databases through context-based dynamic connections and Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic |
Related scenarios
For a related scenario, see Filtering and aggregating table columns directly on the DBMS.