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
Includes calculation views created in the HANA Deployment Infrastructure (HDI).
•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.
To extract metadata from calculation views created in the HANA Deployment Infrastructure (HDI), verify that you have the following permissions:
- SELECT on _SYS_BI.BIMC_SOURCES
- READ permission on the HDI Container schema database
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.
Connection Properties
After you configure a connection to SAP HANA in Informatica Intelligent Cloud Services Administrator, you can view the connection properties for that connection on the Registration page in Metadata Command Center.
The following table describes the SAP HANA connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Runtime Environment
The name of the runtime environment where you want to run tasks.
Host
SAP HANA server host name.
Port
SAP HANA server port number.
Database Name
Name of the SAP HANA database.
Current Schema
SAP HANA database schema name.
Code Page
The code page of the database server defined in the connection.
Select the UTF-8 code page.
Username
User name of the SAP HANA account.
Password
Password of the SAP HANA account.
The password can contain alphanumeric characters and the following special characters: ~ ` ! @ # $ % ^ & * ( ) _ - + = { [ } ] | : ; ' < , > . ? /
Note: You can't use a semicolon character in combination with a left brace or right brace character.
The following table describes the advanced connection properties:
Metadata Advanced Connection Properties
Not applicable for extracting metadata in Metadata Command Center.
Run-time Advanced Connection Properties
Not applicable for extracting metadata in Metadata Command Center.
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: