🤓 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>;
🚨 Careful! Your SAP HANA administrator will need to run these statements for each schema you want to crawl.