tSAPCommit – Docs for ESB 5.x

Component family

Business/SAP

Function

Validates the data processed through the Job into the connected
server.

Purpose

Using a unique connection, this component commits a global
transaction in one go instead of doing that on every row or every
batch and thus provides gain in performance.

Basic settings

SAPConnection Component list

Select the tSAPConnection
component in the list if more than one connection are planned for
the current Job.

Release Connection

This check box is selected by default. It allows you to close the
database connection once the commit is done. Clear this check box to
continue to use the selected connection once the component has
performed its task.

Advanced settings

tStatCatcher Statistics

Select this check box to collect log data at the component
level.

Global Variables

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio
User Guide.

Dynamic settings

Click the [+] button to add a row
in the table and fill the Code
field with a context variable to choose your SAP connection
dynamically from multiple connections planned in your Job.

When a dynamic parameter is defined, the SAPConnection
Component List box in the Basic
settings view becomes unusable.

For more information on Dynamic settings and context
variables, see Talend Studio User Guide.

Usage

This component is more commonly used with other tSAP* components,
especially with the tSAPConnection
and tSAPRollback components.

Limitation

n/a