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.
We support only MS SQL 2016 or newer only
Select Yes for Use static IP option if you allow Improvado to connect your database by the following static IPs only:
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 above.
For performance reasons your database should support COLUMNSTORE.
You should have write access to database and the following permissions: