Crawl SAP HANA

Create a crawler workflow to automatically discover and catalog your SAP HANA assets, including databases, schemas, tables, views, and columns.

Prerequisites

Before you begin, make sure you have:

• Configured SAP HANA user permissions with metadata read access
• SAP HANA database connection details (host, port, credentials)
• Reviewed the order of operations for workflow execution

Create crawler workflow

Create a new SAP HANA crawler workflow in Atlan by selecting the SAP HANA connector package, configuring your extraction method and connection details, and running the crawler to extract metadata.

1. In the top right of any screen, navigate to New and then click New Workflow.
2. From the list of packages, select SAP HANA Assets and click Setup Workflow.

Configure extraction

Select your extraction method and provide the connection details.

Direct

In Direct extraction, Atlan connects to your database and crawls metadata directly.

1. For Host, enter the host name for your SAP HANA instance.
2. For Port, enter the port number for your SAP HANA instance.
3. For Username, enter the username you created for the instance.
4. For Password, enter the password for the username.
5. Click the Test Authentication button to confirm connectivity to SAP HANA.
6. Once authentication is successful, navigate to the bottom of the screen and then click Next.

Offline

In Offline extraction, you use Atlan's metadata-extractor tool to extract metadata from SAP HANA and store it in S3.

1. Complete the offline extraction setup to extract and upload metadata files to S3.
2. For Bucket name, enter the name of your S3 bucket or Atlan's bucket.
3. For Bucket prefix, enter the S3 prefix under which all the metadata files exist. These include databases.json, columns-<database>.json, and similar files.
4. For Bucket region, enter the name of the S3 region if your bucket is in a specific region.
5. Click Next at the bottom of the screen.

Agent

In Agent extraction, Self-Deployed Runtime executes metadata extraction within your organization's environment.

1. Install Self-Deployed Runtime if you haven't already.
2. Select the Agent tab.
3. Store sensitive information in the secret store configured with the Self-Deployed Runtime and reference the secrets in the corresponding fields. For more information, see Configure secrets for workflow execution.
4. For details on individual fields, refer to the Direct extraction tab.
5. Click Next after completing the configuration.

Configure connection

Set up connection details including a descriptive name, admin access, and data access permissions.

1. Provide a Connection Name that represents your source environment. For example, you might use values like production, development, gold, or analytics.
2. To change the users able to manage this connection, update the users or groups listed under Connection Admins. If you don't specify any user or group, nobody can manage the connection, including admins.
3. To prevent users from querying SAP HANA data, change Allow SQL Query to No. This option applies only to Direct extraction.
4. To prevent users from previewing SAP HANA data, change Allow Data Preview to No. This option applies only to Direct extraction.
5. Click Next at the bottom of the screen.

Configure crawler

Configure crawler settings to control which assets to include or exclude. If an asset appears in both filters, the exclude filter takes precedence.

1. To select specific assets for crawling, click Include Metadata. By default, all assets are included.
2. To exclude specific assets from crawling, click Exclude Metadata. By default, no assets are excluded.

Run crawler

Run preflight checks to validate your configuration, then execute the crawler immediately or schedule it to run on a recurring basis.

1. To verify permissions and configuration before running, click Preflight checks.
2. Choose your run option:
   • To run the crawler once immediately, click Run at the bottom of the screen.
   • To schedule the crawler to run hourly, daily, weekly, or monthly, click Schedule Run at the bottom of the screen.

Once the crawler completes, you can view the assets in Atlan's asset page.

See also

• What does Atlan crawl from SAP HANA: Complete reference of assets and metadata discovered during crawling
• Preflight checks for SAP HANA: Validation checks for permissions and configuration before running the crawler