Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

CardioLog Analytics version 4.0.0 or higher provides delivers reports via Microsoft Power BI.

The integration with Microsoft Power BI enables stakeholders and portal administrators to perform quick, on-demand slice & dice actions on their data through intuitive reporting dashboards, monitor the KPIs that mean the most to them, and search through it all in one glance.

The integration is available for on-premises deployments of Microsoft Power BI.

System Requirements

Inspect the following table to assure that your system meets the minimum hardware and software requirements. Please note that the these system requirements apply to CardioLog Analytics integration with Power BI only and does not include the application engine and database which require additional resources.

 

4 GB 16 ** 32 4 ** 8 Server :

1 GB

 Standard EditionProfessional EditionEnterprise Edition

Platform

64-bit

64-bit

64-bit

Operating System

Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched)

Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched)

Dedicated Windows 2008 R2/2012/2012 R2/2016 Server Standard Edition (fully patched)

 

Application Memory*

Minimum - 4 GB

Recommended - 8 GB

Minimum - 8 GB

Recommended - 16 GB

Minimum** - 16 GB

Recommended - 32 GB

Processors*

4 Cores

Minimum - 4 Cores

Recommended - 8 Cores

Minimum** - 8 Cores

Recommended - 16 Cores

SQL Server Edition

Microsoft SQL Server 2012/2014/2016/2017 Enterprise Edition (fully patched)

Microsoft SQL Server 2008/2008 R2/2012/2014/2016/2017 Standard Edition (fully patched)

Microsoft SQL Server 2008/2008 R2/2012/2014/2016/2017 Standard or Enterprise Edition (fully patched)

SQL Instance Memory

ClientPower BI Desktop*

Power BI Desktop

Power BI Desktop and/or web browser**
Server  Power BI Report Server***
SQL Server Edition SQL Server Enterprise EditionSQL Server Enterprise Edition
SQL Instance Memory 

Minimum - 8 GB

Recommended -

32 GB

Minimum

- 16 GB

Recommended -

64 GB

SQL Server Processors 

Minimum - 2 Cores

Recommended - 8 Cores

Minimum

-

4 Cores

Recommended - 16 Cores

SQL Storage 

 

 

SQL System Disk (Mirrored)

10 GB

10 GB

10 GB

SQL Page File Disk10 GB10 GB10 GB
SQL Database Disk20 GB per year60 GB per year
A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs
Maximum 600 GB per year
A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs
SQL Transaction Log Disk5 GB
A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs
Minimum ** - 50 80 GBRecommended - 100 GB
A separate physical hard disk, formatted with 64K blocks, or RDM on storage LUNs
SQL Temp Database Disk20% of Database Disk size20% of Database Disk size
Recommended - A separate physical hard disk, preferably solid-state drive (SSD)
20% of Database Disk size
Recommended - A separate physical hard disk, preferably solid-state drive (SSD)
SQL Temp Database Log Disk1 GB5 GB5 GB
SQL RAIDRAID 10 or similarRAID 10 or similarRAID 10 or similar
 
Additional Software & Services
  • Microsoft .NET Framework 3.5
  • Microsoft .NET Framework 4.6.2
  • Microsoft SQL Server Data-Tier Application Framework (x64)
  • IIS 7.0, 7.5, 8.0 or 8.5
  • Additional Web Server (IIS) Role Services
  • Google Chrome, Mozilla Firefox, Microsoft Internet Explorer 9.0 or higher
  • Microsoft .NET Framework 3.5
  • Microsoft .NET Framework 4.6.2
  • Microsoft SQL Server Data-Tier Application Framework (x64)
  • IIS 7.0, 7.5, 8.0 or 8.5
  • Additional Web Server (IIS) Role Services
  • Google Chrome, Mozilla Firefox, Microsoft Internet Explorer 9.0 or higher
  • Microsoft .NET Framework 3.5
  • Microsoft .NET Framework 4.6.2
  • Microsoft SQL Server Data-Tier Application Framework (x64)
  • IIS 7.0, 7.5, 8.0 or 8.5
  • Additional Web Server (IIS) Role Services
  • Google Chrome, Mozilla Firefox, Microsoft Internet Explorer 9.0 or higher

 

*   This refers to hardware allocated for the CardioLog application pool and services, not for the CardioLog SQL server

 

 

Option

Dev

Est.

System RequirementsAdditional Costs InvolvedAccess MethodCustomer SizeStorage LimitsPermissions Support

1) Power BI Desktop

via import mode

0

Client App

Windows 10, Windows 7, Windows 8, Windows 8.1, Windows Server 2008 R2

Windows Server 2012, Windows Server 2012 R2

Internet Explorer 10 or greater

Available for x64 or x86

 

In import mode consumes a lot of RAM (depending on dataset site)

Free

Desktop App

 

STD1GB

No, if connected via import mode

via Live connection mode

Requires SSAS (option #2)

Consume small amounts of RAM ~1GB

PRO

ENT

NoRLS via SSAS

2) Microsoft SQL Server

Analysis Services

Used for "Live connection" mode

for Report server or PBI Desktop

5

Server App

Recommended: 16 Cores, 64 gigabytes of RAM

Minimum: 64-bit dual-core processor, 3 gigahertz, 8 gigabytes of RAM

At least 80 gigabytes of storage

SQL Server Enterprise - $14,256

Desktop App or Web access (with option #3)

Used as intermedia

for large customers

Allows to load server RAM

instead of client RAM

PRO

ENT

No

Allows to have RLS (row-level security)

So basically allows having users support

3) Power BI Report Server

Used as GUI

Power BI Online substitutor

5

Server App

Recommended: 4GB RAM, x64 2.0GHz processor,

Minimum: 1GB RAM, x64 1.4GHz processor

Comes with Power BI Premium: ~5000$ monthly

OR

SQL Server Enterprise with Software Assurance Support

Cost is 25% from MS server products

Web access

STD

PRO

ENT

No

Has its own RLS, so supports many users

+ SSAS can be used if connected

 

 

Power BI report server prerequisites:

 

...

 SQL Server Analysis Services

SQL Server Analysis Services


(1) Up to a dataset size of 1 GB. 

(2) Access to Power BI reports via a web browser requires a Power BI Report Server. Power BI Desktop version should be optimized for Report Server.

(3) Power BI Report Server is included with the Power BI Premium license and with SQL Server Enterprise Edition with Software Assurance support.

 

Power BI Report Server system requirements - https://docs.microsoft.com/en-us/power-bi/report-server/system-requirements

 Power BI Desktop system requirements - https://docs.microsoft.com/en-us/power-bi/desktop-get-the-desktop#minimum-requirements 

Download Power BI Desktop optimized for Report Server - https://www.microsoft.com/en-us/download/details.aspx?id=57271