# 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.

## Configuration

### Prerequisites

You should have an active SAP HANA subscription to receive a user and password from them so that you can log into the admin console. In the console, you need to locate the *database host* which will be needed to connect the data source.

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2FZqaW1VJt2JSuWkCIZqI2%2Fspaces_UX6zPRMFFK0yrTghj7cY_uploads_git-blob-605092574652d678ce9337415023b7f845ee7b74_image%20(31).png?alt=media&#x26;token=831fc42b-e4cd-4c3a-8706-a96afe1ef419" alt=""><figcaption></figcaption></figure>

### Connecting the data source

1. On the **Data sources** page, click **Connect**, and select *SAP Hana* in the Data sources list.
2. Specify the **JDBC connection string**, for example:

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

{% hint style="info" %}
UI Bakery connects to SAP Hana using JDBC so you will need to create a JDBC connection string in the following format - `jdbc:sap://<SAP HANA DB Host>:443` .
{% endhint %}

3. Provide the *username* and *password* you use to log into the SAP HANA admin console.
4. Click **Test connection** to check whether the data source can be connected, and then click **Connect Datasource** to complete the setup.

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2FxOKqNuWJDBsFHFvBZNEO%2FCleanShot%202025-04-25%20at%2015.34.16%402x-min.png?alt=media&#x26;token=41f23da2-d234-4a80-b8b3-fcb2ad7165e5" alt=""><figcaption></figcaption></figure>

## Usage

Currently, UI Bakery only supports the [SQL Query](https://docs.uibakery.io/reference/working-with-actions/sql-query) action step when working with SAP HANA data sources.