tMSSqlCommit
Commits in one go, using a unique connection, a global transaction instead of doing
that on every row or every batch and thus provides gain in performance.
tMSSqlCommit
validates the data processed through the job into the connected DB.
tMSSqlCommit Standard properties
These properties are used to configure tMSSqlCommit running in the Standard Job framework.
The Standard
tMSSqlCommit component belongs to the Databases family.
The component in this framework is available in all Talend
products.
connector. The properties related to database settings vary depending on your database
type selection. For more information about dynamic database connectors, see Dynamic database components.
Basic settings
Database |
Select a type of database from the list and click |
Component list |
Select the tMSSqlConnection |
Close connection |
This check box is selected by default. It allows you to close the Warning:
If you want to use a Row |
Advanced settings
tStatCatcher Statistics |
Select this check box to gather the job processing metadata at a |
Usage
Usage rule |
This component is more commonly used with other tMSSql* |
Dynamic settings |
Click the [+] button to add a row in the table Once a dynamic parameter is defined, the Component List box in the Basic 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 tMSSqlCommit related scenario, see Inserting data in mother/daughter tables.