tEXACommit
Validates the data processed through the Job into the connected EXASolution
database.
Using a unique connection, this component commits in one
go a global transaction instead of doing that on every row or every batch and thus provides
gain in performance.
tEXACommit Standard properties
These properties are used to configure tEXACommit running in the Standard Job framework.
The Standard
tEXACommit component belongs to the Databases family.
The component in this framework is generally available.
Basic settings
Component List |
Select the tEXAConnection component |
Close Connection |
This check box is selected by default and it allows you to close the Warning:
If you want to use a Row > Main |
Advanced settings
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the Job level |
Global Variables
Global Variables |
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 |
This component is more commonly used with other EXASolution |
Dynamic settings |
Click the [+] button to add a Once a dynamic parameter is defined, the Component List box in the Basic For examples on using dynamic parameters, see Scenario: Reading data from databases through context-based dynamic connections and Scenario: Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic |
Related scenario
For a similar scenario using other database, see Scenario: Inserting data in mother/daughter tables.