Documentation

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
• ~The maximum length is 32 characters
• Password
• Use static IP
• Database Name
• ~The maximum length is 64 characters

It could be configured via admin

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

Required permissions:

• ```CREATE TABLE```
• ```CREATE INDEX```
• ```ALTER TABLE```
• ```SELECT```
• ```INSERT```
• ```DELETE```
• ```TRUNCATE```

Load limits

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