Comparison of OLAP servers

From Wikipedia, the free encyclopedia
  (Redirected from Comparison of OLAP Servers)
Jump to navigation Jump to search

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[edit]

OLAP Server Company Website Latest stable version Software license License Pricing
Apache Kylin Apache Software Foundation [1] 2.5.1 Apache 2.0 free
Druid Open source community [2] 0.11.0 Apache 2.0 free
Apache Pinot (Incubating) Apache Software Foundation [3] 0.1.0 Apache 2.0 free
Essbase Oracle [4] 11.1.2.4 Proprietary [1]
IBM Cognos TM1 IBM [5] 10.2.2 FP7 Proprietary -
icCube icCube [6] 6.8.6 Proprietary community/[2]
Infor BI OLAP Server Infor [7] 10.6.0 Proprietary -
Jedox OLAP Server Jedox [8] 7.0 GPL v2 or EULA, Proprietary [3]
Kyligence Kyligence [9] 3.2.1 Proprietary -
Kyvos BI on Big Data Kyvos Insights [10] 4.0 Proprietary -
Microsoft Analysis Services Microsoft [11] 2016 Proprietary [4]
MicroStrategy Intelligence Server MicroStrategy [12] 10.11 Proprietary -
Mondrian OLAP server Pentaho [13] 3.7 EPL free
Oracle Database OLAP Option Oracle [14] 11g R2 Proprietary [5]
SAP NetWeaver BW SAP [15] 7.30 Proprietary -
SAS OLAP Server SAS Institute [16] 9.4 Proprietary -

Data storage modes[edit]

OLAP Server MOLAP ROLAP HOLAP Offline
Apache Kylin Yes No No Yes
Druid Yes Yes Yes Yes
Apache Pinot (Incubating) 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
Infor BI OLAP Server Yes No No Local cubes
Jedox OLAP Server Yes No No No
Kyligence Yes Yes Yes Yes
Kyvos BI on Big Data Yes Yes No 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[edit]

APIs and query languages OLAP servers support.

OLAP Server XML for Analysis OLE DB for OLAP MDX Stored procedures Custom functions SQL LINQ[17] Visualization JSON REST API
Apache Kylin No No No No Yes Yes Superset, Zeppelin, Tableau, Qlik, Redash Yes Yes
Druid No No No No Yes Druid SQL No Superset, Pivot Yes Yes
Apache Pinot (Incubating) No No No No Yes Pinot SQL No Superset Yes Yes
Essbase Yes Yes Yes Yes Yes No Yes SmartView (Excel-AddIn), WebAnalysis, Financial Reports ? ?
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,[18] R[19] Yes In the reporting Yes icCube reporting and all XMLA compliant visualization tools like Excel, etc Yes Yes
Infor BI OLAP Server Yes Yes Yes OLAP Rules, Push Rules, Application Engine Yes Yes No Application Studio ? ?
Jedox OLAP Server Yes Yes Yes Cube Rules, SVS Triggers Yes No Yes Microsoft Excel, Qlik, Tableau, Jedox Web, Power BI No Yes
Kyligence No No Yes No Yes Yes IBM Cgonos, Business Objects, OBIEE, MicroStrategy, Microsoft Excel, Microsoft Power BI, Qlik, Superset,Tableau Yes Yes
Kyvos BI on Big Data Yes Yes Yes No Yes Yes No Kyvos Insights, Microsoft Excel, Qlik, Tableau, Power BI, MicroStrategy, IBM Cognos, Business Objects ?? Yes
Microsoft Analysis Services Yes Yes Yes .NET[20] Yes[21] Yes[22] Yes Microsoft Excel, SharePoint, Microsoft Power BI, and 70+ other visualization tools ? ?
MicroStrategy Intelligence Server Yes No Yes Yes Yes Yes Yes ? ? ?
Mondrian OLAP server Yes Yes[23] Yes Yes Yes[24] Yes Yes Yes [25] ? ?
Oracle Database OLAP Option No Yes[26] Yes[26] Java, PL/SQL, OLAP DML Yes Yes[27] 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[edit]

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
Druid Yes ? Yes Yes Yes
Apache Pinot (Incubating) 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[28] Yes[29] Yes[30] ? ?
Infor BI OLAP Server Yes Yes Yes ? ?
Jedox OLAP Server Yes Yes Yes ? ?
Kyligence No No Yes Yes Yes
Kyvos BI on Big Data No No Yes Yes Yes
Microsoft Analysis Services Yes Yes Yes Yes Yes
MicroStrategy Intelligence Server ? Yes[31] 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
Druid Yes Yes Yes ? No Yes ? Yes Yes
Apache Pinot (Incubating) Yes Yes Yes ? ? No No No No
Essbase Yes ? ? ? Yes Yes Yes Yes ?
IBM Cognos BI Yes Yes ? ? ? ? Yes Yes ?
IBM Cognos TM1 Yes Yes Yes ? ? ? ? ? ?
icCube Yes[32] Yes[33] Yes Yes ? Yes Yes ? ?
Infor BI OLAP Server Yes ? Yes ? Yes ? ? ? ?
Jedox OLAP Server Yes Yes Yes Yes Yes Yes Yes Yes ?
Kyligence Yes No Yes No Yes Yes Yes
Kyvos BI on Big Data 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 ? ? ? ? ? ? ? ?
Mondrian OLAP server Yes[34] ? ? ? ? ? ? ? ?
Oracle Database OLAP Option Yes ? ? ? ? ? ? ? ?
SAP NetWeaver BW Yes ? ? ? ? ? ? ? ?
SAS OLAP Server Yes ? ? ? ? ? ? ? ?

System limits[edit]

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
Druid Unrestricted[a] Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted
Apache Pinot (Incubating) Unrestricted[a] Unrestricted Unrestricted Unrestricted - - Unrestricted
Essbase[35] ? ? ? 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
Infor BI OLAP Server ? 10,000,000 ? 30 ? ? 10,000,000
Jedox OLAP Server (32 bits) (32 bits) 250
Kyligence Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted Unrestricted
Kyvos BI on Big Data Unrestricted Unrestricted Unrestricted Unrestricted 1 Unrestricted Unrestricted
Microsoft Analysis Services[36] 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[37] Unrestricted[a] 1024 128 ? 128 19 4,294,967,296
  1. ^ a b c d e f g h i j k l Please update as 'unrestricted', is just not possible

Security[edit]

OLAP Server Authentication Network encryption On-the-Fly[a] Data access
Cell security Dimension security Visual totals
Apache Kylin LDAP, SAML, Kerboros, Microsoft Active Directory SSL Yes No No ?
Druid Druid Database authentication SSL Yes No Yes No
Apache Pinot (Incubating) Plugin based Coming soon Plugin based ? ? ?
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) SSL Yes Yes Yes Yes
Infor BI OLAP Server OLAP authentication, Infor Federation Services, LDAP, Microsoft Active Directory Yes Yes Yes Yes ?
Jedox OLAP Server Jedox authentication, LDAP, Microsoft Active Directory SSL Yes Yes Yes ?
Kyligence LDAP, SAML, Kerboros, Microsoft Active Directory, Built-in SSL Yes Yes ?
Kyvos BI on Big Data Built-in, LDAP, Microsoft Active Directory, Windows SSO (NTLM, Kerberos) 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[38] ? Yes Yes Yes
Oracle Database OLAP Option Oracle Database authentication SSL ? Yes Yes No
SAS OLAP Server[39] Host authentication,SAS token authentication, LDAP, Microsoft Active Directory Yes[40] ? Yes Yes Yes
  1. ^ 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[edit]

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
Druid No Yes Yes
Apache Pinot (Incubating) No Yes Yes
Essbase Yes Yes Yes No
IBM Cognos TM1 Yes Yes Yes No Yes
icCube Yes Yes Yes Yes Yes
Infor BI OLAP Server Yes No No No
Jedox OLAP Server Yes Yes Yes No
Kyligence No Yes Yes No No
Kyvos BI on Big Data No Yes Yes No No
Microsoft Analysis Services Yes No No No
MicroStrategy Intelligence Server Yes Yes Yes No
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[edit]

OLAP Server Issue Tracking System Forum/Blog Roadmap Source code
Apache Kylin Jira [41] Open
Druid Druid – Github Issues [42] Open
Apache Pinot (Incubating) Jira [43] Open
Essbase myOracle Support [6] [7] Closed
IBM Cognos TM1 IBM Service Request [8] Closed
icCube YouTrack [9] Closed
Infor BI OLAP Server Infor Xtreme Available upon request Closed
Jedox OLAP Server Mantis [10] Available upon request Open
Kyligence Zendesk [44] Closed
Kyvos BI on Big Data Zendesk Available upon request Open
Microsoft Analysis Services Connect [11] - Closed
MicroStrategy Intelligence Server MicroStrategy Resource Center [12] - Closed
Mondrian OLAP server Jira [13] [14] Open
Oracle Database OLAP Option myOracle Support [15] Closed
SAP NetWeaver BW OSS [16] [17] Closed
SAS OLAP Server Support [18] Closed

See also[edit]

Apache Pinot (Incubating)

References[edit]

  1. ^ Kylin, Apache. "Apache Kylin | Home". kylin.apache.org. Retrieved 2018-11-08.
  2. ^ druid. "Druid | Interactive Analytics at Scale". druid.io. Retrieved 2017-09-01.
  3. ^ Pinot, Apache. "Apache Pinot (Incubating) | Home". https://pinot.apache.org/. Retrieved 2019-03-27. External link in |website= (help)
  4. ^ "Oracle Essbase".
  5. ^ "Cognos Business Intelligence and Financial Performance Management".
  6. ^ "icCube OLAP Server".
  7. ^ "Infor".
  8. ^ "Jedox".
  9. ^ "Kyligence - Enterprise OLAP for Big Data | Apache Kylin". kyligence.io. Retrieved 2018-11-08.
  10. ^ "Kyvos".
  11. ^ "Microsoft SQL Server 2008 Analysis Services".
  12. ^ "MicroStrategy Intelligence Server".
  13. ^ "Pentaho Analysis Services: Mondrian Project".
  14. ^ "Oracle OLAP Documentation".
  15. ^ "Components & Tools".
  16. ^ "SAS OLAP Server".
  17. ^ "SSAS Entity Framework Provider".
  18. ^ "icCube Java integration documentation". icCube.
  19. ^ "icCube R language integration documentation". icCube.
  20. ^ "SQL Server 2008 Books Online (October 2009)Defining Stored Procedures". MSDN.
  21. ^ "SQL Server 2008 Books Online (October 2009)Using Stored Procedures". MSDN.
  22. ^ "How to perform a SQL Server distributed query with OLAP Server". MSDN.
  23. ^ "Pentaho and Simba Technologies Partner to Bring World's Most Popular Open Source OLAP Project to Microsoft Excel Users".
  24. ^ "How to Define a Mondrian Schema". Pentaho.
  25. ^ "Pentaho Business Analytics Visualization".
  26. ^ a b "Oracle and Simba Technologies Introduce MDX Provider for Oracle OLAP".
  27. ^ "Querying Oracle OLAP Cubes: Fast Answers to Tough Questions Using Simple SQL".
  28. ^ "icCube Real Time walkthrough".
  29. ^ "icCube Writeback/Update Cube".
  30. ^ "icCube Partitioning".
  31. ^ "Common Extensions of the MicroStrategy Platform".
  32. ^ "icCube Aggregatin types".
  33. ^ "icCube Many-to-Many".
  34. ^ "Support for Non-Additive and Semi-Additive Measures".
  35. ^ "Essbase Server Limits". Oracle.
  36. ^ "SQL Server 2008 Books Online (October 2009)Maximum Capacity Specifications (Analysis Services - Multidimensional Data)". Microsoft.
  37. ^ "SAS OLAP Cube Size Specifications".
  38. ^ MicroStrategy Intelligence Server Features
  39. ^ "SAS OLAP Security Totals and Permission Conditions".
  40. ^ "How to Change Over-the-Wire Encryption Settings for SAS Servers".
  41. ^ Kylin, Apache. "Apache Kylin | Blog". kylin.apache.org. Retrieved 2018-11-08.
  42. ^ "Google Groups". groups.google.com. Retrieved 2017-09-01.
  43. ^ "Get Involved". pinot.apache.org. Retrieved 2019-03-27.
  44. ^ "Kyligence Blog | Kyligence". kyligence.io. Retrieved 2018-11-08.