> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hightouch.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SAP HANA

> Move your data into HANA

## Supported syncing

| Sync Type | Description | Supported Sync Modes |
| - | - | - |
| Any data set | Sync data from any source to a HANA table | Upsert |

## Connect to SAP HANA

Go to the [**Destinations** overview page](https://app.hightouch.com/destinations?from=docs) and click the **Add destination** button. Select **SAP HANA** and click **Continue**. If you're not using a [tunnel](#tunneling), you can then authenticate Hightouch to SAP HANA by entering the following fields:

* **Host**: The hostname or IP address of your SAP HANA server. You don't need to include the `https://`.
* **Port**: The port number of your SAP HANA server.
* **User**: The user that has access through Hightouch to the database and tables you want to sync to.
* **Password**: The password for the user specified above.

To ensure your [credentials](#required-permissions) are correct, click **Test connection**. This confirms if Hightouch can connect to your database by running a basic `SELECT` query.

## Record matching

Hightouch requires a unique identifier in the destination HANA table to add, remove, and update rows. The column must be either a `UNIQUE` or `PRIMARY KEY` column. At least one Hightouch field must map to a unique column.

If you map to an incompatible column, Hightouch will fail the sync with an error message.

## Column types

Hightouch works out of the box with all standard column types.

If you see type errors, it may be because your SQL query is producing the wrong format. Message us on Intercom if you need help.

## Required permissions

Your HANA credentials must be able to:

* `MERGE INTO`, `UPDATE`, `INSERT` and `DELETE` rows from the destination table.
* Create a local temporary table
* Perform select operations on system tables:
  * `SCHEMAS`
  * `TABLES`
  * `TABLE_COLUMNS`
  * `CONSTRAINTS`

## Tips and troubleshooting

To see the exact API requests and responses from each sync run, use the [live debugger](https://docs.hightouch.com/syncs/debugger.md). To get notified by Slack, PagerDuty, SMS, or email when a sync fails, set up [sync alerts](https://docs.hightouch.com/syncs/alerting.md). If you run into an issue this page doesn't cover, [contact support](#pylon-chat).