Apache Pinot vs Oracle Essbase
| Apache Pinot | Oracle Essbase | |
|---|---|---|
| Free plan | Yes | No |
| Free trial | No | No |
| Paid from | Free | — |
| Open source | No | No |
| Platforms | api, self-hosted, Web | — |
| Deployment | self_hosted | hybrid |
| Query language | sql | mdx |
| Real-time ingestion | Yes | — |
| Row-level security | Yes | — |
| Embedded analytics | Yes | Yes |
| Data source coverage | Streaming: Kafka, Pulsar, Kinesis; batch: Hadoop, Spark, Amazon S3, Azure ADLS, Google Cloud Storage | relational databases, tables, files, Excel workbooks, Essbase cubes, Spark, JDBC |
| Free plan | — | No |
Both are listed in Best OLAP Software. On Inferse, Apache Pinot scores higher on our published basis.