Dundas BI - System Requirements

Contents[Hide]

Version 7.0.2

1. Overview

Dundas BI is a web-based server application that runs on Windows or Linux and with either Microsoft SQL Server or PostgreSQL. It can also connect to a variety of other databases and data sources, which may require additional drivers to be installed.

2. Client

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

Desktop:

  • Chrome 26
  • Firefox 20
  • Internet Explorer 11 – not recommended due to known limitations
  • Safari 6 – not supported on Windows
  • Microsoft Edge

Important
For a list of known browser limitations and their effect on the application, see Dundas BI – Product Notes.

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

At least two logical cores are required for in-memory storage.

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 systems:

Only 64-bit operating systems are supported.

  • Windows 10 - evaluation use only
  • Windows Server 2012 R2 or higher
  • Red Hat Enterprise Linux (RHEL) 7.3-7.x
  • Ubuntu 18.04 LTS
  • Amazon Linux 2

There are certain known limitations when installing Dundas BI on Linux. For more information see here.

Note that Windows Core and Home editions are not supported. Desktop operating systems such as Windows 10 are supported for evaluation use only because of limitations which make them unsuitable for production use.

.NET:

  • For Windows - .NET Framework 4.7.2 or higher (installed automatically as a part of the prerequisites check)
  • For Linux - ASP.NET Core 3.1

Web server:

  • For Windows - IIS 8.5 or higher (installed automatically as a part of the prerequisites check)
  • For Linux - NGINX (installed automatically)

Application database server:

One of the following is used by Dundas BI to store its own application data:

  • Microsoft SQL Server 2012 or higher - SQL Server 2014 or higher recommended
  • Microsoft SQL Server Express Editions - supported but not recommended for production use due to limitations; Microsoft SQL Server Express LocalDB is not supported
  • Microsoft SQL Azure V12 or higher
  • PostgreSQL version 9.6 or higher

Note
PostgreSQL can be installed automatically for evaluation purposes when installing Dundas BI using the Express deployment option.

This can be on the same server or separate from the web server (the database server must be configured to accept remote connections if separate).

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. Necessary drivers for Linux are included in the installation.

The ODBC and JDBC support listed below means that Dundas BI can also connect to various other data sources using the corresponding ODBC/JDBC driver.

Data SourceWindows SupportLinux Support
Amazon Redshift Drivers included Drivers included
Exasol Exasol ADO.NET driver Not supported on Linux
Flat file sources Drivers included Drivers included
Google Analytics / BigQuery / Sheets Drivers included Drivers included
JDBC (generic) 64-bit version of the Java SE Runtime Environment version 8 or above and the 64-bit version of the JDBC driver for the specific data source Not supported on Linux
IBM DB2 database
IBM Data Server Package (DS Driver) Not supported on Linux
MemSQL Drivers included Drivers included
Microsoft Access and DBF
Microsoft Access Database Engine 2010 Redistributable Not supported on Linux
Microsoft Dynamics CRM
Drivers included Not supported on Linux
Microsoft Excel Microsoft Access Database Engine 2010 Redistributable Drivers included
Microsoft SQL Server 2005 or higher
Microsoft SQL Server 2005 Express or higher
Drivers included Drivers included
Microsoft SQL Server Analysis Services 2005 or higher - including tabular instance
Drivers included Not supported on Linux
MySQL 5.0.45 or higher Drivers included Drivers included
OData (Open Data Protocol) Drivers included Drivers included
ODBC (generic) 64-bit version of the ODBC driver for the specific data source 64-bit version of the ODBC driver for the specific data source
Oracle database

Drivers included

Note: After adding and configuring the tnsnames.ora file, you need to recycle the application pool and refresh the browser

Drivers included
Oracle 11g Essbase Drivers included Drivers included
Pardot Drivers included Drivers included
PostgreSQL Drivers included Drivers included
Salesforce.com
Drivers included Not supported on Linux
SAP HANA

SAP Support portal (SAP account required)

For information about installing and setting up the SAP HANA HDB client, click here.

Not supported on Linux
SAP NetWeaver BW 7.0 or higher Drivers included Drivers included
SharePoint Lists and Excel Services
Drivers included Not supported on Linux
Snowflake Drivers included Drivers included
Teradata 12.0 or higher Drivers included Drivers included
Vertica database
Drivers included See the Vertica documentation on Installing ODBC Drivers on Linux.
XML file Drivers included Drivers included

5. Installation

5.1. For Windows

The Dundas BI deployment application checks if the following prerequisites are installed on the server and can automatically download and install any missing prerequisites (this requires an active internet connection).

If you need to install them manually, use the links below to access them or press the F8 key when on the Prerequisites screen in the Deployment application to download the list of URLs.

5.2. For Linux

Certain requirements are installed automatically when running the Dundas BI deployment wizard (this requires an active internet connection). If you need to install them manually you can use the links below to access them.

Important
For Amazon Linux 2, you must install the ASP.NET Core Runtime manually before you begin the Dundas BI installation.

5.3. Additional requirements

  1. The user ID and password of an account on your SQL Server instance that has db_create permissions or a usesuper account on PostgreSQL.

    Note
    After the installation, the SQL Server administrator will require only db_owner permissions. A PostgreSQL administrator will require the CanSelect, CanUpdate, CanInsert, and CanDelete table privileges, as well as the CanCreate database privilege.

  2. For Windows installs, 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).

For details on deploying Dundas BI, see Installing Dundas BI or Installing Dundas BI on Linux.

 

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:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri