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

CA Database Management for DB2 for zOS 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 Database Management for ...
Ranking in Database Development and Management
18th
Average Rating
8.8
Reviews Sentiment
8.2
Number of Reviews
13
Ranking in other categories
No ranking in other categories
Oracle Essbase
Ranking in Database Development and Management
11th
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 August 2025, in the Database Development and Management category, the mindshare of CA Database Management for DB2 for zOS is 0.7%, up from 0.4% compared to the previous year. The mindshare of Oracle Essbase is 0.9%, down from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management
 

Featured Reviews

JG
Report generation offers invaluable insights into database performance
I basically use the solution for database management and to view the performance of a particular database object, any specific program, batch program, or online programs. Using the CSSZ tool, I can effectively monitor performance. In case of an exception, I can inform the application team. At DB2…
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

"Improved monitoring and performance management."
"It takes advantage of new features of DB2."
"​It is very stable. We have had no issues."
"The reports generated and the old statistics shown are really helpful."
"The most important features are batch reporting and the ability to create repositories, enabling automated analysis. These are valuable because they enable me to do automated analysis of trends over time and reduce the time for comparing performance between two periods to identify anomalies."
"​It helps us to reduce hardware costs and to optimize processing times.​"
"It is very fast compared to other normal databases, like SQL and MySQL."
"I have found the most valuable aspect is the user-friendly environment and current features."
"The solution is stable and reliable."
"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."
"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."
"Essbase is extremely stable and low-maintenance."
"It is highly efficient and easily scalable, particularly for handling large databases."
"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."
 

Cons

"All the information we need, we could use to have it in a more usable format.​"
"They need to provide a way to create and maintain performance repositories. The online tool is not perfect, but it is giving me what I need."
"Minor stability issues."
"In the case of any particular SQL which is executing for a longer time and causing issues with any particular store or DB2 programs, if it could pinpoint the problems like any other tool should do, that would be really helpful."
"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 ability to drive external reporting out for development could be improved."
"The initial setup is pretty complex."
"They should improve the solution's performance."
"It's an expensive product to use."
"The initial setup could be simplified."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"There is room for improvement in terms of cost-effectiveness."
 

Pricing and Cost Advice

Information not available
"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 Database Development and Management solutions are best for your needs.
865,384 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
22%
Computer Software Company
10%
Insurance Company
8%
Retailer
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What needs improvement with CA Database Management for DB2 for zOS?
In the case of any particular SQL which is executing for a longer time and causing issues with any particular store or DB2 programs, if it could pinpoint the problems like any other tool should do,...
What is your primary use case for CA Database Management for DB2 for zOS?
I basically use the solution for database management and to view the performance of a particular database object, any specific program, batch program, or online programs. Using the CSSZ tool, I can...
What advice do you have for others considering CA Database Management for DB2 for zOS?
The solution operates on JetOS platform. It is a very good, perfect solution. I would rate it ten out of ten. Currently, I do not have any planning for investment at all.
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?
Improvements for Oracle Essbase could be made, as there are many tools available now, such as FCCS, TRCS, and ERCS. I find managing the database difficult, especially regarding optimization and dat...
What is your primary use case for Oracle Essbase?
I have been using Oracle Essbase for the last thirteen years and I am into this space for thirty years. I am working on the sales-based platform where I work with different clients for GE, Thomson ...
 

Also Known As

CA Database Management Solutions for DB2 for z/OS
Essbase
 

Overview

 

Sample Customers

Blue Hill Data Services
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 Database Management for DB2 for zOS vs. Oracle Essbase and other solutions. Updated: July 2025.
865,384 professionals have used our research since 2012.