SAP HANA

Applies to: Dataedo 24.x (current) versions, Article available also for: 10.x, 23.x

Catalog features

Data catalog

Dataedo documents metadata of following objects:

  • Tables
  • Views
  • Functions
  • Procedures
  • Edges
  • Vertices

For more details, go to Connector specification section

Data lineage

Dataedo does not supports automatic lineage in SAP Hana, however user can use manual lineage in documentation.

Data profiling

Dataedo supports profiling tables imported from SAP HANA.

During the profiling process SAP HANA's special dates are treated as regular values, not NULLs. Some database explorers (eg. DBeaver) can display NULL in a place of special date because of limitations of the JDBC driver. You can read more here.

How to connect

Provide connection details:

  1. Host - SAP HANA Cloud host,
  2. Port - SAP HANA Cloud port,
  3. User - SAP HANA database user,
  4. Password - Password to the SAP HANA database user

Credentials

Connector specification

Imported objects

Object Imported as
Table Table
View View
Function Function
Procedure Procedure
Edge Graph Edge
Vertex Graph Node

Tables metadata

Metadata Imported as
Schema Schema
Name Name
Description Description
Columns Columns
   Name Name
   Data type Data type
   Null/Not null Nullable
   Description Description
Foreign Keys Relationships
   Constraint table FK Table
   Referenced table PK Table
   Name Relationship name
Primary/Unique keys Unique keys
   Name Key name
   Columns Columns
   Description Description
Triggers Triggers
   Definition Script
   Name Name
   Action When

Views metadata

Metadata Imported as
Schema Schema
Name Name
Description Description
Definition Script
Columns Columns
   Name Name
   Data type Data type
   Null/Not null Nullable
   Description Description

Functions metadata

Metadata Imported as
Schema Schema
Name Name
Description Description
Definition Script
Parameters Input/Output
   Name Name
   Data type Data type
   IN/OUT Mode

Procedure metadata

Metadata Imported as
Schema Schema
Name Name
Description Description
Definition Script
Parameters Input/Output
   Name Name
   Data type Data type
   IN/OUT Mode

Edges metadata

Metadata Imported as
Schema Schema
Name Name
Description Description
Columns Properties
   Name Name
   Data type Data type
Foreign Keys Relationships
   Constraint table FK Table
   Referenced table PK Table
   Name Relationship name
   Condition Join
Primary/Unique keys Unique keys
   Name Key name
   Columns Columns
Triggers Triggers
   Definition Script
   Name Name
   Action When

Vertices metadata

Metadata Imported as
Schema Schema
Name Name
Description Description
Columns Properties
   Name Name
   Data type Data type
   Null/Not null Nullable
Foreign Keys Relationships
   Constraint table FK Table
   Referenced table PK Table
   Name Relationship name
   Condition Join
Primary/Unique keys Unique keys
   Name Key name
   Columns Columns
Triggers Triggers
   Definition Script
   Name Name
   Action When

Limitations

  • Dataedo deas not support importing OLAP Cubes
  • Dataedo doeas not support importing JSON Documents
  • User defined data types are imported as tables