Planning Setup

Planning Setup

Kyubit Business Intelligence could be installed on any windows machine with IIS, that has connection to MS SQL Server or MS Analysis Services which are used to create analyses, reports and dashboards.

Kyubit Business Intelligence is web application that has to be installed on the server with web server (IIS). SQL Server instance for Kyubit Business Intelligence internal database and SQL Server Analysis Services instance could be installed on a single server or distributed to multiple servers. For example, Kyubit Business Intelligence could be installed on Server A, its database could be located on Server B and use OLAP data while analyzing from SSAS (SQL Server Analysis Services) on Server C.

BI Tool planning setup

OLAP software Single Server Deployment (everything is on one machine)

SINGLE MACHINE

  • IIS (Kyubit Business Intelligence) installation
  • SQL Server instance for Kyubit BI Internal database
  • SQL Server Analysis Services (SSAS) instance (For Analysis)

In this scenario, "Windows Integrated" authentication (default after setup) can be used to connect to OLAP data sources.

OLAP software Distributed Environment Deployment

SERVER A

  • IIS (Kyubit Business Intelligence) installation


SERVER B

  • SQL Server instance for Kyubit BI Internal database


SERVER C

  • SQL Server Analysis Services (SSAS) instance (For Analysis)


In this scenario, "Kerberos Authentication", "Basic Authentication" or "Login Form authentication" should be configured on application to connect to OLAP data sources. More information about authentication see in "Configuration" tutorial section.
Kyubit Business Intelligence communicates with its internal SQL server database using windows account defined within setup procedure. After Kyubit Business Intelligence setup, connection to SSAS (SQL Server Analysis Services) is impersonated with current user credentials using Kyubit Business Intelligence web application.

OLAP software Hardware Requirements

Kyubit BI is lightweight web application that will certainly not take too much resources of your server. Kyubit BI is creating MDX and SQL queries to the MS SQL Server and MS Analysis Service (that are actually doing most of the work) and renders results in HTML5/javascript technology on the browsers. Memory usage on the server where Kyubit BI is installed could be impacted by higher number of concurrent users or by the nature of analysis and queries that could generate significant amount of data.

4 GB RAM is recommended minimum to use Kyubit Business Intelligence in concurrent environment with other users.

CPU and Hard Disk usage are not of concern while planning setup, as requirements and impact for minimum configuration are far below today's standards for any computer.