How to set up SAP HANA

Have more questions? Submit a request
πŸ€“ Who can do this? You will 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 database platforms.

Currently, we only support basic username and password authentication for 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:

GRANT SELECT, SELECT METADATA on SCHEMA <schema> to <username>;
  • Replace <schema> with the name of the schema you'd like to crawl.

These permissions will allow you to crawl metadata as well as preview and query data in Atlan.

🚨 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