Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section contains information that is specific to the database type SAP HANA.

...

  • 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
titleNote!

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:

...

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.

...

When connecting to a SAP HANA database with TLS/SSL enabled, the connection string will require additional properties for the connection.

Image RemovedImage Added

SAP HANA Advanced Connection Setup with a JDBC connection string to a SAP HANA database with TLS/SSL enabled.

...