SAP HANA Cloud
- Casey Han
- Nirosan Silvaratnam
- Jenni Wallin
The purpose of this forwarder is to send processed data from your stream to a SAP HANA Cloud. This forwarder function lets you update, insert, or delete data in the SAP HANA Cloud.
You can configure this function in the following settings.
Database info to enter the details of the SAP HANA Cloud that will be connected to your stream.
Authentication is to set the credentials of the database.
SQL statement to specify the statement to perform operations on the data in the database.
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
Select from a list of Database type secrets in your Secrets Wallet that contains the authentication credentials for the SAP HANA Cloud. For more information, see Secrets Wallet on how to configure a secret using the Secrets Wallet.
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 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.
Example for Interpolation
DELETE FROM table_name WHERE id = ${id} AND name = ${name}