Configuration

On the Configuration tab, specify information to connect to SAP HANA Database. The Configuration tab has the following sections: General, Connection, Connection Pool Parameters, and Advanced.



General

The General panel has the following fields:
Field Description
Package The name of the package where the new shared resource is added.
Name The name to be displayed as the label for the shared resource in the process.
Description A short description for this shared resource.

Connection

The Connection panel has the following fields:
Field Module Property Description
Database URL Yes The URL to connect to the SAP HANA Database.

A template of the URL is supplied for HANA JDBC driver. Supply the portions of the URL that are in angle brackets (<>).

Sample URL syntax for SAP HANA JDBC driver: jdbc:sap://<host>:<port>?databaseName=<dbname>.

Username Yes The user name to connect to the SAP HANA Database.
Password Yes The password to connect to the SAP HANA Database.
Connection Timeout(ms) Yes The time (in milliseconds) to wait for a successful database connection.
Test Connection No Click the Test Connection button to test whether the specified configuration fields result in a valid connection to SAP HANA Database.
Catalog No Lists the catalogs available for the selected database.

Connection Pool Parameters

The Connection Pool Parameters panel has the following fields:
Field Module Property Description
Minimum Pool Size Yes The initial number of connections that are created when the pool is started.
Maximum Pool Size Yes The maximum number of connections that can be allocated from the connection pool at the same time.

Advanced

In the Advanced panel, specify additional information about the number of threads needed for processing requests.
Field Module Property Description
Service No. of Threads Yes The number of concurrent threads for processing requests to the activity.

Default value: 8 (A value less than 1 is automatically changed to the default value.)

For more information about configuring this field, see Job Tuning section.