Skip to main content
Community Hub

Set up SAP HANA

TL;DR

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

Your AI can read this via Docs MCPcurl -fsSL "https://docs.atlan.com/install-docs-mcp" | bashConnect
Who can do this?

You will probably need your SAP HANA administrator to run these commands - you may not have access yourself.

Did you know?

This connector supports both SAP HANA on-premise as well as SAP HANA Cloud and 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:

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:

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

To only crawl metadata in Atlan:

GRANT SELECT METADATA ON SCHEMA <schema> TO <username>;
  • Replace <schema> with the name of the schema you want to crawl.

To crawl calculation views in Atlan:

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.