July 30, 2023

tSAPHanaCommit – Docs for ESB 7.x

tSAPHanaCommit

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.

tSAPHanaCommit validates the data
processed through the Job into the connected database.

tSAPHanaCommit Standard properties

These properties are used to configure tSAPHanaCommit running in the Standard Job framework.

The Standard
tSAPHanaCommit component belongs to the Databases family.

The component in this framework is available in all Talend products with Big Data
and in Talend Data Fabric.

Note: This component is a specific version of a dynamic database
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
Apply.

Component list

Select the tSAPHanaConnection component in the list if
more than one connection is planned for the current Job.

Close 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.

Warning:

If you want to use a Row
>

Main connection
to link tSAPHanaCommit to your
Job, your data will be committed row by row. In this case, do
not select the Close connection
check box or your connection will be closed before the end of
your first row commit.

Advanced settings

tStatCatcher Statistics

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

Usage

Usage rule

This component is more commonly used with other tSAPHana* components, especially with
the tSAPHanaConnection and
tSAPHanaRollback
components.

Use this component if the Auto Commit option of the
tSAPHanaConnection component is
cleared.

Related scenario

For a related scenario, see Inserting data in mother/daughter tables.


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x