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.
Pagination
When a query yields a substantial amount of results, returning all the results in a single payload can lead to performance bottlenecks. You can use the pagination setting to divide a large query results into multiple payloads by controlling the number of rows of data shown per page.
You can enable the Pagination toggle to set the number rows of query results displayed per page. You specify the desired number of rows to display on each page by entering a suitable number for Maximum rows per page. The default value is 200. The minimum value is 1 and the maximum value is 1000.
This toggle is disabled by default. When disabled, all queried data are returned in a single page.