Comparison of OLAP servers
{{short description|None}}
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
Data storage modes
class="wikitable sortable" style="font-size: 100%; text-align: center; width: auto;" |
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}} | {{Yes| [http://www-01.ibm.com/support/knowledgecenter/SSVJ22_10.2.2/com.ibm.swg.ba.cognos.dsk_ug.10.2.2.doc/t_dsk_maintain_offline.html%23t_dsk_maintain_offline Cognos Insight Distributed mode]}} |
icCube
| {{Yes}} | {{No}} | {{No}} | {{Yes | [https://doc.iccube.com/?ic3topic=server.user_guide.using.schema_snapshots]}} |
Jedox OLAP Server
| {{Yes}} | {{No}} | {{No}} | {{No}} |
Kyvos
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
Microsoft Analysis Services
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes|Local cubes, |
MicroStrategy Intelligence Server
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes|[http://www.microstrategy.com/Software/Products/User_Interfaces/Office/ MicroStrategy Office], |
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.
{{sort-under}}
class="wikitable sortable sort-under" style="font-size: 100%; text-align: center; width: auto;" |
OLAP server
! MDX ! Custom functions ! SQL ! LINQ{{cite web|url=http://agiledesignllc.com/products|archive-url=https://web.archive.org/web/20110929151255/http://www.agiledesignllc.com/Products|url-status=usurped|archive-date=September 29, 2011|title=SSAS Entity Framework Provider}} ! Visualization ! JSON ! REST API |
---|
Apache Doris
| {{No}} | {{No}} | {{No}} | {{No}} | {{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}}{{cite web|url=https://clickhouse.tech/docs/en/sql-reference/|title=ClickHouse SQL Reference|publisher=Yandex}} | {{Yes}} | {{No}} | Superset, Zeppelin, Tableau, Qlik, Redash, DataLens{{cite web|url=https://clickhouse.tech/docs/en/interfaces/third-party/gui/|title=ClickHouse Visual Interfaces|publisher=Yandex}} | {{Yes}} | {{Yes}} |
Essbase
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{No}} | {{Yes}} | SmartView (Excel-AddIn), Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos | {{dunno}} | {{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}} | {{Yes|Java,{{cite web|url=http://www.iccube.com/support/documentation/mdx_integration/java_integration.html|title=icCube Java integration documentation|publisher=icCube}} R{{cite web|url=http://www.iccube.com/support/documentation/mdx_integration/r_integration.html|title=icCube R language integration documentation|publisher=icCube}}}} | {{Yes}} | {{Maybe|In the reporting}} | {{Yes}} | {{Yes| icCube reporting and all XMLA compliant visualization tools like Excel, etc}} | {{Yes}} | {{Yes}} |
Jedox OLAP Server
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes|Cube Rules, SVS Triggers}} | {{Yes}} | {{No}} | {{Yes}} | {{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}} | {{Yes|.NET}}{{cite web|url=http://msdn.microsoft.com/en-us/library/ms176113.aspx|title=SQL Server 2008 Books Online (October 2009)Defining Stored Procedures|date=9 December 2022 |publisher=MSDN}} | {{Yes}}{{cite web|url=http://msdn.microsoft.com/en-us/library/ms145486.aspx|title=SQL Server 2008 Books Online (October 2009)Using Stored Procedures|date=28 February 2023 |publisher=MSDN}} | {{Yes}}{{cite web|url=http://support.microsoft.com/kb/218592/en-gb|title=How to perform a SQL Server distributed query with OLAP Server|date=7 March 2023 |publisher=MSDN}} | {{Yes}} | {{Yes|Microsoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization tools}} | {{No}} | {{No}} |
MicroStrategy Intelligence Server
| {{Yes}} | {{No}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes|Dossier, Dashboard, Reports}} | {{Yes}} | {{Yes}} |
Mondrian OLAP server
| {{Yes}} | {{Yes}} | {{Yes}} | {{No}} | {{Yes}} | {{dunno}} | {{dunno}} |
Oracle Database OLAP Option
| {{No}} | {{Yes|Java, PL/SQL, OLAP DML}} | {{Yes}} | {{No}} | {{dunno}} | {{dunno}} | {{dunno}} |
SAP NetWeaver BW
| {{Yes}} | {{Yes}} | {{Yes}} | {{No}} | {{Yes}} | {{No}} | {{Yes}} | {{dunno}} | {{dunno}} | {{dunno}} |
SAS OLAP Server
| {{Yes}} | {{Yes}} | {{Yes}} | {{No}} | {{No}} | {{No}} | {{Yes}} | {{Yes|Web Report Studio}} | {{dunno}} | {{dunno}} |
StarRocks
| {{No}} | {{No}} | {{No}} | {{No}} | {{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.
{{sort-under}}
class="wikitable sortable sort-under" style="font-size: 100%; text-align: center; width: auto;"
|+ 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}} | {{dunno}} | {{Yes}} | {{Yes}} | {{Yes}} |
Apache Kylin
| {{Yes}}{{cite web|url=http://kylin.apache.org/docs30/tutorial/realtime_olap.html|title = Real-time OLAP}} | {{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}} | {{dunno}} |
IBM Cognos TM1
| {{Yes}} | {{Yes}} | {{Yes}} | {{dunno}} | {{dunno}} |
icCube
| {{No}} | {{dunno}} | {{dunno}} |
Jedox OLAP Server
| {{Yes}} | {{Yes}} | {{Yes}} | {{dunno}} | {{dunno}} |
Kyvos
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
Microsoft Analysis Services
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
MicroStrategy Intelligence Server
| {{dunno}} | {{Yes}} | {{Yes}} | {{Yes}} |
Mondrian OLAP server
| {{Yes}} | {{Yes2 | Planned}} | {{Yes}} | {{dunno}} | {{dunno}} |
Oracle Database OLAP Option
| {{dunno}} | {{Yes}} | {{Yes}} | {{No}} | {{dunno}} |
SAP NetWeaver BW
| {{dunno}} | {{Yes}} | {{Yes}} | {{dunno}} | {{dunno}} |
SAS OLAP Server
| {{dunno}} | {{Yes}} | {{Yes}} | {{dunno}} | {{dunno}} |
StarRocks
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
class="wikitable sortable sort-under" style="font-size: 100%; text-align: center; width: auto;"
|+ 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}} | {{dunno}} | {{No}} | {{Yes}} | {{dunno}} | {{Yes}} | {{Yes}} |
Apache Kylin
| {{No}} | {{No}} | {{Yes}} | {{No}} | {{Yes}} | {{Yes}} | {{No}} | {{Yes}} | {{Yes}} |
Apache Pinot
| {{Yes}} | {{Yes}} | {{dunno}} | {{dunno}} | {{No}} | {{Yes}} | {{dunno}} | {{Yes}} | {{Yes}} |
ClickHouse
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{No}} |
Essbase
| {{Yes}} | {{dunno}} | {{dunno}} | {{dunno}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{dunno}} |
IBM Cognos BI
| {{Yes}} | {{Yes}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{Yes}} | {{Yes}} | {{dunno}} |
IBM Cognos TM1
| {{Yes}} | {{Yes}} | {{Yes}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} |
icCube
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{dunno}} |
Jedox OLAP Server
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{dunno}} |
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
| {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} |
Oracle Database OLAP Option
| {{Yes}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} |
SAP NetWeaver BW
| {{Yes}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} |
SAS OLAP Server
| {{Yes}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} | {{dunno}} |
StarRocks
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} | {{No}} |
System limits
class="wikitable sortable" style="font-size: 100%; text-align: center; width: auto;" |
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{{efn|name=fn0}} | 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{{cite web|url=http://docs.oracle.com/cd/E57185_01/epm.1112/essbase_db/frameset.htm?limits.html|title=Essbase Server Limits|publisher=Oracle|access-date=2015-06-25|archive-url=https://web.archive.org/web/20150626101348/http://docs.oracle.com/cd/E57185_01/epm.1112/essbase_db/frameset.htm?limits.html|archive-date=2015-06-26|url-status=dead}}
| Unrestricted | Unrestricted | Unrestricted | 255 | 255 | ? | 20,000,000 (ASO), 1,000,000 (BSO) |
IBM Cognos TM1
| Unrestricted{{efn|name=fn0}} | Unrestricted | Unrestricted{{efn|name=fn0}} | 256 | Unrestricted{{efn|name=fn0}} | 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{{cite web|url=https://technet.microsoft.com/en-us/library/ms365363.aspx|title=SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data)|date=9 December 2022 |publisher=Microsoft}}
| 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{{efn|name=fn0}} | Unrestricted{{efn|name=fn0}} | Unrestricted{{efn|name=fn0}} | ? | Unrestricted{{efn|name=fn0}} | Unrestricted{{efn|name=fn0}} | Unrestricted{{efn|name=fn0}} |
SAS OLAP Server{{cite web|url=http://support.sas.com/documentation/cdl/en/olapug/63148/HTML/default/viewer.htm#p0m66bhcbgqwjen1jyfhf6woysu3.htm|title=SAS OLAP Cube Size Specifications}}
| Unrestricted{{efn|name=fn0}} | 1024 | 128 | ? | 128 | 19 | 4,294,967,296 |
StarRocks
|Unrestricted |Unrestricted |Unrestricted |Unrestricted |Unrestricted |Unrestricted |Unrestricted |
{{notelist|notes=
{{efn|name=fn0|Please update as 'unrestricted', is just not possible}}
}}
Security
{{sort under}}
class="wikitable sortable sort-under" style="font-size: 100%; text-align: center; width: auto;" |
rowspan="2"| OLAP server
!rowspan="2"| Authentication !rowspan="2"| Network encryption !rowspan="2"| On-the-Fly{{efn|name=fn1}} !colspan="3"| Data access |
---|
Cell security
!Dimension security !Visual totals |
Apache Doris
| {{Yes|Built-in, LDAP, Kerberos}} | {{Yes|SSL}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
Apache Druid
| {{Yes|Druid Database authentication}} | {{Yes|SSL}} | {{Yes}} | {{No}} | {{Yes}} | {{No}} |
Apache Kylin
| {{Yes|LDAP, SAML, Kerboros, Microsoft Active Directory}} | {{Yes|SSL}} | {{Yes}} | {{No}} | {{No}} | {{dunno}} |
Apache Pinot
| {{Yes|[https://docs.pinot.apache.org/operators/tutorials/authentication-authorization-and-acls HTTP basic authentication]}} | {{Yes|SSL}} | {{dunno}} | {{No}} | {{No}} | {{No}} |
ClickHouse
| {{Yes|Built-in, LDAP, Microsoft Active Directory, Kerberos}} | {{Yes|SSL}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
Essbase
| {{Yes|Essbase authentication, LDAP authentication, Microsoft Active Directory}} | {{Yes|SSL}} | {{Yes}} | {{Yes}} | {{Yes}} | {{No}} |
IBM Cognos TM1
| {{Yes|Builtin, LDAP, Microsoft Active Directory, NTLM, IBM Cognos BI authentication}} | {{Yes|SSL}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
icCube
| {{Yes|HTTP Basic/Form Authentication, Windows SSO (NTLM, Kerberos), Plugin Based for Embedded Usage}} | {{Yes|SSL}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
Jedox OLAP Server
| {{Yes|Jedox authentication, LDAP, Microsoft Active Directory}} | {{Yes|SSL}} | {{Yes}} | {{Yes}} | {{Yes}} | {{dunno}} |
Kyvos
| {{Yes|Built-in, LDAP, Microsoft Active Directory, SAML, Windows SSO (NTLM, Kerberos)}} | {{Yes|SSL}} | {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
Microsoft Analysis Services
| {{Yes}} | {{Yes}} | {{Yes}} | {{Yes}} |
MicroStrategy Intelligence Server
| {{Yes|Host authentication, database authentication, LDAP, | {{Yes|SSL, AES{{Cite web |url=http://latam.microstrategy.com/Software/Products/Intelligence_Server/features.asp |title=MicroStrategy Intelligence Server Features |access-date=2010-11-10 |archive-url=https://archive.today/20120710203458/http://latam.microstrategy.com/Software/Products/Intelligence_Server/features.asp |archive-date=2012-07-10 |url-status=dead }}}} | {{dunno}} | {{Yes}} | {{Yes}} | {{Yes}} |
Oracle Database OLAP Option
| {{Yes|Oracle Database authentication}} | {{Yes|SSL}} | {{dunno}} | {{Yes}} | {{Yes}} | {{No}} |
SAS OLAP Server{{cite web|url=http://support.sas.com/documentation/cdl/en/mdxag/59575/HTML/default/a003230130.htm|title=SAS OLAP Security Totals and Permission Conditions}}
| {{Yes|Host authentication, SAS token authentication, LDAP, Microsoft Active Directory}} | {{dunno}} | {{Yes}} | {{Yes}} | {{Yes}} |
{{notelist|notes=
{{efn|name=fn1|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:
class="wikitable sortable" style="font-size: 100%; text-align: center; width: auto;" |
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
class="wikitable sortable" style="font-size: 100%; text-align: center; width: auto;" |
OLAP server
! Issue Tracking System ! Roadmap ! Source code |
---|
Apache Doris
| [https://github.com/apache/doris/issues Apache Doris– Github Issues] | [https://github.com/apache/doris/issues/30669 Apache Doris Roadmap] | {{Yes|Open}} |
Apache Druid
| [https://github.com/druid-io/druid/issues Druid – Github Issues] | | {{Yes|Open}} |
Apache Kylin
| [https://issues.apache.org/jira/projects/KYLIN/issues Jira] |[http://kylin.apache.org/development/ Apache Kylin Roadmap] | {{Yes|Open}} |
Apache Pinot
| [https://github.com/apache/incubator-pinot/issues Apache Pinot – Github Issues] | | {{Yes|Open}} |
ClickHouse
| [https://github.com/ClickHouse/ClickHouse/issues ClickHouse – Github Issues] | [https://clickhouse.tech/docs/en/whats-new/roadmap/ ClickHouse Roadmap] | {{Yes|Open}} |
Essbase
| [http://support.oracle.com myOracle Support] |{{usurped|1=[https://web.archive.org/web/20100705081200/http://communities.ioug.org/Portals/2/Oracle_Essbase_Roadmap_Sep_09.pdf]}} | {{No|Closed}} |
IBM Cognos TM1
| [http://ibm.com/support/servicerequest/ IBM Service Request] | | {{No|Closed}} |
icCube
| [https://stackoverflow.com/questions/tagged/iccube Stackoverflow] | | {{No|Closed}} |
Jedox OLAP Server
| {{usurped|1=[https://web.archive.org/web/20110812224712/http://bugs.palo.net/mantis/main_page.php Mantis]}} | Available upon request | {{Yes|Open}} |
Kyvos
| Zendesk | Available upon request | {{No|Closed}} |
Microsoft Analysis Services
| [https://connect.microsoft.com/SQLServer Connect] | - | {{No|Closed}} |
MicroStrategy Intelligence Server
| [https://resource.microstrategy.com/Support/MainSearch.aspx MicroStrategy Resource Center] | - | {{No|Closed}} |
Mondrian OLAP server
|[http://jira.pentaho.com/browse/MONDRIAN Jira] |[http://mondrian.pentaho.org/documentation/roadmap.php] | {{Yes|Open}} |
Oracle Database OLAP Option
| [http://support.oracle.com myOracle Support] | | {{No|Closed}} |
SAP NetWeaver BW
| [http://service.sap.com/ OSS] | {{usurped|1=[https://web.archive.org/web/20110716004633/http://esworkplace.sap.com/socoview(bD1lbiZjPTAwMSZkPW1pbg==)/render.asp?id=2270EAD629814D05A7ECECECECC8D002&fragID=&packageid=DEE98D07DF9FA9F1B3C7001A64D3F462]}} | {{No|Closed}} |
SAS OLAP Server
| [http://support.sas.com/forums/index.jspa Support] | | {{No|Closed}} |
StarRocks
| [https://github.com/StarRocks/starrocks/issues StarRocks– Github Issues] | [https://github.com/StarRocks/starrocks/issues/16445 StarRocks Roadmap] | {{Yes|Open}} |
See also
- Cubes (light-weight open-source OLAP server)
- ClickHouse
- Apache Pinot
- Apache Druid
- [https://doris.apache.org/docs/summary/basic-summary Apache Doris]
- Oracle Essbase
- Oracle Retail Predictive Application Server (RPAS), a retail specific MOLAP/OLAP server using Berkeley DB for persistence
- Palo (OLAP database)
- [https://starrocks.io StarRocks]
References
{{reflist}}
{{Data warehouse}}
{{DEFAULTSORT:Comparison Of Olap Servers}}