SAP HANA Database
- Casey Han
The purpose of this forwarder is to send processed data from your stream to a SAP HANA database. This forwarder function lets you update, insert or delete data in the SAP HANA database.
You can configure this function in the following settings.
Database info to enter the details of the SAP HANA database 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 database 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 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 update, insert or delete data in the selected database. The SAP HANA Database 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 Database forwarder function supports Variable Insertion when writing SQL statements.Â