SAP HANA Query
- Casey Han
The purpose of this processor is to query data from a SAP HANA database in order and enrich the data in your stream.
You can configure this function in the following settings.
Database info
Fill in the server host address, port number and database name of the SAP HANA database that will be queried. All the fields are mandatory.
Field | Description |
|---|---|
Host | The hostname, IPv4 or IPv6 address of the SAP HANA database. |
Port | The listening port of the SAP HANA database. The default port is 30015. |
Database name | The name of the SAP HANA database. |
Authentication
Select from a list of Database type secrets in your Secrets Wallet that contains the authentication credentials for the SAP HANA database. For more information, see Secrets Wallet on how to configure a secret using the Secrets Wallet.
SQL statement
Specify the SQL statement to select the data from the selected database. The SAP HANA Query function only executes one SQL statement.
Example using SELECT
SELECT *
FROM movies; |
Note!
The SAP HANA Database query function supports Variable Insertion when writing SQL statements.
Example for Interpolation
SELECT dep FROM emp WHERE id = ${id} AND name = ${name};Cache
Enable the Cache toggle to minimize the number of repeated database access requests using the same SELECT statement. You can set the number of items stored in the cache or the duration before the items are removed from the cache.
Enter a suitable number for Maximum items in cache (0 = no limit). The default value is 100. There is no maximum value.
Note!
A high value can result in an error due to memory outage. If so, the stream fails with the following error message in the log:
“Stream failed to complete due to reaching resource limits”
However, this error is received for memory issues in general and can have causes other than a high value for the maximum number of items in the cache.
Enter a suitable number of seconds for Items are removed from cache after. The default value is 300. The minimum value is 1, and there is no maximum value.