SAP HANA is a multi-model database system that stores data in its memory and performs high-speed processing and analytics of data. Configure an SAP HANA catalog source to extract metadata from an SAP HANA database.
Objects extracted
Metadata Command Center extracts the following objects from an SAP HANA database:
•Table
•Column
•Plain SQL Database Views (Views created using the CREATE VIEW syntax)
•View Column
•Schema
•Calculation View
•Attribute
•Constraints (Primary Key and Foreign Key)
•Sequence
Configure permissions or access to SAP HANA Database
To extract metadata and run profiles, you need account access and permissions on the SAP HANA Database source system.
Permissions to extract metadata
Grant permissions that allow you to perform the following operations:
- select on SYS.FUNCTIONS
- select on SYS.FUNCTION_PARAMETERS
- select on SYS.PROCEDURES
- select on SYS.PROCEDURE_PARAMETERS
- select on SYS.SYNONYMS
- select on SYS.SCHEMAS
- select on SYS.TABLES
- select on SYS.VIEWS
- select on SYS.TABLE_COLUMNS
- select on SYS.VIEW_COLUMNS
- select on SYS.M_TABLES
- select on SYS.CONSTRAINTS
- select on SYS.REFERENTIAL_CONSTRAINTS
- select on _SYS_REPO.ACTIVE_OBJECT
Verify that you configure the following permissions for the username that you use to connect to the database:
- SELECT METADATA on the schemas for which you want to import metadata.
- SELECT on the _SYS_BI and _SYS_BIC system schemas.
Permissions to run data profiles
Ensure that you have the required permissions to run profiles.
Grant SELECT permission for tables and views that you want to profile.
Data classification for SAP HANA objects
Configure data classification for SAP HANA catalog sources to classify and organize data in your organization. You can view the data classification results in Data Governance and Catalog.
Data Profiling for SAP HANA objects
You can run data profiles and data quality tasks for SAP HANA database assets. Configure data profiling to run profiles on the metadata extracted from an SAP HANA database source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following SAP HANA database objects:
•Tables
•Views
•Calculation Views
Sampling type
Determine the sample rows on which you want to run the data profiling task.
You can choose one of the following sampling types for an SAP HANA database catalog source: