Skip to main content

About the SAP HANA collector

Warning

This collector is in public preview. It has passed our standard testing, but it is not yet widely adopted. You might encounter unforeseen edge cases in your environment. data.world is committed to promptly addressing any issues with public preview collectors. If you face any problems, please report them through your Customer Success Director, implementation team, or support team for assistance.

Use this collector to harvest database, schema, tables, columns, views, stored procedures, and functions from SAP HANA.

Important

The SAP HANA collector can be run in the Cloud or on-premise using Docker or Jar files.

What is cataloged

The collector catalogs the following information.

Table 1.

Object

Information cataloged

Database

Name, Database Type, Connection Info (Database Name, Port, Server, JDBC URL), Associated Schema

Schema

Name, Associated Database, Associated Functions, Associated Stored Procedures, Associated Tables

Extended Metadata: Owner, Created

Tables

Name, Associated Columns, Primary Key (Key Name, Key Columns), Foreign Keys (Key Name, Source Columns, Target Columns)

Columns

Name, Data Type, Is Nullable, Column Size, Column Index, Decimal Digits, Default Value, JDBC Type, References

Views

Name, SQL Definition, Associated Columns, Rows Filtered By, Rows Ordered By

Functions

Name, Description, Function Type

Extended Metadata: Function Definition, Owner, Created

Stored Procedures

Name, Description, Stored Procedure Type, Rows Filtered By, Sourced Data From

Extended Metadata: Procedure Definition, Owner, Created



Relationship between objects

By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.

Table 2.

Resource page

Relationship

Database

  • Has schema

Schema

  • Part of database

  • Has functions and stored procedures

  • Has tables

Tables

  • Has Columns

  • Part of schema

  • Was generated by Stored Procedures

Columns

  • Part of tables or views

Views

  • Has columns



Lineage

The following lineage information is collected by the SAP Hana collector.

Table 3.

Object

Lineage available

Views

  • Has rows filtered by

  • Has rows ordered by

  • Has rows aggregated by

Functions

  • Has rows filtered by

  • Has rows ordered by

  • Has rows aggregated by

  • Sourced data from

Stored Procedures

  • Has rows filtered by

  • Has rows ordered by

  • Has rows aggregated by

  • Sourced data from



SAP HANA version supported

  • The collector supports SAP HANA version 2.00.076.00.20240701.1.

Authentication supported

The SAP HANA collector supports username and password authentication.

In this section: