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

CA IDMS vs Oracle Essbase comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 23, 2025

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

CA IDMS
Ranking in Database Development and Management
30th
Average Rating
9.0
Reviews Sentiment
7.8
Number of Reviews
5
Ranking in other categories
No ranking in other categories
Oracle Essbase
Ranking in Database Development and Management
12th
Average Rating
8.2
Reviews Sentiment
4.6
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2025, in the Database Development and Management category, the mindshare of CA IDMS is 1.2%, up from 0.7% compared to the previous year. The mindshare of Oracle Essbase is 0.9%, down from 1.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management Market Share Distribution
ProductMarket Share (%)
Oracle Essbase0.9%
CA IDMS1.2%
Other97.9%
Database Development and Management
 

Featured Reviews

AS
Helps us to manage user profiles very quickly and in an assertive way
I would rate this solution 9 out of 10. I would advise that they should evaluate other possibilities because this is a very quickly changing environment and there are other possible providers that have good solutions. I would do some kind of test. I would test other possible solutions too and compare them.
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

"It is a really stable platform. It has been around for many years. We trust it implicitly. ​"
"Technical support is very good. They are very knowledgeable, very quick to respond, and very nice people, too.​"
"The most useful feature is the governance feature, because it can show us and help us to manage user profiles very quickly and using it in assertive way."
"Essbase is extremely stable and low-maintenance."
"It is highly efficient and easily scalable, particularly for handling large databases."
"The solution is scalable."
"I have found the most valuable aspect is the user-friendly environment and current features."
"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."
"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."
"Oracle Essbase is a web integration system that integrates with other data systems."
"It is very fast compared to other normal databases, like SQL and MySQL."
 

Cons

"Right now, it's not easy to start using this solution. You have to take long course and train people. It's not an easy path."
"​I would like to see it made simpler to operate and maintain."
"Essbase has a programming language, and it has a couple of functions to do forecasting, however, their feature set for that is not that good."
"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 consolidation engine, which is HFM or FCCS, needs some room for improvement."
"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 solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"The reporting tool of Essbase needs improvement."
"It's an expensive product to use."
 

Pricing and Cost Advice

"Do not hold back on asking questions about the maintenance and continued support of the product."
"The solution is expensive."
"I believe the licensing is on a monthly base."
"Essbase is competitively priced."
"It is a costly solution."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
872,922 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Manufacturing Company
10%
Government
10%
University
8%
Financial Services Firm
21%
Computer Software Company
9%
Insurance Company
9%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise1
Large Enterprise14
 

Questions from the Community

Ask a question
Earn 20 points
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

IDMS
Essbase
 

Overview

 

Sample Customers

Blue Hill Data Services Inc.
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 CA IDMS vs. Oracle Essbase and other solutions. Updated: November 2025.
872,922 professionals have used our research since 2012.