Operating system and database support - server
| Operating system | OS version | Database | Database version | Comments |
|---|---|---|---|---|
| Windows Server |
2012 2012 R2 |
SQL Server |
2012 SP1 Enterprise Edition (x64) 2012 SP1 Standard Edition (x64)* 2014 (x64)* 2016* *Supports columnstore indexes |
The version of server operating system should match the given requirements for Business Vault Data Warehouse Designer (DWD). For better performance, we recommended that you apply columnstore indexes to the DWD models and ensure that the correct version of SQL server is installed. Enterprise Edition may be needed based on server sizing and configuration. |