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 Kylin | Apache Software Foundation | [1] | 2.5.1 | Apache 2.0 | free |
ClickHouse | Yandex | [2] | 20.5.2.7 | Apache 2.0 | free |
Druid | Open source community | [3] | 0.11.0 | Apache 2.0 | free |
Essbase | Oracle | [4] | 19.3 | Proprietary | |
IBM Cognos TM1 | IBM | [5] | 10.2.2 FP7 | Proprietary | - |
icCube | icCube | [6] | 6.8.9 | Proprietary | community/ |
Jedox OLAP Server | Jedox | [7] | 2019.3 | Proprietary | |
Kyvos | Kyvos Insights | [8] | 2020.1 | Proprietary | - |
Microsoft Analysis Services | Microsoft | [9] | 2016 | Proprietary | |
Mondrian OLAP server | Pentaho | [10] | 3.7 | EPL | free |
Oracle Database OLAP Option | Oracle | [11] | 11g R2 | Proprietary | |
SAP NetWeaver BW | SAP | [12] | 7.30 | Proprietary | - |
SAS OLAP Server | SAS Institute | [13] | 9.4 | Proprietary | - |
Data storage modes
OLAP server | MOLAP | ROLAP | HOLAP | Offline |
---|---|---|---|---|
Apache Kylin | Yes | No | No | Yes |
ClickHouse | Yes | Yes | Yes | Yes |
Druid | 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 | Offline Cubes |
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 | No | Yes | No | |
SAP NetWeaver BW | Yes | Yes | No | |
SAS OLAP Server | 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[14] | Visualization | JSON | REST API |
---|---|---|---|---|---|---|---|---|---|---|
Apache Kylin | No | No | No | No | Yes | Yes | Superset, Zeppelin, Tableau, Qlik, Redash | Yes | Yes | |
ClickHouse | No | No | No | No | Yes[15] | Yes | No | Superset, Zeppelin, Tableau, Qlik, Redash, DataLens[16] | Yes | Yes |
Druid | No | No | No | No | Yes | Druid SQL | No | Superset, Pivot, Redash | Yes | Yes |
Essbase | Yes | Yes | Yes | Yes | Yes | No | Yes | SmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting | ? | ? |
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,[17] R[18] | 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 | Yes | Yes |
Microsoft Analysis Services | Yes | Yes | Yes | .NET[19] | Yes[20] | Yes[21] | 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[22] | Yes | Yes | Yes[23] | Yes | Yes | Yes[24] | ? | ? |
Oracle Database OLAP Option | No | Yes[25] | Yes[25] | Java, PL/SQL, OLAP DML | Yes | Yes[26] | No | ? | ? | ? |
SAP NetWeaver BW | Yes | Yes | Yes | No | Yes | No | Yes | ? | ? | ? |
SAS OLAP Server | Yes | Yes | Yes | No | No | No | Yes | Web Report Studio | ? | ? |
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 Kylin | Developing | No | Yes | Yes | Yes |
ClickHouse | Yes | Yes | Yes | Yes | Yes |
Druid | 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[27] | Yes[28] | Yes[29] | ? | ? |
Jedox OLAP Server | Yes | Yes | Yes | ? | ? |
Kyvos | Yes | Yes | Yes | Yes | Yes |
Microsoft Analysis Services | Yes | Yes | Yes | Yes | Yes |
MicroStrategy Intelligence Server | ? | Yes[30] | 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 | ? | ? |
Data modeling features:
OLAP server | Semi-additive measures | Many-to-Many | Multi-Cube Model | Perspectives | KPI | Multilingual | Named Sets | Multi-attribute Hierarchies | Actions |
---|---|---|---|---|---|---|---|---|---|
Apache Kylin | No | No | Yes | No | Yes | Yes | No | Yes | Yes |
ClickHouse | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Druid | Yes | Yes | Yes | ? | No | Yes | ? | Yes | Yes |
Essbase | Yes | ? | ? | ? | Yes | Yes | Yes | Yes | ? |
IBM Cognos BI | Yes | Yes | ? | ? | ? | ? | Yes | Yes | ? |
IBM Cognos TM1 | Yes | Yes | Yes | ? | ? | ? | ? | ? | ? |
icCube | Yes[31] | Yes[32] | 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[33] | ? | ? | ? | ? | ? | ? | ? | ? |
Oracle Database OLAP Option | Yes | ? | ? | ? | ? | ? | ? | ? | ? |
SAP NetWeaver BW | Yes | ? | ? | ? | ? | ? | ? | ? | ? |
SAS OLAP Server | Yes | ? | ? | ? | ? | ? | ? | ? | ? |
System limits
OLAP server | # cubes | # measures | # dimensions | # dimensions in cube | # hierarchies in dimension | # levels in hierarchy | # dimension members |
---|---|---|---|---|---|---|---|
Apache Kylin | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
ClickHouse | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
Druid | Unrestricted[lower-alpha 1] | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted | Unrestricted |
Essbase[34] | Unrestricted | Unrestricted | Unrestricted | 255 | 255 | ? | 20,000,000 (ASO), 1,000,000 (BSO) |
IBM Cognos TM1 | Unrestricted[lower-alpha 1] | Unrestricted | Unrestricted[lower-alpha 1] | 256 | Unrestricted[lower-alpha 1] | 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[35] | 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[lower-alpha 1] | Unrestricted[lower-alpha 1] | Unrestricted[lower-alpha 1] | ? | Unrestricted[lower-alpha 1] | Unrestricted[lower-alpha 1] | Unrestricted[lower-alpha 1] |
SAS OLAP Server[36] | Unrestricted[lower-alpha 1] | 1024 | 128 | ? | 128 | 19 | 4,294,967,296 |
- Please update as 'unrestricted', is just not possible
Security
OLAP server | Authentication | Network encryption | On-the-Fly[lower-alpha 1] | Data access | ||
---|---|---|---|---|---|---|
Cell security | Dimension security | Visual totals | ||||
Apache Kylin | LDAP, SAML, Kerboros, Microsoft Active Directory | SSL | Yes | No | No | ? |
ClickHouse | Built-in, LDAP, Microsoft Active Directory; Kerberos in development | SSL | Yes | Yes | Yes | Yes |
Druid | Druid Database authentication | SSL | Yes | No | Yes | No |
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 | No |
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[37] | ? | Yes | Yes | Yes |
Oracle Database OLAP Option | Oracle Database authentication | SSL | ? | Yes | Yes | No |
SAS OLAP Server[38] | Host authentication,SAS token authentication, LDAP, Microsoft Active Directory | Yes[39] | ? | 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 Kylin | No | Yes | Yes | No | No |
ClickHouse | No | Yes | Yes | No | No |
Druid | No | Yes | Yes | ||
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 |
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 Kylin | Jira | Open | |
ClickHouse | ClickHouse – Github Issues | ClickHouse Roadmap | Open |
Druid | Druid – Github Issues | Open | |
Essbase | myOracle Support | Closed | |
IBM Cognos TM1 | IBM Service Request | Closed | |
icCube | YouTrack | Closed | |
Jedox OLAP Server | Mantis | Available upon request | Open |
Kyvos | Zendesk | 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 |
gollark: I assume you're going to say that actually no, it's something else.
gollark: Someone was trying to tell them they were in danger by phone, but it was too late.
gollark: Obviously, they were assassinated due to their previous - regrettable - involvement with the CIA.
gollark: These things always have some bizarre contrived answer which technically fits the stated situation.
gollark: It's Greek-derived because of the "a" and "theo" bits.
See also
- Cubes (light-weight open-source OLAP server)
- ClickHouse
- Druid (open-source data store)
- icCube
- Oracle Retail Predictive Application Server (RPAS), a retail specific MOLAP/OLAP server using Berkeley DB for persistence
- Palo (OLAP database)
References
- Kylin, Apache. "Apache Kylin | Home". kylin.apache.org. Retrieved 2018-11-08.
- "ClickHouse".
- druid. "Druid | Interactive Analytics at Scale". druid.io. Retrieved 2017-09-01.
- "Oracle Essbase".
- "Cognos Business Intelligence and Financial Performance Management".
- "icCube OLAP Server".
- "Jedox".
- "Kyvos".
- "Microsoft SQL Server 2008 Analysis Services".
- "Pentaho Analysis Services: Mondrian Project".
- "Oracle OLAP Documentation".
- "Components & Tools".
- "SAS OLAP Server".
- "SSAS Entity Framework Provider".
- "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.
- "SQL Server 2008 Books Online (October 2009)Using Stored Procedures". MSDN.
- "How to perform a SQL Server distributed query with OLAP Server". MSDN.
- "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".
- "Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP".
- "Querying Oracle OLAP Cubes: Fast Answers to Tough Questions Using Simple SQL".
- "icCube Real Time walkthrough".
- "icCube Writeback/Update Cube".
- "icCube Partitioning".
- "Common Extensions of the MicroStrategy Platform". Archived from the original on 2010-11-28. Retrieved 2010-11-10.
- "icCube Aggregatin types".
- "icCube Many-to-Many".
- "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.
- "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".
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.