Comparison of OLAP servers

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search

Template:Short description

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.

General information

OLAP server Company Website Latest 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 [1]
IBM Cognos TM1 IBM [9] 10.2.2 FP7 Proprietary -
icCube icCube SARL [10] 8.4.14 Proprietary community / [2]
Jedox OLAP Server Jedox [11] 2019.3 Proprietary [3]Script error: No such module "Category handler".[<span title="Script error: No such module "string".">usurped]Script error: No such module "Check for unknown parameters".
Kyvos Kyvos Insights [12] 2024.3 Proprietary Pricing-
Microsoft Analysis Services Microsoft [13] 2022 Proprietary [4]
Mondrian OLAP server Pentaho [14] 3.7 EPL free
Oracle Database OLAP Option Oracle [15] 11g R2 Proprietary [5]
SAP NetWeaver BW SAP [16] 7.30 Proprietary -
SAS OLAP Server SAS Institute [17] 9.4 Proprietary -
StarRocks Linux Foundation [18] 3.1 Apache 2.0 free

Data storage modes

OLAP server MOLAP ROLAP HOLAP Offline
Apache Doris Yes Yes Yes Yes
Apache Druid Yes Yes Yes Yes
Apache Kylin Yes No No Yes
Apache Pinot Yes Yes Yes Yes
ClickHouse Yes Yes Yes Yes
Essbase Yes No No
IBM Cognos BI Yes Yes Yes
IBM Cognos TM1 Yes No No Cognos Insight Distributed mode
icCube Yes No No Yes
Jedox OLAP Server Yes No No No
Kyvos Yes Yes Yes Yes
Microsoft Analysis Services Yes Yes Yes Local cubes,
PowerPivot for Excel,
Power BI Desktop
MicroStrategy Intelligence Server Yes Yes Yes MicroStrategy Office,
Dynamic Dashboards
Mondrian OLAP server No Yes No
Oracle Database OLAP Option Yes No No
SAP NetWeaver BW Yes Yes No
SAS OLAP Server Yes Yes Yes
StarRocks Yes Yes Yes Yes

APIs and query languages

APIs and query languages OLAP servers support. Template:Sort-under

OLAP server XML for Analysis OLE DB for OLAP MDX Stored procedures Custom functions SQL LINQ[19] Visualization JSON REST API
Apache Doris No No No No Yes[20] Yes No Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI Yes Yes
Apache Druid No No No No Yes Druid SQL No Superset, Pivot, Redash Yes Yes
Apache Kylin Yes No Yes No Yes Yes Superset, Zeppelin, Tableau, Qlik, Redash, Microsoft Excel Yes Yes
Apache Pinot No No No No Yes Yes No Superset, Pivot, Redash Yes Yes
ClickHouse No No No No Yes[21] Yes No Superset, Zeppelin, Tableau, Qlik, Redash, DataLens[22] Yes Yes
Essbase Yes Yes Yes Yes Yes No Yes SmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos ? Yes
IBM Cognos TM1 Yes Yes Yes Yes Yes No Yes TM1 Web/TM1 Contributor, IBM Cognos Insight, IBM Performance Modeler, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for Excel Yes Yes
icCube Yes Yes Yes Java,[23] R[24] Yes Template:Maybe Yes icCube reporting and all XMLA compliant visualization tools like Excel, etc Yes Yes
Jedox OLAP Server Yes Yes Yes Cube Rules, SVS Triggers Yes No Yes Microsoft Excel, Qlik, Tableau, Jedox Web, Power BI No Yes
Kyvos Yes Yes Yes No Yes Yes No Kyvos Viz, Microsoft Excel, Qlik, Tableau, Power BI, MicroStrategy, IBM Cognos, Business Objects, XLCubed, Looker, Altryx, and more Yes Yes
Microsoft Analysis Services Yes Yes Yes .NET[25] Yes[26] Yes[27] Yes Microsoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization tools No No
MicroStrategy Intelligence Server Yes No Yes Yes Yes Yes Yes Dossier, Dashboard, Reports Yes Yes
Mondrian OLAP server Yes Yes[28] Yes Yes Yes[29] No Yes Yes[30] ? ?
Oracle Database OLAP Option No Yes[31] Yes[31] Java, PL/SQL, OLAP DML Yes Yes[32] No ? ? ?
SAP NetWeaver BW Yes Yes Yes No Yes No Yes ? ? ?
SAS OLAP Server Yes Yes Yes No No No Yes Web Report Studio ? ?
StarRocks No No No No Yes[33] Yes No Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI Yes Yes

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.

Template:Sort-under

Data processing, management and performance related features
OLAP server Real Time Write-back Partitioning Usage Based Optimizations Load Balancing and Clustering
Apache Doris Yes Yes Yes Yes Yes
Apache Druid Yes ? Yes Yes Yes
Apache Kylin Yes[34] No Yes Yes Yes
Apache Pinot Yes Yes Yes Yes Yes
ClickHouse Yes Yes Yes Yes Yes
Essbase Yes Yes Yes Yes Yes
IBM Cognos BI Yes No Yes Yes ?
IBM Cognos TM1 Yes Yes Yes ? ?
icCube Yes[35] No Yes[36] ? ?
Jedox OLAP Server Yes Yes Yes ? ?
Kyvos Yes Yes Yes Yes Yes
Microsoft Analysis Services Yes Yes Yes Yes Yes
MicroStrategy Intelligence Server ? Yes[37] Yes Yes Yes
Mondrian OLAP server Yes Planned Yes ? ?
Oracle Database OLAP Option ? Yes Yes No ?
SAP NetWeaver BW ? Yes Yes ? ?
SAS OLAP Server ? Yes Yes ? ?
StarRocks Yes Yes Yes Yes Yes
Data modeling features
OLAP server Semi-additive measures Many-to-Many Multi-Cube Model Perspectives KPI Multilingual Named Sets Multi-attribute Hierarchies Actions
Apache Doris Yes Yes Yes Yes Yes Yes Yes Yes No
Apache Druid Yes Yes Yes ? No Yes ? Yes Yes
Apache Kylin No No Yes No Yes Yes No Yes Yes
Apache Pinot Yes Yes ? ? No Yes ? Yes Yes
ClickHouse Yes Yes Yes Yes Yes Yes Yes Yes No
Essbase Yes ? ? ? Yes Yes Yes Yes ?
IBM Cognos BI Yes Yes ? ? ? ? Yes Yes ?
IBM Cognos TM1 Yes Yes Yes ? ? ? ? ? ?
icCube Yes[38] Yes Yes Yes Yes Yes Yes Yes ?
Jedox OLAP Server Yes Yes Yes Yes Yes Yes Yes Yes ?
Kyvos Yes Yes Yes No Yes Yes Yes Yes No
Microsoft Analysis Services Yes Yes Yes Yes Yes Yes Yes Yes Yes
MicroStrategy Intelligence Server Yes Yes Yes Yes Yes Yes Yes Yes Yes
Mondrian OLAP server Yes[39] ? ? ? ? ? ? ? ?
Oracle Database OLAP Option Yes ? ? ? ? ? ? ? ?
SAP NetWeaver BW Yes ? ? ? ? ? ? ? ?
SAS OLAP Server Yes ? ? ? ? ? ? ? ?
StarRocks Yes Yes Yes Yes Yes Yes Yes Yes No

System limits

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

Unrestricted (In-memory)

MicroStrategy Intelligence Server UnrestrictedTemplate:Efn UnrestrictedTemplate:Efn UnrestrictedTemplate:Efn ? UnrestrictedTemplate:Efn UnrestrictedTemplate:Efn UnrestrictedTemplate:Efn
SAS OLAP Server[42] UnrestrictedTemplate:Efn 1024 128 ? 128 19 4,294,967,296
StarRocks Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted

Template:Notelist

Security

Template:Sort under

OLAP server Authentication Network encryption On-the-FlyTemplate:Efn Data access
Cell security Dimension security Visual totals
Apache Doris Built-in, LDAP, Kerberos SSL Yes Yes Yes Yes
Apache Druid Druid Database authentication SSL Yes No Yes No
Apache Kylin LDAP, SAML, Kerboros, Microsoft Active Directory SSL Yes No No ?
Apache Pinot HTTP basic authentication SSL ? No No No
ClickHouse Built-in, LDAP, Microsoft Active Directory, Kerberos SSL Yes Yes Yes Yes
Essbase Essbase authentication, LDAP authentication, Microsoft Active Directory SSL Yes Yes Yes No
IBM Cognos TM1 Builtin, LDAP, Microsoft Active Directory, NTLM, IBM Cognos BI authentication SSL Yes Yes Yes Yes
icCube HTTP Basic/Form Authentication, Windows SSO (NTLM, Kerberos), Plugin Based for Embedded Usage SSL Yes Yes Yes Yes
Jedox OLAP Server Jedox authentication, LDAP, Microsoft Active Directory SSL Yes Yes Yes ?
Kyvos Built-in, LDAP, Microsoft Active Directory, SAML, Windows SSO (NTLM, Kerberos) SSL Yes Yes Yes Yes
Microsoft Analysis Services NTLM, Kerberos SSL and SSPI Yes Yes Yes Yes
MicroStrategy Intelligence Server Host authentication, database authentication, LDAP,
Microsoft Active Directory, NTLM, SiteMinder, Tivoli, SAP, Kerberos 		SSL, AES[43] ? Yes Yes Yes
Oracle Database OLAP Option Oracle Database authentication SSL ? Yes Yes No
SAS OLAP Server[44] Host authentication, SAS token authentication, LDAP, Microsoft Active Directory Yes[45] ? Yes Yes Yes

Template:Notelist

Operating systems

The OLAP servers can run on the following operating systems:

OLAP server Windows Linux UNIX z/OS AIX
Apache Doris No Yes Yes No No
Apache Druid No Yes Yes
Apache Kylin No Yes Yes No No
Apache Pinot Yes Yes Yes Yes Yes
ClickHouse No Yes Yes No No
Essbase Yes Yes Yes No Yes
IBM Cognos TM1 Yes Yes Yes No Yes
icCube Yes Yes Yes Yes Yes
Jedox OLAP Server Yes Yes Yes No
Kyvos No Yes Yes No No
Microsoft Analysis Services Yes No No No
MicroStrategy Intelligence Server Yes Yes Yes No Yes
Mondrian OLAP server Yes Yes Yes Yes
Oracle Database OLAP Option Yes Yes Yes Yes
SAP NetWeaver BW Yes Yes Yes Yes
SAS OLAP Server Yes Yes Yes Yes
StarRocks No Yes Yes No No

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

Support information

OLAP server Issue Tracking System Roadmap Source 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 [6]Script error: No such module "Category handler".[<span title="Script error: No such module "string".">usurped]Script error: No such module "Check for unknown parameters". Closed
IBM Cognos TM1 IBM Service Request Closed
icCube Stackoverflow Closed
Jedox OLAP Server MantisScript error: No such module "Category handler".[<span title="Script error: No such module "string".">usurped]Script error: No such module "Check for unknown parameters". Available upon request Open
Kyvos Zendesk Available upon request Closed
Microsoft Analysis Services Connect - Closed
MicroStrategy Intelligence Server MicroStrategy Resource Center - Closed
Mondrian OLAP server Jira [7] Open
Oracle Database OLAP Option myOracle Support Closed
SAP NetWeaver BW OSS [8]Script error: No such module "Category handler".[<span title="Script error: No such module "string".">usurped]Script error: No such module "Check for unknown parameters". Closed
SAS OLAP Server Support Closed
StarRocks StarRocks– Github Issues StarRocks Roadmap Open

See also

References

<templatestyles src="Reflist/styles.css" />

  1. ↑ Script error: No such module "citation/CS1".
  2. ↑ Script error: No such module "citation/CS1".
  3. ↑ Script error: No such module "citation/CS1".
  4. ↑ Script error: No such module "citation/CS1".
  5. ↑ Script error: No such module "citation/CS1".
  6. ↑ Script error: No such module "citation/CS1".
  7. ↑ Script error: No such module "citation/CS1".
  8. ↑ Script error: No such module "citation/CS1".
  9. ↑ Script error: No such module "citation/CS1".
  10. ↑ Script error: No such module "citation/CS1".
  11. ↑ Script error: No such module "citation/CS1".
  12. ↑ Script error: No such module "citation/CS1".
  13. ↑ Script error: No such module "citation/CS1".
  14. ↑ Script error: No such module "citation/CS1".
  15. ↑ Script error: No such module "citation/CS1".
  16. ↑ Script error: No such module "citation/CS1".
  17. ↑ Script error: No such module "citation/CS1".
  18. ↑ Script error: No such module "citation/CS1".
  19. ↑ Script error: No such module "citation/CS1".
  20. ↑ Script error: No such module "citation/CS1".
  21. ↑ Script error: No such module "citation/CS1".
  22. ↑ Script error: No such module "citation/CS1".
  23. ↑ Script error: No such module "citation/CS1".
  24. ↑ Script error: No such module "citation/CS1".
  25. ↑ Script error: No such module "citation/CS1".
  26. ↑ Script error: No such module "citation/CS1".
  27. ↑ Script error: No such module "citation/CS1".
  28. ↑ Script error: No such module "citation/CS1".
  29. ↑ Script error: No such module "citation/CS1".
  30. ↑ Script error: No such module "citation/CS1".
  31. ↑ a b Script error: No such module "citation/CS1".
  32. ↑ Script error: No such module "citation/CS1".
  33. ↑ Script error: No such module "citation/CS1".
  34. ↑ Script error: No such module "citation/CS1".
  35. ↑ Script error: No such module "citation/CS1".
  36. ↑ Script error: No such module "citation/CS1".
  37. ↑ Script error: No such module "citation/CS1".
  38. ↑ Script error: No such module "citation/CS1".
  39. ↑ Script error: No such module "citation/CS1".
  40. ↑ Script error: No such module "citation/CS1".
  41. ↑ Script error: No such module "citation/CS1".
  42. ↑ Script error: No such module "citation/CS1".
  43. ↑ Script error: No such module "citation/CS1".
  44. ↑ Script error: No such module "citation/CS1".
  45. ↑ Script error: No such module "citation/CS1".

Script error: No such module "Check for unknown parameters".

Template:Data warehouse

Retrieved from "http://debianws.lexgopc.com/wiki143/index.php?title=Comparison_of_OLAP_servers&oldid=8859874"