Skip to main content

SAP HANA SQL Statements

This section provides information on how to execute SAP HANA SQL Statements. Before you can create a Function, make sure that you have already created a respective System within a System Line.

warning

To avoid user mistakes or execution of unwanted SQL statements we recommend to use the SAP HANA Table or SAP HANA Procedure connector.

Connect to SAP HANA Table​

In order to execute SAP HANA SQL Statements, create a new Function in the menu 'Functions, Models and Code-Files' and directly assign it to a Category.
Next, select the relevant Technical Handler 'HANA_SQL'.
Fill all other configuration (e. g. a descriptive Short Name and Description) as specified.

For the Technical Parameters, please specify the following options. The options in BOLD are REQUIRED:

  • STATEMENT: SQL statement to be executed. Make sure to select all columns you want to be able to filter on with parameters.
  • COLUMNS: List of columns to be returned by the query, separated by semicolons. Use '*' to return all columns.

Parameters​

All types of Parameters are available and can be applied, if the HANA supports syntax for it.

After saving the settings (including enabling the function), you can open the 'Test Bench' via the button 'Try in Test Bench' and execute the Query. After a second the data should appear below in a table.