## Set up SAP HANA

URL: https://docs.atlan.com/apps/connectors/database/sap-hana/how-tos/set-up-sap-hana

> :::warning Who can do this? You will probably need your SAP HANA administrator to run these commands - you may not have access yourself.

:::warning Who can do this?
 You will probably need your SAP HANA administrator to run these commands - you may not have access yourself.

:::

:::info **Did you know?** 
 This connector supports both SAP HANA on-premise as well as [SAP HANA Cloud](https://help.sap.com/docs/hana-cloud) and [SAP HANA Platform](https://help.sap.com/docs/SAP_HANA_PLATFORM) database deployments.

:::

Atlan currently only supports basic username and password authentication for fetching metadata from SAP HANA. Complete the following steps to configure it:

## Create a database user

Create a database user with the following commands:

```sql
CREATE USER <username> PASSWORD <password> NO FORCE_FIRST_PASSWORD_CHANGE;
```

- Replace `<username>` with the username you want to create.
- Replace `<password>` with the password for that username.

## Grant read permission on schema

Grant read permission on schema with the following commands.

To crawl metadata as well as preview and query data in Atlan:

```sql
GRANT SELECT, SELECT METADATA ON SCHEMA <schema> TO <username>;
```

To only crawl metadata in Atlan:

```sql
GRANT SELECT METADATA ON SCHEMA <schema> TO <username>;
```

- Replace `<schema>` with the name of the schema you want to crawl.

To crawl [calculation views](https://docs.atlan.com/llms/connectors/sap-hana/what-does-atlan-crawl-from-sap-hana/llms.txt) in Atlan:

```sql
GRANT SELECT ON _SYS_REPO.ACTIVE_OBJECT TO <username>;
GRANT SELECT ON _SYS_BI.BIMC_PROPERTIES TO <username>;
```

:::warning

Your SAP HANA administrator will need to run these statements for each schema you want to crawl.

:::

---