SAP HANA Cloud
You can use the SAP HANA Cloud forwarder to send processed data from your stream to a SAP HANA Cloud. With this function, you can update, insert, or delete data in the SAP HANA Cloud.
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 will be connected to your stream. All the fields are mandatory.
Field | Description |
|---|---|
Host | The hostname, IPv4 or IPv6 address of the SAP HANA Cloud. |
Port | The listening port of the SAP HANA Cloud. The default port is 30015. |
Database name | The name of the SAP HANA Cloud. |
Authentication
Setting | Description |
Select from secrets wallet | Note! This option only appears when the Secrets wallet toggle is enabled. Select 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 requires you to use Global parameters. |
SQL statement
Specify the SQL statement to update, insert or delete data in the selected database. The SAP HANA Cloud function only executes one SQL statement.
Example - SQL statements
Example using UPDATE
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;Example using INSERT INTO
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);Example using DELETE
DELETE FROM table_name WHERE condition;Note!
The SAP HANA Cloud forwarder function supports Variable insertion when writing SQL statements.
Interpolation example:
DELETE FROM table_name WHERE id = ${id} AND name = ${name}