Documentation

SAP HANA

Updated on

Jan 9, 2024

IMPORTANT: This article covers setup of warehouse for load data from Improvado, not customer data warehouse from which data is being extracted. This article doesn't cover setup of customer data warehouse for Data Prep as well.

Required information

  • Title
  • Host
  • Port
  • User Name
  • ~User Name can only contain letters, numbers, and underscores and must start with a letter
  • ~The maximum length is 127 characters
  • Password
  • Schema (optional)
  • ~Specify the schema of your database
  • Use static IP

Note: according to the Naming Conventions for SAP HANA, names are NOT case sensitive (e.g., CUSTOMER is the same as Customer), but object names are converted to uppercase when stored in the SAP HANA database. However, if you enclose a name in quotation marks, it is case sensitive.

Use static IP

Select Yes for Use static IP option if you allow Improvado to connect your database by the static IPs mentioned on the Destination connection page.

Select No if you have permitted access to your database from any IP. In this case, Improvado will connect your database using dynamic IPs not listed on the Destination connection page.

How to connect

You should have the following schema permissions:

  • ```CREATE ANY```
  • ```DELETE```
  • ```DROP```
  • ```EXECUTE```
  • ```INDEX```
  • ```INSERT```
  • ```SELECT```
  • ```UPDATE```
  • ```SELECT METADATA```

You should have the following object permissions:

  • ```ALTER```

Load limits

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

Restrictions

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

How to connect from Python

Schema information

Setup guide

Settings

No items found.

Troubleshooting

Troubleshooting guides

Check out troubleshooting guides for
SAP HANA
here:

Limits

Frequently asked questions

No items found.
☶ On this page
Description
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.