Try our new research platform with insights from 80,000+ expert users

Databricks vs Oracle Essbase comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Databricks
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
91
Ranking in other categories
Cloud Data Warehouse (9th), Data Science Platforms (1st), Streaming Analytics (1st)
Oracle Essbase
Average Rating
8.2
Reviews Sentiment
4.6
Number of Reviews
18
Ranking in other categories
Database Development and Management (9th)
 

Mindshare comparison

Databricks and Oracle Essbase aren’t in the same category and serve different purposes. Databricks is designed for Cloud Data Warehouse and holds a mindshare of 8.3%, up 5.9% compared to last year.
Oracle Essbase, on the other hand, focuses on Database Development and Management, holds 0.8% mindshare, down 1.2% since last year.
Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
Databricks8.3%
Snowflake17.7%
Dremio8.9%
Other65.1%
Cloud Data Warehouse
Database Development and Management Market Share Distribution
ProductMarket Share (%)
Oracle Essbase0.8%
SolarWinds Database Performance Analyzer6.4%
Redgate SQL Toolbelt Essentials5.9%
Other86.9%
Database Development and Management
 

Featured Reviews

ShubhamSharma7 - PeerSpot reviewer
Capability to integrate diverse coding languages in a single notebook greatly enhances workflow
Databricks offers various courses that I can use, whether it's PySpark, Scala, or R. I can leverage all these courses in a single notebook, which is beneficial for clients as they can access various tools in one place whenever needed. This is quite significant. I usually work with PySpark based on client requirements. After coding, I feed the Databricks notebooks into the ADF pipeline for updates. Databricks' capability to process data in parallel enhances data processing speed. Furthermore, I can connect our Databricks notebook directly with Power BI and other visualization tools like Qlik. Once we develop code, it allows us to transform raw data into visualizations for clients using analysis diagrams, which is very helpful.
Bhavya N - PeerSpot reviewer
Ensuring efficient data analysis and reporting while identifying areas for calculation and export improvements
The features of Oracle Essbase are valuable, such as its multi-dimensional database used for dynamic calculations and reporting purposes. These features are valuable because they support multi-dimensional data views, allowing users to analyze relationships across various data categories and establish a comprehensive perspective on business operations. Moreover, dynamic calculations allow real-time data analysis, significantly improving the accuracy and depth of financial insights. I have utilized Essbase's data aggregation capabilities. The Oracle Essbase interface provides a good user experience, allowing users to easily navigate and analyze data with fast query performance, effective data visualization tools such as charts, graphs, and tables, and flexibility for customizable analysis and reporting, including the ability to create ad hoc reports. The benefits of the interface include improving productivity and enhancing decision-making.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"This solution offers a lake house data concept that we have found exciting. We are able to have a large amount of data in a data lake and can manage all relational activities."
"The solution is very easy to use."
"The most valuable feature of Databricks is the integration of the data warehouse and data lake, and the development of the lake house. Additionally, it integrates well with Spark for processing data in production."
"The most valuable features of the solution are the hardware and the resources it quickly provides without much hassle."
"Databricks' most valuable feature is the data transformation through PySpark."
"The initial setup is pretty easy."
"The most valuable aspect of the solution is its notebook. It's quite convenient to use, both terms of the research and the development and also the final deployment, I can just declare the spark jobs by the load tables. It's quite convenient."
"It offers AI functionalities that assist with code management and machine learning processes."
"Oracle's capability to define custom hierarchies and dimensions has helped my organization in performing nuanced data exploration and advanced modeling because we use Oracle Essbase for dimension definition and also to define the properties of these members, such as dynamic members, stored members, shared members."
"Essbase is extremely stable and low-maintenance."
"The solution is stable and reliable."
"Unlike relational, where you're linking together multiple tables, with Essbase, you basically define what the dimensions are beforehand, and you define the hierarchy, and then load the data. This allows you to do a pretty sophisticated analysis so that you can drill into it and slice and dice the data."
"The Oracle Essbase interface provides a good user experience, allowing users to easily navigate and analyze data with fast query performance, effective data visualization tools such as charts, graphs, and tables, and flexibility for customizable analysis and reporting, including the ability to create ad hoc reports."
"It is very fast compared to other normal databases, like SQL and MySQL."
"The solution is scalable."
"Oracle Essbase is a web integration system that integrates with other data systems."
 

Cons

"We'd like a more visual dashboard for analysis It needs better UI."
"I would like to see more documentation in terms of how an end-user could use it, and users like me can easily try it and implement use cases."
"The integration features could be more interesting, more involved."
"Databricks has a lack of debuggers, and it would be good to see more components."
"This solution only supports queries in SQL and Python, which is a bit limiting."
"It would be very helpful if Databricks could integrate with platforms in addition to Azure."
"I would like more integration with SQL for using data in different workspaces."
"Databricks' technical support takes a while to respond and could be improved."
"It's an expensive product to use."
"The initial setup is pretty complex."
"I would like to see an integration with application performance management and a version control management tool."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"The ability to drive external reporting out for development could be improved."
"A significant area for improvement in Oracle Essbase is that financial statement analysis, CAPEX and OPEX analysis, and financial consolidation must be done manually, as Oracle Essbase doesn't include the financial consolidation module that is available in EPM."
"The reporting tool of Essbase needs improvement."
"There is room for improvement in terms of cost-effectiveness."
 

Pricing and Cost Advice

"My smallest project is around a hundred euros, and my most expensive is just under a thousand euros a week. That is based on terabytes of data processed each month."
"Databricks is a very expensive solution. Pricing is an area that could definitely be improved. They could provide a lower end compute and probably reduce the price."
"The pricing depends on the usage itself."
"I am based in South Africa, where it is expensive adapting to the cloud, and then there is the price for the tool itself."
"I rate the price of Databricks as eight out of ten."
"Licensing on site I would counsel against, as on-site hardware issues tend to really delay and slow down delivery."
"The basic version of this solution is now open-source, so there are no license costs involved. However, there is a charge for any advanced functionality and this can be quite expensive."
"The solution uses a pay-per-use model with an annual subscription fee or package. Typically this solution is used on a cloud platform, such as Azure or AWS, but more people are choosing Azure because the price is more reasonable."
"I believe the licensing is on a monthly base."
"The solution is expensive."
"It is a costly solution."
"Essbase is competitively priced."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
868,787 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
9%
Manufacturing Company
9%
Healthcare Company
6%
Financial Services Firm
21%
Computer Software Company
9%
Insurance Company
8%
Retailer
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business25
Midsize Enterprise12
Large Enterprise56
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise1
Large Enterprise14
 

Questions from the Community

Which do you prefer - Databricks or Azure Machine Learning Studio?
Databricks gives you the option of working with several different languages, such as SQL, R, Scala, Apache Spark, or Python. It offers many different cluster choices and excellent integration with ...
How would you compare Databricks vs Amazon SageMaker?
We researched AWS SageMaker, but in the end, we chose Databricks. Databricks is a Unified Analytics Platform designed to accelerate innovation projects. It is based on Spark so it is very fast. It...
Which would you choose - Databricks or Azure Stream Analytics?
Databricks is an easy-to-set-up and versatile tool for data management, analysis, and business analytics. For analytics teams that have to interpret data to further the business goals of their orga...
What is your experience regarding pricing and costs for Oracle Essbase?
It's not that expensive, but also not cheap. I'm not sure because it's a private license.
What needs improvement with Oracle Essbase?
A significant area for improvement in Oracle Essbase is that financial statement analysis, CAPEX and OPEX analysis, and financial consolidation must be done manually, as Oracle Essbase doesn't incl...
What is your primary use case for Oracle Essbase?
The initial setup of Oracle Essbase is dependent on whether you select BSO or ASO cubes. First, you need to set up the type of information and once the type of cubes is defined, you need to define ...
 

Also Known As

Databricks Unified Analytics, Databricks Unified Analytics Platform, Redash
Essbase
 

Overview

 

Sample Customers

Elsevier, MyFitnessPal, Sharethrough, Automatic Labs, Celtra, Radius Intelligence, Yesware
CHU de Rennes, Bellco Credit Union, Akindo Sushiro Co. Ltd, Deutsche Telekom AG, Samarco MineraÊo S.A., PCCW Ltd., QDQ media S.A.U., Boiron Italia, Specialized Bicycle Components Inc., Akindo Sushiro Co. Ltd., Air Canada, Daelim Industrial Co. Ltd.
Find out what your peers are saying about Snowflake Computing, Microsoft, Google and others in Cloud Data Warehouse. Updated: October 2025.
868,787 professionals have used our research since 2012.