May 14, 2023
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.
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.
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.
You should have the following schema permissions:
You should have the following object permissions:
You can load no more than 5000 columns per single load order.