This section contains information that is specific to the database type SAP HANA.
...
| Note | ||
|---|---|---|
| ||
When using SAP HANA the property max.cached.prepared.statements has to be set to 0 in the Execution Context in order to be able to use |
In addition to the functions listed above, the SAP HANA database 2.0 can be used with the following functionality:
...
When selecting the SAP HANA database type, you can configure the following property using the Properties tab in the Database profile:
sapdb.connectionpool.maxlimit
Preparations
A driver, provided by your SAP contact, is required to connect a SAP HANA database. This driver must be stored on the Platform Container host and each Execution Container host that will connect to a SAP HANA database.
...
- Copy the driver to the directory
MZ_HOME/3ppin the Platform or EC Container .
- Restart the Platform and EC/ECSAs for the change to take effect.
...
- .
Advanced Connection Configuration for SAP HANA with TLS/SSL
When connecting to a SAP HANA database with TLS/SSL enabled, the connection string will require additional properties for the connection.
SAP HANA Advanced Connection Setup with a JDBC connection string to a SAP HANA database with TLS/SSL enabled.
The required properties will be:
encrypt, which has to be set to TRUE if the TLS/SSL is already enabled on the SAP HANA hosting server.
trustStore, with the path and filename to the trust store housing the security certificate for the SAP HANA hosting server.
trustStorePassword, and the values for the trust store password.
hostNameInCertificate, the hostname used in the security certificate to identify the SAP HANA hosting server.
For a full list of the connection string properties, you can refer to: https://help.sap.com/viewer/b3ee5778bc2e4a089d3299b82ec762a7/2.0.01/en-US/2624cb2191be4f68897b91023ab41d0c.html