Comparison of OLAP servers
The following tables compare general and technical information for a number of online analytical processing servers. Please see the individual products articles for further information.
General information
Data storage modes
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 | Visualization | JSON | REST API |
| Apache Doris | Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI | |||||||||
| Apache Druid | Druid SQL | Superset, Pivot, Redash | ||||||||
| Apache Kylin | Superset, Zeppelin, Tableau, Qlik, Redash, Microsoft Excel | |||||||||
| Apache Pinot | Superset, Pivot, Redash | |||||||||
| ClickHouse | Superset, Zeppelin, Tableau, Qlik, Redash, DataLens | |||||||||
| Essbase | SmartView, Oracle Analytics Cloud, Narrative Reporting, Tableau, IBM Cognos | |||||||||
| IBM Cognos TM1 | TM1 Web/TM1 Contributor, IBM Cognos Insight, IBM Performance Modeler, IBM Cognos Cafe for Excel, Cognos BI, TM1 Perspectives for Excel | |||||||||
| icCube | ||||||||||
| Jedox OLAP Server | ||||||||||
| Kyvos | Kyvos Viz, Microsoft Excel, Qlik, Tableau, Power BI, MicroStrategy, IBM Cognos, Business Objects, XLCubed, Looker, Altryx, and more | |||||||||
| Microsoft Analysis Services | ||||||||||
| MicroStrategy Intelligence Server | ||||||||||
| Mondrian OLAP server | ||||||||||
| Oracle Database OLAP Option | ||||||||||
| SAP NetWeaver BW | ||||||||||
| SAS OLAP Server | ||||||||||
| StarRocks | Superset, Redash, Metabase, Tableau, Qlik, Pivot, PowerBI |
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 | |||||
| Apache Druid | |||||
| Apache Kylin | |||||
| Apache Pinot | |||||
| ClickHouse | |||||
| Essbase | |||||
| IBM Cognos BI | |||||
| IBM Cognos TM1 | |||||
| icCube | |||||
| Jedox OLAP Server | |||||
| Kyvos | |||||
| Microsoft Analysis Services | |||||
| MicroStrategy Intelligence Server | |||||
| Mondrian OLAP server | |||||
| Oracle Database OLAP Option | |||||
| SAP NetWeaver BW | |||||
| SAS OLAP Server | |||||
| StarRocks |
| OLAP server | Semi-additive measures | Many-to-Many | Multi-Cube Model | Perspectives | KPI | Multilingual | Named Sets | Multi-attribute Hierarchies | Actions |
| Apache Doris | |||||||||
| Apache Druid | |||||||||
| Apache Kylin | |||||||||
| Apache Pinot | |||||||||
| ClickHouse | |||||||||
| Essbase | |||||||||
| IBM Cognos BI | |||||||||
| IBM Cognos TM1 | |||||||||
| icCube | |||||||||
| Jedox OLAP Server | |||||||||
| Kyvos | |||||||||
| Microsoft Analysis Services | |||||||||
| MicroStrategy Intelligence Server | |||||||||
| Mondrian OLAP server | |||||||||
| Oracle Database OLAP Option | |||||||||
| SAP NetWeaver BW | |||||||||
| SAS OLAP Server | |||||||||
| StarRocks |
System limits
Security
Operating systems
The OLAP servers can run on the following operating systems:| OLAP server | Windows | Linux | UNIX | z/OS | AIX |
| Apache Doris | |||||
| Apache Druid | |||||
| Apache Kylin | |||||
| Apache Pinot | |||||
| ClickHouse | |||||
| Essbase | |||||
| IBM Cognos TM1 | |||||
| icCube | |||||
| Jedox OLAP Server | |||||
| Kyvos | |||||
| Microsoft Analysis Services | |||||
| MicroStrategy Intelligence Server | |||||
| Mondrian OLAP server | |||||
| Oracle Database OLAP Option | |||||
| SAP NetWeaver BW | |||||
| SAS OLAP Server | |||||
| StarRocks |
Note :The server availability depends on Java Virtual Machine not on the operating system