SAP Hana

Steps to integrate your Hana storage with Atlan

Atlan natively supports SAP Hana, which allows you to seamlessly integrate the SAP Hana database with your Atlan workspace.

๐Ÿ’ญ TL;DR

You can set up a SAP Hana integration with your Atlan workspace in four easy steps:

  1. Select the source, aka SAP Hana ๐Ÿ˜‰

  2. Provide your credentials โœ๏ธ

  3. Set up your configuration ๐Ÿ—„๏ธ

  4. Schedule automatic updates ๐Ÿ•‘

๐Ÿ”‘ SAP Hana user permissions

Make sure you run these commands as "USER ADMIN".

Follow these instructions to configure user permissions:

  1. On the "System Overview" page, navigate to the "User & Role" Management area.

  2. Choose the option "Assign Privileges". The "Assign Privileges" app will open.

  3. Find the user you want to edit. The user's existing privileges and who assigned those privileges will be displayed.

  4. To assign privileges to the user, follow the steps below:

    1. Go to "Object Privileges" and click on "Edit".

    2. Choose "Add", and select the following privileges:


      • For TABLES, add "SELECT" privileges to the tables you want to crawl in Atlan.

    3. Save the privilege assignment.

    4. Go to "System Privileges" and click "Edit".

    5. Choose "Add", and select the "CATALOG READ" privileges.

    6. Save the privilege assignment.

๐Ÿ“œ Prerequisites for SAP Hana integration

Before you get started, you'll need some information to help establish a connection between Atlan and your SAP Hana account.

  • Hostname: The URI before ":" in the endpoint of your SAP Hana instance, which is visible in SAP Hana Cloud.

  • Port: The port after ":" in the endpoint of your SAP Hana instance, which is visible in SAP Hana Cloud.

  • Username & Password: This is the username and password for your SAP Hana instance.

๐ŸŒŸ Pro Tip: If you don't have this information handy, reach out to your cloud or data lake administrator to get these details before you get started!

๐Ÿ› ๏ธ A step-by-step guide to integrate SAP Hana with Atlan

Once you have the prerequisite information listed above, please follow the steps below ๐Ÿ‘‡ to establish a connection and integrate Atlan with SAP Hana.

STEP 1: Select the source

  1. Log into your Atlan workspace.

  2. On the home screen, click on the "New Integration" button in the top right corner. You will see a dialogue box with the list of sources available on your workspace.

  3. Select "SAP Hana" from the list of options, and click on "Next".

STEP 2: Provide credentials

  1. You will see an option to either select a preconfigured credential from the drop-down menu or to create a credential. To set up a new connection, click on the "Create Credential" button.

  2. You will need to fill in your SAP Hana credentials. Here is an example of the required credentials:

    1. Hostname:

    2. Port: 443

    3. Username: username

    4. Password: xxxxxxx

  3. Once you have filled in the details, click on "Next".

SAP Hana setup

STEP 3: Set up your configuration

  1. Specify the database you want to crawl.

  2. Select the schema and table you want to crawl. Check "Include All" to include all schemas and tables.

  3. Choose whether to run the crawler once or schedule it for a daily, weekly, or monthly run. You will be asked to specify the time zone for the run.

  4. Click on "Create". Your connection is now created.

Congratulations! You have now integrated Atlan with your SAP Hana ๐ŸŽ‰

๐Ÿ Monitoring your SAP Hana integration

Once the integration setup is completed, you will be redirected to the "Monitor" tab for your SAP Hana asset, where you can monitor its progress.