Data Warehouse and Reporting server requirements

You must run the Data Warehouse and the Reporting server on a computer that is compatible with established hardware and software requirements, ensuring that Apache web server or reporting software is not already installed on this machine. Data Warehouse is supported only on the Internet Explorer browser.

Important: Sizing for OnCommand Insight has multiple dependencies, such as number of assets in your environment, amount of historical data retained, and more. The following data warehouse sizing examples are guidelines only; they represent some of the environments in which Insight has been tested. Changing any of these or other factors in the environment can change the sizing requirements for Insight.

It is recommended to contact your Sales Engineer for detailed sizing guidance before installing or upgrading Insight.

Environment factors: Disk space, CPUs, and Memory tested:
18 storage arrays

3,400 VMs

4,500 switch ports

200 GB hard disk

8 cores


110 storage arrays

11,500 VMs

14,500 switch ports

300 GB hard disk

8 cores



Component Required
Operating system Computer running 64-bit Microsoft Windows Server 2008 R2, 2012, 2012 R2, or 2016 with the latest service pack.
Note: Windows Server 2008 R2 requires Microsoft Visual C++ 2008 Redistributable Package, available at the following URL:
Note: Cognos Reporting is not supported on Windows 2016. Data Warehouse without Reporting is supported on Windows 2016.
Virtual machine (VM) This component can run in a virtual environment, provided that the CPU and memory resources for your instance are reserved.
CPU 8 - 40 CPU cores
Memory 32 GB - 2 TB RAM

Best Practice: It is strongly recommended to set the paging file size to "Windows managed". Small, fixed-size paging files may interfere with the successful storage of Insight performance data.

Available disk space 200 GB - 2 TB disk space

Installation requires a minimum of 20 GB free on the C: drive.

  • 100 Mbps or 1 Gbps Ethernet connection
  • Static IP address
  • For the OnCommand Insight DWH server process, ports 80, 443, 1098, 1099, 3873, 8083, and 4444 through 4446
  • For the reporting engine, ports 1527, 9362, 9300, and 9399
  • For MySQL, port 3306
  • Ensure that DNS is properly working by doing an nslookup against the host
Virus Scan During the installation of this OnCommand Insight component, you must completely disable all virus scanners. Following installation, the paths used by the Insight component (install, backup, and archiver paths) must be excluded from virus scanning.