Comparison of OLAP servers
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.5 | Proprietary | [1] |
IBM Cognos TM1 | IBM | [9] | 10.2.2 FP7 | Proprietary | - |
icCube | icCube | [10] | 8.4.6 | Proprietary | community / [2] |
Jedox OLAP Server | Jedox | [11] | 2019.3 | Proprietary | [3] |
Kyvos | Kyvos Insights | [12] | 2022.3 | Proprietary | - |
Microsoft Analysis Services | Microsoft | [13] | 2016 | 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.
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 | In the reporting | 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 Insights, 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.
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 | Unrestricted[a] | 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 | Unrestricted[a] | Unrestricted | Unrestricted[a] | 256 | Unrestricted[a] | 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 | (32 bits) | (32 bits) | 250 | ||||
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 | Unrestricted[a] | Unrestricted[a] | Unrestricted[a] | ? | Unrestricted[a] | Unrestricted[a] | Unrestricted[a] |
SAS OLAP Server[42] | Unrestricted[a] | 1024 | 128 | ? | 128 | 19 | 4,294,967,296 |
StarRocks | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
- ^ a b c d e f g h i j k Please update as 'unrestricted', is just not possible
Security
OLAP server | Authentication | Network encryption | On-the-Fly[a] | 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 |
- ^ 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 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] | Closed |
IBM Cognos TM1 | IBM Service Request | Closed | |
icCube | Stackoverflow | Closed | |
Jedox OLAP Server | Mantis | 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] | Closed |
SAS OLAP Server | Support | Closed | |
StarRocks | StarRocks– Github Issues | StarRocks Roadmap | Open |
See also
- Cubes (light-weight open-source OLAP server)
- ClickHouse
- Apache Pinot
- Apache Druid
- Apache Doris
- icCube
- Oracle Essbase
- Oracle Retail Predictive Application Server (RPAS), a retail specific MOLAP/OLAP server using Berkeley DB for persistence
- Palo (OLAP database)
- StarRocks
References
- ^ "Apache Doris". Github. Retrieved 6 April 2023.
- ^ druid. "Druid | Interactive Analytics at Scale". druid.io. Retrieved 2017-09-01.
- ^ "Latest Release".
- ^ Kylin, Apache. "Apache Kylin | Home". kylin.apache.org. Retrieved 2018-11-08.
- ^ Pinot, Apache. "Apache Pinot | Home". pinot.apache.org. Retrieved 2021-07-14.
- ^ "Atoti".
- ^ "ClickHouse".
- ^ "Oracle Essbase".
- ^ "Cognos Business Intelligence and Financial Performance Management". 9 November 2020.
- ^ "icCube OLAP Server".
- ^ "Jedox".
- ^ "Kyvos".
- ^ "Microsoft SQL Server 2008 Analysis Services". Microsoft.
- ^ "Pentaho Analysis Services: Mondrian Project".
- ^ "Oracle OLAP Documentation".
- ^ "Components & Tools".
- ^ "SAS OLAP Server".
- ^ "StarRocks | A High-Performance Analytical Database". www.starrocks.io. Retrieved 2023-10-24.
- ^ "SSAS Entity Framework Provider".
- ^ "Apache Doris UDF". Retrieved 6 April 2023.
- ^ "ClickHouse SQL Reference". Yandex.
- ^ "ClickHouse Visual Interfaces". Yandex.
- ^ "icCube Java integration documentation". icCube.
- ^ "icCube R language integration documentation". icCube.
- ^ "SQL Server 2008 Books Online (October 2009)Defining Stored Procedures". MSDN. 9 December 2022.
- ^ "SQL Server 2008 Books Online (October 2009)Using Stored Procedures". MSDN. 28 February 2023.
- ^ "How to perform a SQL Server distributed query with OLAP Server". MSDN. 7 March 2023.
- ^ "Pentaho and Simba Technologies Partner to Bring World's Most Popular Open Source OLAP Project to Microsoft Excel Users".
- ^ "How to Define a Mondrian Schema". Pentaho.
- ^ "Pentaho Business Analytics Visualization".
- ^ a b "Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP".
- ^ "Querying Oracle OLAP Cubes: Fast Answers to Tough Questions Using Simple SQL".
- ^ "StarRocks UDF". Retrieved 6 April 2023.
- ^ "Real-time OLAP".
- ^ "icCube Real Time walkthrough".
- ^ "icCube Partitioning".
- ^ "Common Extensions of the MicroStrategy Platform". Archived from the original on 2010-11-28. Retrieved 2010-11-10.
- ^ "icCube Aggregatin types".
- ^ "Support for Non-Additive and Semi-Additive Measures".
- ^ "Essbase Server Limits". Oracle. Archived from the original on 2015-06-26. Retrieved 2015-06-25.
- ^ "SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data)". Microsoft. 9 December 2022.
- ^ "SAS OLAP Cube Size Specifications".
- ^ "MicroStrategy Intelligence Server Features". Archived from the original on 2012-07-10. Retrieved 2010-11-10.
- ^ "SAS OLAP Security Totals and Permission Conditions".
- ^ "How to Change Over-the-Wire Encryption Settings for SAS Servers".
- v
- t
- e
Creating a data warehouse | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Using a data warehouse | |||||||
---|---|---|---|---|---|---|---|
|
Related | |||||
---|---|---|---|---|---|
|