Skip to main content

SAP HANA Table

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

Connect to SAP HANA Table​

In order to connect to SAP HANA Tables, 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_Table'.
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:

  • TABLE: Name of the table or view to query.
  • SCHEMA: Name of the schema the table or view is located in. Optional if the user's default schema is used or the schema is defined in the connection string of the System.
  • COLUMNS: List of columns to be returned by the query, separated by semicolons. Use '*' to return all columns. In case of special characters or case sensitive column names please surround the column name with double quotes (e.g. 'Column1').

User parameters​

All types of Parameters are available and can be applied.

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.