Comparison of OLAP servers

From testwiki
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 Template:Usurped
Kyvos Kyvos Insights [12] 2024.3 Proprietary Pricing-
Microsoft Analysis Services Microsoft [13] 2022 Proprietary [3]
Mondrian OLAP server Pentaho [14] 3.7 EPL free
Oracle Database OLAP Option Oracle [15] 11g R2 Proprietary [4]
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 Template:Yes Template:Yes Template:Yes Template:Yes
Apache Druid Template:Yes Template:Yes Template:Yes Template:Yes
Apache Kylin Template:Yes Template:No Template:No Template:Yes
Apache Pinot Template:Yes Template:Yes Template:Yes Template:Yes
ClickHouse Template:Yes Template:Yes Template:Yes Template:Yes
Essbase Template:Yes Template:No Template:No
IBM Cognos BI Template:Yes Template:Yes Template:Yes
IBM Cognos TM1 Template:Yes Template:No Template:No Template:Yes
icCube Template:Yes Template:No Template:No Template:Yes
Jedox OLAP Server Template:Yes Template:No Template:No Template:No
Kyvos Template:Yes Template:Yes Template:Yes Template:Yes
Microsoft Analysis Services Template:Yes Template:Yes Template:Yes Template:Yes
MicroStrategy Intelligence Server Template:Yes Template:Yes Template:Yes Template:Yes
Mondrian OLAP server Template:No Template:Yes Template:No
Oracle Database OLAP Option Template:Yes Template:No Template:No
SAP NetWeaver BW Template:Yes Template:Yes Template:No
SAS OLAP Server Template:Yes Template:Yes Template:Yes
StarRocks Template:Yes Template:Yes Template:Yes Template: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 Template:No Template:No Template:No Template:No Template:Yes[20] Template:Yes Template:No Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI Template:Yes Template:Yes
Apache Druid Template:No Template:No Template:No Template:No Template:Yes Druid SQL Template:No Superset, Pivot, Redash Template:Yes Template:Yes
Apache Kylin Template:Yes Template:No Template:Yes Template:No Template:Yes Template:Yes Superset, Zeppelin, Tableau, Qlik, Redash, Microsoft Excel Template:Yes Template:Yes
Apache Pinot Template:No Template:No Template:No Template:No Template:Yes Template:Yes Template:No Superset, Pivot, Redash Template:Yes Template:Yes
ClickHouse Template:No Template:No Template:No Template:No Template:Yes[21] Template:Yes Template:No Superset, Zeppelin, Tableau, Qlik, Redash, DataLens[22] Template:Yes Template:Yes
Essbase Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:No Template:Yes SmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos Template:Dunno Template:Yes
IBM Cognos TM1 Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:No Template:Yes TM1 Web/TM1 Contributor, IBM Cognos Insight, IBM Performance Modeler, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for Excel Template:Yes Template:Yes
icCube Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Maybe Template:Yes Template:Yes Template:Yes Template:Yes
Jedox OLAP Server Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:No Template:Yes Template:Yes Template:No Template:Yes
Kyvos Template:Yes Template:Yes Template:Yes Template:No Template:Yes Template:Yes Template:No Kyvos Viz, Microsoft Excel, Qlik, Tableau, Power BI, MicroStrategy, IBM Cognos, Business Objects, XLCubed, Looker, Altryx, and more Template:Yes Template:Yes
Microsoft Analysis Services Template:Yes Template:Yes Template:Yes Template:Yes[23] Template:Yes[24] Template:Yes[25] Template:Yes Template:Yes Template:No Template:No
MicroStrategy Intelligence Server Template:Yes Template:No Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Mondrian OLAP server Template:Yes Template:Yes[26] Template:Yes Template:Yes Template:Yes[27] Template:No Template:Yes Template:Yes[28] Template:Dunno Template:Dunno
Oracle Database OLAP Option Template:No Template:Yes[29] Template:Yes[29] Template:Yes Template:Yes Template:Yes[30] Template:No Template:Dunno Template:Dunno Template:Dunno
SAP NetWeaver BW Template:Yes Template:Yes Template:Yes Template:No Template:Yes Template:No Template:Yes Template:Dunno Template:Dunno Template:Dunno
SAS OLAP Server Template:Yes Template:Yes Template:Yes Template:No Template:No Template:No Template:Yes Template:Yes Template:Dunno Template:Dunno
StarRocks Template:No Template:No Template:No Template:No Template:Yes[31] Template:Yes Template:No Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI Template:Yes Template: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 Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Apache Druid Template:Yes Template:Dunno Template:Yes Template:Yes Template:Yes
Apache Kylin Template:Yes[32] Template:No Template:Yes Template:Yes Template:Yes
Apache Pinot Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
ClickHouse Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Essbase Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
IBM Cognos BI Template:Yes Template:No Template:Yes Template:Yes Template:Dunno
IBM Cognos TM1 Template:Yes Template:Yes Template:Yes Template:Dunno Template:Dunno
icCube Template:Yes[33] Template:No Template:Yes[34] Template:Dunno Template:Dunno
Jedox OLAP Server Template:Yes Template:Yes Template:Yes Template:Dunno Template:Dunno
Kyvos Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Microsoft Analysis Services Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
MicroStrategy Intelligence Server Template:Dunno Template:Yes[35] Template:Yes Template:Yes Template:Yes
Mondrian OLAP server Template:Yes Template:Yes2 Template:Yes Template:Dunno Template:Dunno
Oracle Database OLAP Option Template:Dunno Template:Yes Template:Yes Template:No Template:Dunno
SAP NetWeaver BW Template:Dunno Template:Yes Template:Yes Template:Dunno Template:Dunno
SAS OLAP Server Template:Dunno Template:Yes Template:Yes Template:Dunno Template:Dunno
StarRocks Template:Yes Template:Yes Template:Yes Template:Yes Template: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 Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:No
Apache Druid Template:Yes Template:Yes Template:Yes Template:Dunno Template:No Template:Yes Template:Dunno Template:Yes Template:Yes
Apache Kylin Template:No Template:No Template:Yes Template:No Template:Yes Template:Yes Template:No Template:Yes Template:Yes
Apache Pinot Template:Yes Template:Yes Template:Dunno Template:Dunno Template:No Template:Yes Template:Dunno Template:Yes Template:Yes
ClickHouse Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:No
Essbase Template:Yes Template:Dunno Template:Dunno Template:Dunno Template:Yes Template:Yes Template:Yes Template:Yes Template:Dunno
IBM Cognos BI Template:Yes Template:Yes Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Yes Template:Yes Template:Dunno
IBM Cognos TM1 Template:Yes Template:Yes Template:Yes Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno
icCube Template:Yes[36] Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Dunno
Jedox OLAP Server Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Dunno
Kyvos Template:Yes Template:Yes Template:Yes Template:No Template:Yes Template:Yes Template:Yes Template:Yes Template:No
Microsoft Analysis Services Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
MicroStrategy Intelligence Server Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Mondrian OLAP server Template:Yes[37] Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno
Oracle Database OLAP Option Template:Yes Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno
SAP NetWeaver BW Template:Yes Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno
SAS OLAP Server Template:Yes Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno Template:Dunno
StarRocks Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template: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[38] 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[39] 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[40] 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 Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Apache Druid Template:Yes Template:Yes Template:Yes Template:No Template:Yes Template:No
Apache Kylin Template:Yes Template:Yes Template:Yes Template:No Template:No Template:Dunno
Apache Pinot Template:Yes Template:Yes Template:Dunno Template:No Template:No Template:No
ClickHouse Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Essbase Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:No
IBM Cognos TM1 Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
icCube Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Jedox OLAP Server Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Dunno
Kyvos Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Microsoft Analysis Services Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
MicroStrategy Intelligence Server Template:Yes Template:Yes Template:Dunno Template:Yes Template:Yes Template:Yes
Oracle Database OLAP Option Template:Yes Template:Yes Template:Dunno Template:Yes Template:Yes Template:No
SAS OLAP Server[41] Template:Yes Template:Yes[42] Template:Dunno Template:Yes Template:Yes Template: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 Template:No Template:Yes Template:Yes Template:No Template:No
Apache Druid Template:No Template:Yes Template:Yes
Apache Kylin Template:No Template:Yes Template:Yes Template:No Template:No
Apache Pinot Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
ClickHouse Template:No Template:Yes Template:Yes Template:No Template:No
Essbase Template:Yes Template:Yes Template:Yes Template:No Template:Yes
IBM Cognos TM1 Template:Yes Template:Yes Template:Yes Template:No Template:Yes
icCube Template:Yes Template:Yes Template:Yes Template:Yes Template:Yes
Jedox OLAP Server Template:Yes Template:Yes Template:Yes Template:No
Kyvos Template:No Template:Yes Template:Yes Template:No Template:No
Microsoft Analysis Services Template:Yes Template:No Template:No Template:No
MicroStrategy Intelligence Server Template:Yes Template:Yes Template:Yes Template:No Template:Yes
Mondrian OLAP server Template:Yes Template:Yes Template:Yes Template:Yes
Oracle Database OLAP Option Template:Yes Template:Yes Template:Yes Template:Yes
SAP NetWeaver BW Template:Yes Template:Yes Template:Yes Template:Yes
SAS OLAP Server Template:Yes Template:Yes Template:Yes Template:Yes
StarRocks Template:No Template:Yes Template:Yes Template:No Template: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 Template:Yes
Apache Druid Druid – Github Issues Template:Yes
Apache Kylin Jira Apache Kylin Roadmap Template:Yes
Apache Pinot Apache Pinot – Github Issues Template:Yes
ClickHouse ClickHouse – Github Issues ClickHouse Roadmap Template:Yes
Essbase myOracle Support Template:Usurped Template:No
IBM Cognos TM1 IBM Service Request Template:No
icCube Stackoverflow Template:No
Jedox OLAP Server Template:Usurped Available upon request Template:Yes
Kyvos Zendesk Available upon request Template:No
Microsoft Analysis Services Connect - Template:No
MicroStrategy Intelligence Server MicroStrategy Resource Center - Template:No
Mondrian OLAP server Jira [5] Template:Yes
Oracle Database OLAP Option myOracle Support Template:No
SAP NetWeaver BW OSS Template:Usurped Template:No
SAS OLAP Server Support Template:No
StarRocks StarRocks– Github Issues StarRocks Roadmap Template:Yes

See also

References

Template:Reflist

Template:Data warehouse

  1. ↑ Template:Cite web
  2. ↑ Template:Cite web
  3. ↑ Template:Cite web
  4. ↑ Template:Cite web
  5. ↑ Template:Cite web
  6. ↑ Template:Cite web
  7. ↑ Template:Cite web
  8. ↑ Template:Cite web
  9. ↑ Template:Cite web
  10. ↑ Template:Cite web
  11. ↑ Template:Cite web
  12. ↑ Template:Cite web
  13. ↑ Template:Cite web
  14. ↑ Template:Cite web
  15. ↑ Template:Cite web
  16. ↑ Template:Cite web
  17. ↑ Template:Cite web
  18. ↑ Template:Cite web
  19. ↑ Template:Cite web
  20. ↑ Template:Cite web
  21. ↑ Template:Cite web
  22. ↑ Template:Cite web
  23. ↑ Template:Cite web
  24. ↑ Template:Cite web
  25. ↑ Template:Cite web
  26. ↑ Template:Cite web
  27. ↑ Template:Cite web
  28. ↑ Template:Cite web
  29. ↑ 29.0 29.1 Template:Cite web
  30. ↑ Template:Cite web
  31. ↑ Template:Cite web
  32. ↑ Template:Cite web
  33. ↑ Template:Cite web
  34. ↑ Template:Cite web
  35. ↑ Template:Cite web
  36. ↑ Template:Cite web
  37. ↑ Template:Cite web
  38. ↑ Template:Cite web
  39. ↑ Template:Cite web
  40. ↑ Template:Cite web
  41. ↑ Template:Cite web
  42. ↑ Template:Cite web
Retrieved from "https://en.wiki.beta.math.wmflabs.org/w/index.php?title=Comparison_of_OLAP_servers&oldid=30384"