This section contains information that is specific to the database type SAP HANA.
Supported Functions
The SAP HANA database 1.0 and 2.0 can can be used with the following functionality:
- Callable Statements (APL)
- Database Bulk Lookup Functions (APL)
- Database Table Related Functions (APL)
- Database Agents
- Data Masking Profile
- Event Notifications
- Prepared Statements (APL)
- Shared Table Profile
- SQL Collection/Forwarding Agents
- SQL Loader Agent
- Task Workflows Agents (SQL)
| 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:
...
| Note | ||
|---|---|---|
| ||
| The SAP HANA database availability is dependent on scenario and customer landscape. Therefore any solution designed with using the jdbc connection to SAP HANA for real-time applications must be designed made to handle the same availability as achieved by the implementation of the underlying SAP HANA instance. |
Properties
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 an 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.
For to To access the SAP HANA database, follow the steps below:
- Copy the driver to the directory
MZ_HOME/3ppin the Platform or EC Container .
- Restart the Platform and EC/ECSAs ECs for the change to take effect.
Advanced Connection Configuration for SAP HANA with TLS/SSL
When connecting to a an 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.
...