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 be used with the following functionality:

Callable Statements (APL)
Database Bulk Lookup Functions (APL)
Database Table Related Functions (APL)
Database Agents
Data Masking
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 PreparedStatements.

In addition to the functions listed above, the SAP HANA database 2.0 can be used with the following functionality:

Audit Profile

Note!

The SAP HANA database availability is dependent on the scenario and customer landscape. Therefore any solution designed with

using the JDBC connection to SAP HANA for real-time applications must be designed 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 an SAP HANA database. This driver must be stored on the Platform Container host and each Execution Container host that will connect to an SAP HANA database.

For to access the SAP HANA database, follow the steps below:

Copy the driver to the directory MZ_HOME/3pp in 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 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 an SAP HANA database with TLS/SSL enabled.

For a list of JDBC connection string properties required to connect your TLS/SSL-enabled SAP HANA hosting server, you can refer to the SAP HANA documentation at the SAP Help Portal.

Next:

8.6.11 Snowflake

Browser not supported