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.

1 Database info
2 Authentication
3 SQL statement

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.

Database info configuration

Field	Description

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.

Authentication configuration

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.

SQL statement configuration

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}