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.
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 |
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