tSAPHanaConnection
Establishes a SAP HANA connection to be reused by other SAP HANA components in your
Job.
tSAPHanaConnection opens a connection to the database
for a current transaction.
tSAPHanaConnection Standard properties
These properties are used to configure tSAPHanaConnection running in the Standard Job framework.
The Standard
tSAPHanaConnection component belongs to the Databases and the ELT families.
The component in this framework is available in all Talend products with Big Data
and in Talend Data Fabric.
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 |
Host |
Database server IP address. |
Port |
Listening port number of database server. |
Schema |
Name of the database schema. |
Username and |
Database authentication data. To enter the password, click the […] button next to the |
Additional JDBC |
Specify additional connection properties in the database connection you are |
Advanced settings
Auto Commit |
Select this check box to commit any changes to the database With this check box selected, you cannot use the corresponding Note that the auto commit function commits each SQL statement as a |
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at a Job level as well as |
Usage
Usage rule |
This component is more commonly used with other tSAPHana* |
Support |
tSAPHanaConnection should be used to interact with the ERP |
Related scenarios
No scenario is available for the Standard version of this component yet.