SAP HANA (BETA)

Add SAP HANA as a decube connection and help your team discover, document and monitor their data assets to drive data-driven insights and decisions.

Supported Capabilities

Supported Capabilities

General

• Metadata — metadata extraction and display of asset information (tables, columns, schemas). Types collected: Schema, Table, Column, View

• View Table — view tables, which are virtual tables based on SQL queries

Not Supported

General

• Profiling

• Preview

• Data Quality

• External Table

• Stored Procedure

• Calculation View

• Analytic View

• Attribute View

Connection Requirements

Connecting to decube requires credentials to your SAP HANA instance. At a minimum, we require:

• username

• password

• host address

• host port

• database / tenant name

The source name will be for you to differentiate and recognize particular sources within the decube application.

We strongly encourage you to create a decube read-only user for this credential purpose. Follow the steps below to set up a custom user with least-privilege access.

Custom User for decube

Creating a dedicated database user for decube follows the principle of least privilege, giving decube only the permissions it needs to monitor your data without risking broader database security.

1. Create the decube user

Log in to your SAP HANA instance with an administrative account (e.g., SYSTEM or a user with USER ADMIN privileges) and run:

-- Create the dedicated service user, keep note of the username and password
CREATE USER DECUBE PASSWORD "<password>" NO FORCE_FIRST_PASSWORD_CHANGE;

-- Disable password expiration for uninterrupted ingestion
ALTER USER DECUBE DISABLE PASSWORD LIFETIME;

2. Grant the required permissions

decube requires SELECT METADATA granted to the DECUBE user, for every schema you want to ingest:

-- Grant metadata read access for each schema you wish to ingest.
GRANT SELECT METADATA ON SCHEMA "<schema_name>" TO DECUBE;

See the SAP documentation on SELECT METADATA for more detail.

Encryption & SSL Configuration

decube supports encrypted SSL connections to SAP HANA instances via the Enable SSL toggle.

If your enterprise database or cloud environment enforces custom CA verification, select Use Customer CA Cert and upload your .pem or .crt certificate file.