Comparison of OLAP servers

Last updated

The following tables compare general and technical information for a number of online analytical processing (OLAP) servers. Please see the individual products articles for further information.

Contents

General information

OLAP serverCompanyWebsiteLatest stable version Software license License pricing
Apache Doris Apache Software Foundation [1] 1.2.3 Apache 2.0 free
Apache Druid Apache Software Foundation [2] 29.0.0 [3] Apache 2.0 free
Apache Kylin Apache Software Foundation [4] 3.1.0 Apache 2.0 free
Apache Pinot Apache Software Foundation [5] 1.1.0 Apache 2.0 free
Atoti ActiveViam [6] 6.0.5 Proprietary community
ClickHouse Clickhouse Inc [7] 24.5 Apache 2.0 free
Essbase Oracle [8] 21.6 Proprietary
IBM Cognos TM1 IBM [9] 10.2.2 FP7 Proprietary -
icCube icCube SARL [10] 8.4.14 Proprietary community /
Jedox OLAP Server Jedox [11] 2019.3 Proprietary [ usurped ]
Kyvos Kyvos Insights [12] 2024.3 Proprietary Pricing-
Microsoft Analysis Services Microsoft [13] 2022 Proprietary
Mondrian OLAP server Pentaho [14] 3.7 EPL free
Oracle Database OLAP Option Oracle [15] 11g R2 Proprietary
SAP NetWeaver BW SAP [16] 7.30 Proprietary -
SAS OLAP Server SAS Institute [17] 9.4 Proprietary -
StarRocks Linux Foundation [18] 3.5 Apache 2.0 free

Data storage modes

OLAP server MOLAP ROLAP HOLAP Offline
Apache DorisYesYesYesYes
Apache Druid YesYesYesYes
Apache Kylin YesNoNoYes
Apache Pinot YesYesYesYes
ClickHouse YesYesYesYes
Essbase YesNoNo
IBM Cognos BI YesYesYes
IBM Cognos TM1 YesNoNo Cognos Insight Distributed mode
icCubeYesNoNoYes
Jedox OLAP Server YesNoNoNo
Kyvos YesYesYesYes
Microsoft Analysis Services YesYesYesLocal cubes,
PowerPivot for Excel,
Power BI Desktop
MicroStrategy Intelligence Server YesYesYes MicroStrategy Office,
Dynamic Dashboards
Mondrian OLAP server NoYesNo
Oracle Database OLAP Option YesNoNo
SAP NetWeaver BW YesYesNo
SAS OLAP Server YesYesYes
StarRocksYesYesYesYes

APIs and query languages

APIs and query languages OLAP servers support.

OLAP server XML for Analysis OLE DB for OLAP MDX Stored procedures Custom functions SQL LINQ [19] Visualization JSON REST API
Apache DorisNoNoNoNoYes [20] YesNoSuperset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBIYesYes
Apache Druid NoNoNoNoYesDruid SQLNoSuperset, Pivot, RedashYesYes
Apache Kylin YesNoYesNoYesYesSuperset, Zeppelin, Tableau, Qlik, Redash, Microsoft ExcelYesYes
Apache Pinot NoNoNoNoYesYesNoSuperset, Pivot, RedashYesYes
ClickHouse NoNoNoNoYes [21] YesNoSuperset, Zeppelin, Tableau, Qlik, Redash, DataLens [22] YesYes
Essbase YesYesYesYesYesNoYesSmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos ?Yes
IBM Cognos TM1 YesYesYesYesYesNoYesTM1 Web/TM1 Contributor, IBM Cognos Insight, IBM Performance Modeler, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for ExcelYesYes
icCubeYesYesYes Java, [23] R [24] YesIn the reportingYesicCube reporting and all XMLA compliant visualization tools like Excel, etcYesYes
Jedox OLAP Server YesYesYesCube Rules, SVS TriggersYesNoYesMicrosoft Excel, Qlik, Tableau, Jedox Web, Power BINoYes
Kyvos YesYesYesNoYesYesNoKyvos Viz, Microsoft Excel, Qlik, Tableau, Power BI, MicroStrategy, IBM Cognos, Business Objects, XLCubed, Looker, Altryx, and moreYesYes
Microsoft Analysis Services YesYesYes .NET [25] Yes [26] Yes [27] YesMicrosoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization toolsNoNo
MicroStrategy Intelligence Server YesNoYesYesYesYesYesDossier, Dashboard, ReportsYesYes
Mondrian OLAP server YesYes [28] YesYesYes [29] NoYesYes [30]  ? ?
Oracle Database OLAP Option NoYes [31] Yes [31] Java, PL/SQL, OLAP DML YesYes [32] No ? ? ?
SAP NetWeaver BW YesYesYesNoYesNoYes ? ? ?
SAS OLAP Server YesYesYesNoNoNoYesWeb Report Studio ? ?
StarRocksNoNoNoNoYes [33] YesNoSuperset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBIYesYes

OLAP distinctive features

A list of OLAP features that are not supported by all vendors. All vendors support features such as parent-child, multilevel hierarchy, drilldown.

Data processing, management and performance related features
OLAP serverReal TimeWrite-backPartitioningUsage Based OptimizationsLoad Balancing and Clustering
Apache DorisYesYesYesYesYes
Apache Druid Yes ?YesYesYes
Apache Kylin Yes [34] NoYesYesYes
Apache Pinot YesYesYesYesYes
ClickHouse YesYesYesYesYes
Essbase YesYesYesYesYes
IBM Cognos BI YesNoYesYes ?
IBM Cognos TM1 YesYesYes ? ?
icCubeYes [35] NoYes [36]  ? ?
Jedox OLAP Server YesYesYes ? ?
Kyvos YesYesYesYesYes
Microsoft Analysis Services YesYesYesYesYes
MicroStrategy Intelligence Server  ?Yes [37] YesYesYes
Mondrian OLAP server YesPlannedYes ? ?
Oracle Database OLAP Option  ?YesYesNo ?
SAP NetWeaver BW  ?YesYes ? ?
SAS OLAP Server  ?YesYes ? ?
StarRocksYesYesYesYesYes
Data modeling features
OLAP serverSemi-additive measuresMany-to-ManyMulti-Cube ModelPerspectivesKPIMultilingualNamed SetsMulti-attribute HierarchiesActions
Apache DorisYesYesYesYesYesYesYesYesNo
Apache Druid YesYesYes ?NoYes ?YesYes
Apache Kylin NoNoYesNoYesYesNoYesYes
Apache Pinot YesYes ? ?NoYes ?YesYes
ClickHouse YesYesYesYesYesYesYesYesNo
Essbase Yes ? ? ?YesYesYesYes ?
IBM Cognos BI YesYes ? ? ? ?YesYes ?
IBM Cognos TM1 YesYesYes ? ? ? ? ? ?
icCubeYes [38] YesYesYesYesYesYesYes ?
Jedox OLAP Server YesYesYesYesYesYesYesYes ?
Kyvos YesYesYesNoYesYesYesYesNo
Microsoft Analysis Services YesYesYesYesYesYesYesYesYes
MicroStrategy Intelligence Server YesYesYesYesYesYesYesYesYes
Mondrian OLAP server Yes [39]  ? ? ? ? ? ? ? ?
Oracle Database OLAP Option Yes ? ? ? ? ? ? ? ?
SAP NetWeaver BW Yes ? ? ? ? ? ? ? ?
SAS OLAP Server Yes ? ? ? ? ? ? ? ?
StarRocksYesYesYesYesYesYesYesYesNo

System limits

OLAP server# cubes# measures# dimensions# dimensions in cube# hierarchies in dimension# levels in hierarchy# dimension members
Apache DorisUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Apache Druid Unrestricted [a] UnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Apache Kylin UnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Apache Pinot UnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
ClickHouse UnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Essbase [40] UnrestrictedUnrestrictedUnrestricted255255 ?20,000,000 (ASO), 1,000,000 (BSO)
IBM Cognos TM1 Unrestricted [a] UnrestrictedUnrestricted [a] 256Unrestricted [a] UnrestrictedUnrestricted
icCube2,147,483,6472,147,483,6472,147,483,6472,147,483,6472,147,483,6472,147,483,6472,147,483,647
Jedox OLAP Server (32 bits) (32 bits)250
Kyvos UnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
Microsoft Analysis Services [41] 2,147,483,6472,147,483,6472,147,483,6472,147,483,647 (max. number of dimensions in a database)2,147,483,6472,147,483,6472,147,483,647 (xOLAP)

Unrestricted (In-memory)

MicroStrategy Intelligence Server Unrestricted [a] Unrestricted [a] Unrestricted [a]  ?Unrestricted [a] Unrestricted [a] Unrestricted [a]
SAS OLAP Server [42] Unrestricted [a] 1024128 ?128194,294,967,296
StarRocksUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestrictedUnrestricted
  1. 1 2 3 4 5 6 7 8 9 10 11 Please update as 'unrestricted', is just not possible

Security

OLAP serverAuthenticationNetwork encryptionOn-the-Fly [a] Data access
Cell securityDimension securityVisual totals
Apache DorisBuilt-in, LDAP, Kerberos SSL YesYesYesYes
Apache Druid Druid Database authentication SSL YesNoYesNo
Apache Kylin LDAP, SAML, Kerboros, Microsoft Active DirectorySSLYesNoNo ?
Apache Pinot HTTP basic authentication SSL  ?NoNoNo
ClickHouse Built-in, LDAP, Microsoft Active Directory, Kerberos SSL YesYesYesYes
Essbase Essbase authentication, LDAP authentication, Microsoft Active Directory SSL YesYesYesNo
IBM Cognos TM1 Builtin, LDAP, Microsoft Active Directory, NTLM, IBM Cognos BI authentication SSL YesYesYesYes
icCubeHTTP Basic/Form Authentication, Windows SSO (NTLM, Kerberos), Plugin Based for Embedded Usage SSL YesYesYesYes
Jedox OLAP Server Jedox authentication, LDAP, Microsoft Active Directory SSL YesYesYes ?
Kyvos Built-in, LDAP, Microsoft Active Directory, SAML, Windows SSO (NTLM, Kerberos) SSL YesYesYesYes
Microsoft Analysis Services NTLM, Kerberos SSL and SSPI YesYesYesYes
MicroStrategy Intelligence Server Host authentication, database authentication, LDAP,
Microsoft Active Directory, NTLM, SiteMinder, Tivoli, SAP, Kerberos
SSL, AES [43]  ?YesYesYes
Oracle Database OLAP Option Oracle Database authentication SSL  ?YesYesNo
SAS OLAP Server [44] Host authentication, SAS token authentication, LDAP, Microsoft Active Directory Yes [45]  ?YesYesYes
  1. On-the-Fly : The ability to define authentication dynamically via programmatic interfaces. New users do not require restarting the server or redefining the security.

Operating systems

The OLAP servers can run on the following operating systems:

OLAP serverWindowsLinuxUNIXz/OSAIX
Apache DorisNoYesYesNoNo
Apache Druid NoYesYes
Apache Kylin NoYesYesNoNo
Apache Pinot YesYesYesYesYes
ClickHouse NoYesYesNoNo
Essbase YesYesYesNoYes
IBM Cognos TM1 YesYesYesNoYes
icCubeYesYesYesYesYes
Jedox OLAP Server YesYesYesNo
Kyvos NoYesYesNoNo
Microsoft Analysis Services YesNoNoNo
MicroStrategy Intelligence Server YesYesYesNoYes
Mondrian OLAP server YesYesYesYes
Oracle Database OLAP Option YesYesYesYes
SAP NetWeaver BW YesYesYesYes
SAS OLAP Server YesYesYesYes
StarRocksNoYesYesNoNo

Note (1):The server availability depends on Java Virtual Machine not on the operating system

Support information

OLAP serverIssue Tracking SystemRoadmapSource code
Apache Doris Apache Doris– Github Issues Apache Doris Roadmap Open
Apache Druid Druid – Github Issues Open
Apache Kylin Jira Apache Kylin Roadmap Open
Apache Pinot Apache Pinot – Github Issues Open
ClickHouse ClickHouse – Github Issues ClickHouse Roadmap Open
Essbase myOracle Support [ usurped ]Closed
IBM Cognos TM1 IBM Service Request Closed
icCube Stackoverflow Closed
Jedox OLAP Server Mantis [ usurped ]Available upon requestOpen
Kyvos ZendeskAvailable upon requestClosed
Microsoft Analysis Services Connect -Closed
MicroStrategy Intelligence Server MicroStrategy Resource Center -Closed
Mondrian OLAP server Jira Open
Oracle Database OLAP Option myOracle Support Closed
SAP NetWeaver BW OSS [ usurped ]Closed
SAS OLAP Server Support Closed
StarRocks StarRocks– Github Issues StarRocks Roadmap Open

See also

References

  1. "Apache Doris". Github. Retrieved 6 April 2023.
  2. druid. "Druid | Interactive Analytics at Scale". druid.io. Retrieved 2017-09-01.
  3. "Latest Release".
  4. Kylin, Apache. "Apache Kylin | Home". kylin.apache.org. Retrieved 2018-11-08.
  5. Pinot, Apache. "Apache Pinot | Home". pinot.apache.org. Retrieved 2021-07-14.
  6. "Atoti".
  7. "ClickHouse".
  8. "Oracle Essbase".
  9. "Cognos Business Intelligence and Financial Performance Management". 9 November 2020.
  10. "icCube OLAP Server".
  11. "Jedox".
  12. "Kyvos".
  13. "Microsoft SQL Server 2022 Analysis Services". Microsoft .
  14. "Pentaho Analysis Services: Mondrian Project".
  15. "Oracle OLAP Documentation".
  16. "Components & Tools".
  17. "SAS OLAP Server".
  18. "StarRocks | A High-Performance Analytical Database". www.starrocks.io. Retrieved 2023-10-24.
  19. "SSAS Entity Framework Provider". Archived from the original on September 29, 2011.
  20. "Apache Doris UDF" . Retrieved 6 April 2023.
  21. "ClickHouse SQL Reference". Yandex.
  22. "ClickHouse Visual Interfaces". Yandex.
  23. "icCube Java integration documentation". icCube.
  24. "icCube R language integration documentation". icCube.
  25. "SQL Server 2008 Books Online (October 2009)Defining Stored Procedures". MSDN. 9 December 2022.
  26. "SQL Server 2008 Books Online (October 2009)Using Stored Procedures". MSDN. 28 February 2023.
  27. "How to perform a SQL Server distributed query with OLAP Server". MSDN. 7 March 2023.
  28. "Pentaho and Simba Technologies Partner to Bring World's Most Popular Open Source OLAP Project to Microsoft Excel Users".
  29. "How to Define a Mondrian Schema". Pentaho.
  30. "Pentaho Business Analytics Visualization".
  31. 1 2 "Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP".
  32. "Querying Oracle OLAP Cubes: Fast Answers to Tough Questions Using Simple SQL".
  33. "StarRocks UDF" . Retrieved 6 April 2023.
  34. "Real-time OLAP".
  35. "icCube Real Time walkthrough".
  36. "icCube Partitioning".
  37. "Common Extensions of the MicroStrategy Platform". Archived from the original on 2010-11-28. Retrieved 2010-11-10.
  38. "icCube Aggregatin types".
  39. "Support for Non-Additive and Semi-Additive Measures".
  40. "Essbase Server Limits". Oracle. Archived from the original on 2015-06-26. Retrieved 2015-06-25.
  41. "SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data)". Microsoft. 9 December 2022.
  42. "SAS OLAP Cube Size Specifications".
  43. "MicroStrategy Intelligence Server Features". Archived from the original on 2012-07-10. Retrieved 2010-11-10.
  44. "SAS OLAP Security Totals and Permission Conditions".
  45. "How to Change Over-the-Wire Encryption Settings for SAS Servers".