Comparison of OLAP servers
From Wikipedia, the free encyclopedia
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.8  |
Proprietary | |
| IBM Cognos TM1 | IBM | [9] | 10.2.2 FP7 | Proprietary | - |
| icCube | icCube SARL | [10] | 9.0.1 | Proprietary | community / |
| Jedox OLAP Server | Jedox | [11] | 2019.3 | Proprietary | |
| Microsoft Analysis Services | Microsoft | [12] | 2022 | Proprietary | |
| Mondrian OLAP server | Pentaho | [13] | 3.7 | EPL | free |
| Oracle Database OLAP Option | Oracle | [14] | 11g R2 | Proprietary | |
| SAP NetWeaver BW | SAP | [15] | 7.30 | Proprietary | - |
| SAS OLAP Server | SAS Institute | [16] | 9.4 | Proprietary | - |
| StarRocks | Linux Foundation | [17] | 3.5 | 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 |
| 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[18] | Visualization | JSON | REST API |
|---|---|---|---|---|---|---|---|---|---|---|
| Apache Doris | No | No | No | No | Yes[19] | 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[20] | Yes | No | Superset, Zeppelin, Tableau, Qlik, Redash, DataLens[21] | 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,[22] R[23] | 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 |
| Microsoft Analysis Services | Yes | Yes | Yes | .NET[24] | Yes[25] | Yes[26] | 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[27] | Yes | Yes | Yes[28] | No | Yes | Yes[29] | ? | ? |
| Oracle Database OLAP Option | No | Yes[30] | Yes[30] | Java, PL/SQL, OLAP DML | Yes | Yes[31] | 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[32] | 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.
| 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[33] | 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[34] | No | Yes[35] | ? | ? |
| Jedox OLAP Server | Yes | Yes | Yes | ? | ? |
| Microsoft Analysis Services | Yes | Yes | Yes | Yes | Yes |
| MicroStrategy Intelligence Server | ? | Yes[36] | 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 |
| 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[37] | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? |
| Jedox OLAP Server | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ? |
| 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[38] | ? | ? | ? | ? | ? | ? | ? | ? |
| 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
More information 
, ...
, ...| 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[39] | 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 | ||||
| Microsoft Analysis Services[40] | 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[41] | Unrestricted[a] | 1024 | 128 | ? | 128 | 19 | 4,294,967,296 |
| StarRocks | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
- 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 | ? |
| 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[42] | ? | Yes | Yes | Yes |
| Oracle Database OLAP Option | Oracle Database authentication | SSL | ? | Yes | Yes | No |
| SAS OLAP Server[43] | Host authentication, SAS token authentication, LDAP, Microsoft Active Directory | Yes[44] | ? | 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 | |
| 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 | Closed | |
| IBM Cognos TM1 | IBM Service Request | Closed | |
| icCube | Stackoverflow | Closed | |
| Jedox OLAP Server | Mantis | Available upon request | Open |
| 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 | 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
- Oracle Essbase
- Oracle Retail Predictive Application Server (RPAS), a retail specific MOLAP/OLAP server using Berkeley DB for persistence
- Palo (OLAP database)
- StarRocks