SAP HANA metadata collector
Provides read-only access to metadata from a SAP HANA instance.
Use this collector to harvest database, schema, tables, columns, views, stored procedures, and functions from SAP HANA.
Metadata cataloged
The collector catalogs the following information.
|
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), Sample rows (if data sampling is enabled) |
|
Table Index |
Index Cardinality, Column name, Index Type, Index Name, is non Unique, Ordinal Position, Pages, Sort Sequence |
|
Columns |
Index Cardinality, Column name, Index Type, Index Name, is non Unique, Column Ordinal Position, Pages, Column Sort Sequence |
|
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 |
Catalog pages show relationships between the following data asset types:
| Object | Relationship |
|---|---|
| Database | Has schema |
| Schema | Part of database, Has functions and stored procedures, Has tables |
| Tables | Has Columns |
| Table Indexes | Part of schema, Was generated by Stored Procedures |
| Columns | Part of tables or views |
| Table Indexes | Table Indexes, Columns |
| Views | Has columns |
Lineage for SAP HANA
The following lineage information is collected by the collector.
| 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.
- Prepare to run the SAP HANA collector
Set up authentication and configure the necessary privileges before you run the SAP HANA metadata collector. - Create an SAP HANA metadata collector
Create a collector to import metadata from SAP HANA.
Parent Topic:Configuring metadata collectors
--- title: SAP HANA metadata collector description: Provides read-only access to metadata from a SAP HANA instance. locale: en-US canonical_url: https://www.servicenow.com/docs/r/integrate-applications/sap-hana-metadata-collector.html release: brazil topic_type: concept last_updated: "2026-09-10" reading_time_minutes: 1 breadcrumb: [Configuring metadata collectors, Data Catalog, Workflow Data Fabric] --- # SAP HANA metadata collector Provides read-only access to metadata from a SAP HANA instance. Use this collector to harvest database, schema, tables, columns, views, stored procedures, and functions from SAP HANA. ## Metadata cataloged The collector catalogs the following information. <table id="table_f3w_2v4_bkc"><thead><tr><th> Object </th><th> Information cataloged </th></tr></thead><tbody><tr><td> Database </td><td> Name, Database Type, Connection Info \(Database Name, Port, Server, JDBC URL\), Associated Schema </td></tr><tr><td> Schema </td><td> Name, Associated Database, Associated Functions, Associated Stored Procedures, Associated Tables Extended Metadata: Owner, Created </td></tr><tr><td> Tables </td><td> Name, Associated Columns, Primary Key \(Key Name, Key Columns\), Foreign Keys \(Key Name, Source Columns, Target Columns\), Sample rows \(if data sampling is enabled\) </td></tr><tr><td> Table Index </td><td> Index Cardinality, Column name, Index Type, Index Name, is non Unique, Ordinal Position, Pages, Sort Sequence </td></tr><tr><td> Columns </td><td> Index Cardinality, Column name, Index Type, Index Name, is non Unique, Column Ordinal Position, Pages, Column Sort Sequence </td></tr><tr><td> Views </td><td> Name, SQL Definition, Associated Columns, Rows Filtered By, Rows Ordered By </td></tr><tr><td> Functions </td><td> Name, Description, Function Type Extended Metadata: Function Definition, Owner, Created </td></tr><tr><td> Stored Procedures </td><td> Name, Description, Stored Procedure Type, Rows Filtered By, Sourced Data From Extended Metadata: Procedure Definition, Owner, Created </td></tr></tbody> </table>## Relationships between objects Catalog pages show relationships between the following data asset types: |Object|Relationship| |------|------------| |Database|Has schema| |Schema|Part of database, Has functions and stored procedures, Has tables| |Tables|Has Columns| |Table Indexes|Part of schema, Was generated by Stored Procedures| |Columns|Part of tables or views| |Table Indexes|Table Indexes, Columns| |Views|Has columns| ## Lineage for SAP HANA The following lineage information is collected by the collector. |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. - **[Prepare to run the SAP HANA collector](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/integrate-applications/prepare-to-run-sap-hana-collector.md)** Set up authentication and configure the necessary privileges before you run the SAP HANA metadata collector. - **[Create an SAP HANA metadata collector](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/integrate-applications/create-sap-hana-metadata-collector.md)** Create a collector to import metadata from SAP HANA. **Parent Topic:**[Configuring metadata collectors](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/integrate-applications/configure-metadata-collectors-dc.md)
| title | SAP HANA metadata collector |
| description | Provides read-only access to metadata from a SAP HANA instance. |
| locale | en-US |
| canonical_url | https://www.servicenow.com/docs/r/integrate-applications/sap-hana-metadata-collector.html |
| release | brazil |
| topic_type | concept |
| last_updated | 2026-09-10 |
| reading_time_minutes | 1 |
| breadcrumb | Configuring metadata collectorsData CatalogWorkflow Data Fabric |