SAP HANA Cloud Query configuration
You can configure this function with the following settings:
Database info
Fill in the server host address, port number, and database name of the SAP HANA Cloud that you want to query. All the fields are mandatory.
Field | Description |
|---|---|
Host | The hostname, IPv4 or IPv6 address of the SAP HANA Cloud. Note! Sensitive parameters cannot be used in the Host field. |
Port | The listening port of the SAP HANA Cloud. The default port is 30015. |
Database name | The name of the SAP HANA Cloud. Note! Sensitive parameters cannot be used in the Database name field. |
Authentication
Setting | Description |
Select from secrets wallet | Note! This option only appears when the Secrets wallet toggle is enabled. Select a secret from a list of database type secrets in your Secrets wallet that contains the authentication credentials for the SAP HANA Cloud. For more details, see Secrets wallet on how to configure a SAP HANA secret type using the Secrets wallet. |
Username Password | Note! This option only appears when the Secrets wallet toggle is disabled. Direct input authentication Enter the following:
Note! The Password field only accepts parameter reference, and you are required to use Global parameters. |
SQL statement
Specify the SQL statement to select the data from the selected database. The SAP HANA Cloud Query function only executes one SQL statement.
Note!
Sensitive parameters cannot be used in SQL statement.
Example - Using Select SQL
SELECT *
FROM movies;Note!
The SAP HANA Cloud Query function supports Variable insertion when writing SQL statements.
Example of variable insertion:
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 for how long items should be stored in cache before being removed.
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. The stream will then fail 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.