SAP Hana

SAP HANA is an in-memory high-performant SQL database created by SAP. With UI Bakery you can build applications on top of your SAP HANA database in just a couple of minutes.

Prerequisites

You should have an active SAP HANA subscription and should receive a user and password from them so that you can log into the admin console.

Locate your database host in the console:

Connecting to SAP HANA from UI Bakery

Go to the data sources page, click Connect button, and select SAP HANA from the list of data sources.

UI Bakery connects to SAP HANA using JDBC. This means that you will need to create the following JDBC connection string jdbc:sap://<SAP HANA DB Host>:443. For instance:

jdbc:sap://xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.xxxx.xxxx-xxxx.hanacloud.ondemand.com:443

Use the username and password you use to log into the SAP HANA admin console and click Connect Datasource:

Executing SAP HANA queries in UI Bakery

Currently, UI Bakery only supports SQL query action step when working with SAP HANA data sources.

SQL query