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
33rd
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
9th
Average Rating
8.0
Reviews Sentiment
4.6
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of September 2025, in the Database Development and Management category, the mindshare of CA IDMS is 1.1%, up from 0.6% compared to the previous year. The mindshare of Oracle Essbase is 0.8%, down from 1.1% 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.8%
CA IDMS1.1%
Other98.1%
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. ​"
"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."
"Technical support is very good. They are very knowledgeable, very quick to respond, and very nice people, too.​"
"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."
"Oracle Essbase is a web integration system that integrates with other data systems."
"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 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."
"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."
"The solution can handle a large volume of data."
"The solution is scalable."
 

Cons

"​I would like to see it made simpler to operate and maintain."
"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."
"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 could be simplified."
"The reporting tool of Essbase needs improvement."
"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"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."
"I would like to see an integration with application performance management and a version control management tool."
"They should improve the solution's performance."
 

Pricing and Cost Advice

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

Top Industries

By visitors reading reviews
Financial Services Firm
21%
Government
11%
Manufacturing Company
10%
Computer Software Company
7%
Financial Services Firm
21%
Computer Software Company
9%
Insurance Company
8%
Retailer
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: September 2025.
867,676 professionals have used our research since 2012.