Planning BI Tools Deployment

Environment & Architecture Planning

Kyubit Business Intelligence is a flexible analytics platform that can be deployed on any Windows environment with IIS, requiring a stable connection to MS SQL Server or MS Analysis Services (SSAS) to create reports and business dashboards.

The Kyubit BI web application is hosted on Internet Information Services (IIS). For maximum scalability, the SQL Server internal database and the SSAS instances can be hosted on a single machine or distributed across a multi-server architecture. For example, you can host the Kyubit application on Server A, the metadata database on Server B, and perform OLAP analysis on Server C.

BI Tool planning setup and server architecture

OLAP software deployment Single Server BI Deployment (All-in-one)

SINGLE MACHINE SETUP


In a single-server scenario, "Windows Integrated Authentication" is the recommended default for connecting to your OLAP data sources.

Distributed BI environment Distributed BI Environment Deployment

Server A: Web Tier (IIS & Kyubit BI)

  • Kyubit Business Intelligence IIS Installation


Server B: Data Tier (Metadata)

  • SQL Server Instance for internal application data


Server C: Analytics Tier (OLAP/Tabular)

  • SQL Server Analysis Services (SSAS) for Data Analysis


For distributed environments, configure Kerberos, Basic, or Login Form Authentication to ensure secure connectivity to remote data sources. More details can be found in our Configuration Settings tutorial.
Kyubit BI communicates with its internal SQL database using the service account defined during setup. Post-installation, connections to SSAS are impersonated based on the current user's credentials within the web application.

BI software hardware requirements Hardware & System Requirements

Kyubit BI is a lightweight self-service BI tool designed for high performance. It offloads heavy processing by sending MDX queries and SQL requests directly to the database servers, rendering responsive HTML5/JavaScript visuals in the browser.

4 GB RAM is the recommended minimum for a concurrent user environment. Performance may vary based on the complexity of your KPI dashboards and data queries.

CPU and Hard Disk usage are minimal, ensuring that Kyubit can run efficiently on modern server hardware with negligible impact on system resources. Check our BI Tools FAQ for more hardware specifics.