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.
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.
Description
Description of the connection. Maximum length is 4000 characters.
Type
SAP HANA.
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.
Specify _SYS_BIC when you use SAP HANA database modelling views.
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: