Documentation

SAP HANA

Updated on

Sep 5, 2024

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

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

Follow our setup guide to connect SAP HANA to Improvado.

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

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

  1. 1Enter a name for your Destination connection in the Title.
  2. 2Enter the Host.
  3. 3Enter the Port.
  4. 4Enter the User Name.
  1. 5Enter the Password.
  2. 6(Optional) Specify the Schema of your database.
  3. 7Select the necessary Use static IP option from the dropdown.

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

  • 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
No items found.
Check out troubleshooting guides for
SAP HANA
here:
No items found.
Related articles
No items found.
No items found.

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.