SAP HANA

Dominik Ilnicki - Dataedo Team Dominik Ilnicki 19th July, 2022
Applies to: Dataedo 10.x versions, Article available also for: 24.x (current), 23.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 24.x (current).

Dataedo 10.3 adds native connector to SAP HANA Cloud database. Right now we only support standard relational engine and graph tables, not OLAP cubes and JSON documents.

Supported schema elements and metadata

Dataedo reads following metadata from SAP Hana databases.

  • Tables
    • Columns
      • Data type with length
      • Nullable
    • Foreign keys
      • Columns
    • Primary keys
      • Columns
    • Triggers
      • When triggered
      • Script
  • Views
    • Columns
      • Data type with length
      • Nullable
    • Script
  • User-defined Functions
    • Script
    • Parameters
    • Returned value
  • User-defined Procedures
    • Script
    • Parameters
    • Returned value

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.

Connecting to SAP HANA

Add new connection

To connect to SAP HANA create new documentation by clicking Add documentation and choosing Database connection.

Image title

On the Add documentation window choose SAP HANA.

Connection details

Provide connection details:

  • Host - SAP HANA Cloud host,
  • Port - SAP HANA Cloud port,
  • User - SAP HANA database user,
  • Password - Password to the SAP HANA database user

Importing Metadata

When connection was successful Dataedo will read objects and show a list of objects found. You can choose which objects to import. You can also use advanced filter to narrow down list of objects.

Image title

Confirm list of objects to import by clicking Next.

Image title

Next screen allow you to change default name of the documentation under which it will be visible in Dataedo repository.

Click Import to start the import.

When done close import window with Finish button.

Outcome

Image title

Your SAP HANA database schema has been imported to new documentation in the repository.