How to set up SAP HANA

πŸ€“ 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'd like to crawl.
🚨 Careful! Your SAP HANA administrator will need to run these statements for each schema you want to crawl.

Related articles

Was this article helpful?
0 out of 0 found this helpful