SAP HANA

Updated on May 12, 2025

Note: This article covers SAP HANA Destination setup process. This guide doesn’t cover the DataPrep setup for SAP HANA.

Description

‍SAP HANA is an in-memory database platform that accelerates data processing and analytics, empowering businesses with real-time insights and applications.

Setup guide

Follow our setup guide to connect SAP HANA to Improvado.

Permissions

You should have the following permissions for the database:

Object privileges:

ALTERY

System privileges:

IMPORT

Schema privileges:

CREATE ANY
DELETE
DROP
EXECUTE
INDEX
INSERT
SELECT
UPDATE
SELECT METADATA

Complete configuration

On the SAP HANA connection page, fill in the following fields:

Enter a name for your Destination connection in the Title.
Enter the Host.
Enter the Port.
Enter the User Name.

Enter the Password.
(Optional) Specify the Schema of your database.
Select the necessary Use static IP option from the dropdown.

Select the necessary Use binary strings option from the dropdown.

‍

Additional information

Load limits

You can load no more than 5000 columns per single load order.

Restrictions

Column date required
We use a column-base table
New data is provided in full monthly partitions on one dimension date
New fields are added to the table automatically
Deleting fields from the source report is prohibited