Dundas BI - System Requirements

Contents[Hide]

1. Overview

Dundas BI is a web-based server application that requires IIS and access to Microsoft SQL Server for storing application data.

2. Client

Below are the minimum web browser and OS requirements for client-side devices.

Desktop:

  • Chrome v.26
  • Firefox v.20
  • Internet Explorer v.11
  • Safari v.6 - not supported on Windows

Mobile:

  • iOS 6
  • Android 4.0 - for Android Chrome browser only

3. Server

Below are the hardware and software requirements for the Dundas BI server.

Processor:

  • 1.5 GHz - minimum for evaluation or testing
  • 2.0 GHz - minimum for production use

RAM:

  • 4 GB - minimum for evaluation or testing
  • 8 GB - minimum for production use
  • 16 GB - minimum for production use with in-memory analytics

Hard disk space:

  • 10 GB free - minimum for evaluation or testing
  • 50 GB free - minimum for production use

Operating system:

Only 64-bit operating systems are supported. Note that Core and Home editions of the following operating systems are not supported because they lack IIS features which Dundas BI requires (such as Windows Authentication and SSL certificates).

  • Windows Vista SP2 - evaluation use only
  • Windows 7 SP1 - evaluation use only
  • Windows 8 / 8.1 - evaluation use only
  • Windows 10 - evaluation use only
  • Windows Server 2008 - Server Core is not supported
  • Windows Server 2008 R2 - Server Core is supported with SP1 or later
  • Windows Server 2012 / 2012 R2

Desktop operating systems such as Windows Vista/7/8/10 are supported for evaluation use only because of limitations such as connection limits which make them unsuitable for production use.

.NET Framework:

  • .NET Framework 4.5.1 or higher

Web server:

  • IIS 7 or higher

Database server (can be the same server or a separate server):

  • Microsoft SQL Server 2008 / 2008 R2 / 2012 / 2014 / 2016
  • Microsoft SQL Server Express Editions are supported but not recommended for production use due to limitations
  • Microsoft SQL Azure – If you are using SQL Azure for the Dundas BI App DB and/or Warehouse DB, it must be V12 or higher

Note that the database server must be configured to accept remote connections.

4. Data sources

Dundas BI can connect to the following types of data sources, each of which may have additional (driver) requirements for the Dundas BI server as indicated below.

Data SourceAdditional Driver Requirements
Amazon Redshift Npgsql - .Net Data Provider for Postgresql
Excel and Flat files Microsoft Access Database Engine 2010 Redistributable
Google Analytics / BigQuery / Sheets None
Microsoft Access and DBF Microsoft Access Database Engine 2010 Redistributable
Microsoft Dynamics CRM None
Microsoft SQL Server 2005 or higher
Microsoft SQL Server 2005 Express or higher
None
Microsoft SQL Server Analysis Services 2005 or higher (including tabular instance) None
MySQL 5.0.45 or higher MySQL Connector/Net driver
OData (Open Data Protocol) None
ODBC (generic) ODBC driver for the specific data source
Oracle 10g / Oracle 10g Express Edition (XE)
Oracle 11g / Oracle Database Express Edition 11g
Oracle 12c

Oracle Data Provider for .NET (ODP.NET v2.111.7.20 or higher)

Note: After adding and configuring the tnsnames.ora file, you need to Recycle the App Pool and refresh the browser.

Oracle 11g Essbase None
PostgreSQL Npgsql - .Net Data Provider for Postgresql
Salesforce.com None
SAP NetWeaver BW 7.0 or higher None
SharePoint Lists and Excel Services None
Teradata 12.0 or higher .NET Data Provider for Teradata
XML file None

5. Installation

Dundas BI requires certain additional software on the server. You can download the following installer packages and install them on the server yourself. Or, the Dundas BI installer will automatically download and install them for you if they're not already installed on the system. This requires an active Internet connection.

You will also need:

  1. The user ID and password of an account on your SQL Server instance that has db_create permissions.
  2. The user ID and password of an account to use for the IIS application pool.
  3. A web server port to run Dundas BI on (the installer will choose a default) or an existing website for installing Dundas BI as a virtual directory (the IIS “Default Website” is fine).

 

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri