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.0
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.6% compared to last year.
Oracle Essbase, on the other hand, focuses on Database Development and Management, holds 0.8% mindshare, down 1.1% since last year.
Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
Databricks8.3%
Snowflake17.7%
Dremio9.4%
Other64.6%
Cloud Data Warehouse
Database Development and Management Market Share Distribution
ProductMarket Share (%)
Oracle Essbase0.8%
SolarWinds Database Performance Analyzer6.6%
Redgate SQL Toolbelt Essentials6.0%
Other86.6%
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

"The solution offers a free community version."
"I like the ability to use workspaces with other colleagues because you can work together even without seeing the other team's job."
"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 integration with Python and the notebooks really helps."
"Its lightweight and fast processing are valuable."
"The notebooks and the ability to share them with collaborators are valuable, as multiple developers can use a single cluster."
"The most valuable features of the solution are the hardware and the resources it quickly provides without much hassle."
"When we have a huge volume of data that we want to process with speed, velocity, and volume, we go through Databricks."
"It helps us fetch specific data sets per users' requirements."
"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."
"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."
"I have found the most valuable aspect is the user-friendly environment and current features."
"It's a very powerful analytical engine with Essbase as the back end. We can analyze, transform, or utilize a big chunk of data for our calculations."
"The solution can handle a large volume of data."
"The solution is stable and reliable."
 

Cons

"The stability of the clusters or the instances of Databricks would be better if it was a much more stable environment. We've had issues with crashes."
"We often use a single cluster to ingest Databricks, which Databricks doesn't recommend. They suggest using a no-cluster solution like job clusters. This can be overwhelming for us because we started smaller."
"There is room for improvement in visualization."
"Databricks has added some alerts and query functionality into their SQL persona, but the whole SQL persona, which is like a role, needs a lot of development. The alerts are not very flexible, and the query interface itself is not as polished as the notebook interface that is used through the data science and machine learning persona. It is clunky at present."
"Databricks would benefit from enhanced metrics and tighter integration with Azure's diagnostics."
"As a data engineer, I see cluster failure in our Databricks user databases as a major issue."
"The product could be improved regarding the delay when switching to higher-performing virtual machines compared to other platforms."
"I would like it if Databricks adopted an interface more like R Studio. When I create a data frame or a table, R Studio provides a preview of the data. In R Studio, I can see that it created a table with so many columns or rows. Then I can click on it and open a preview of that data."
"The ability to drive external reporting out for development could be improved."
"It's an expensive product to use."
"There is room for improvement in terms of cost-effectiveness."
"The main concern is that Oracle is ending on-premises server support, so it would be better if there was a cloud platform available for Oracle Essbase."
"The initial setup is pretty complex."
"They should improve the solution's performance."
"The initial setup could be simplified."
"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."
 

Pricing and Cost Advice

"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 am based in South Africa, where it is expensive adapting to the cloud, and then there is the price for the tool itself."
"The solution is a good value for batch processing and huge workloads."
"The solution is affordable."
"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."
"Databricks are not costly when compared with other solutions' prices."
"The licensing costs of Databricks depend on how many licenses we need, depending on which Databricks provides a lot of discounts."
"The licensing costs of Databricks is a tiered licensing regime, so it is flexible."
"Essbase is competitively priced."
"I believe the licensing is on a monthly base."
"The solution is expensive."
"It is a costly solution."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
867,370 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
10%
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: August 2025.
867,370 professionals have used our research since 2012.