Skip to content

SAP HANA Connector

SAP HANA is SAP's in-memory, column-oriented relational database, used by many enterprises as the operational and analytical layer behind S/4HANA, BW/4HANA, and custom data marts. It is offered as SAP HANA Cloud (managed by SAP, TLS-only) and as on-premises HANA deployments running in customer-managed environments.

The Qualytics SAP HANA connector uses the official SAP HANA JDBC driver (ngdbc) to profile tables, run scheduled scans, and surface record- and schema-level anomalies on schemas exposed by your HANA database, alongside your other data sources.

Deep Dive

  • Permissions

    Minimum HANA privileges the connection user needs to discover schemas, read metadata, and run profile and scan queries.

    Permissions

  • Authentication

    Basic username and password authentication, plus notes on TLS, certificate validation, and tenant database selection.

    Authentication

  • Troubleshooting

    Common SAP HANA connection errors and how to resolve them: credentials, TLS, missing schema, and tenant database mismatch.

    Troubleshooting

Managing

  • Add Source Datastore

    Step-by-step UI walkthrough for adding SAP HANA as a source datastore, with new or existing connections.

    Add Source Datastore

  • Create via API

    REST and CLI payload examples for creating SAP HANA source datastores, covering HANA Cloud and on-premises deployments.

    Create via API

Also works as an enrichment datastore

SAP HANA can be used both as a source datastore and as an enrichment datastore where Qualytics writes anomalies and metadata. See Supported Enrichment Datastores.

Notes

HANA Cloud vs on-premises. Both deployment models use the same connector. HANA Cloud endpoints are TLS-only on port 443 and the tenant is encoded in the hostname, so the Database field is left blank. On-premises HANA listens on 3<instance>15 (typically 39015 for instance 00), supports multi-tenant container deployments, and accepts an explicit tenant Database name.

Identifier case. HANA preserves identifiers as written when unquoted and converts them to upper case. The Schema dropdown shows schemas exactly as HANA stores them; reuse that exact casing in checks, comparators, and SQL filters.