CA Database Management for DB2 for zOS vs Oracle Essbase comparison

Broadcom and Oracle are both solutions in the Database Development and Management category. Broadcom is ranked #19 with an average rating of 10.0, while Oracle is ranked #12 with an average rating of 8.6. Broadcom holds a 0.3% mindshare in DDM, compared to Oracle’s 1.0% mindshare. Additionally, 100% of Broadcom users are willing to recommend the solution, compared to 100% of Oracle users who would recommend it.

CA Database Management for ...

Read 13 CA Database Management for DB2 for zOS reviews

157 Views
53 Comparison Views

100% willing to recommend

Oracle Essbase

Read 14 Oracle Essbase reviews

136 Views
95 Comparison Views

100% willing to recommend

CA Database Management for ...

Oracle Essbase

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Jan 23, 2025

Oracle Essbase and CA Database Management for DB2 for zOS compete in business intelligence and database management, respectively. Oracle Essbase has an edge in analytics, while CA Database Management for DB2 for zOS excels in robust database administration.

Features: Oracle Essbase offers multi-dimensional analytics, flexible data visualization, and a powerful calculation engine. CA Database Management for DB2 for zOS provides extensive database monitoring, automation features, and insights into system performance.

Room for Improvement: Oracle Essbase could enhance its initial configuration process, scalability, and user interface for non-technical users. CA Database Management for DB2 for zOS may need to improve ease of use for less experienced users, integration with non-zOS environments, and support for more modern database technologies.

Ease of Deployment and Customer Service: Oracle Essbase supports both cloud and on-premises deployments with reputed customer service. CA Database Management for DB2 for zOS is optimized for the zOS environment, providing seamless integration and specialized mainframe support.

Pricing and ROI: Oracle Essbase involves higher initial costs but offers significant ROI through its analytics capabilities. CA Database Management for DB2 for zOS has a cost-effective setup designed for long-term value, delivering competitive ROI for enterprises using mainframes.

To learn more, read our detailed CA Database Management for DB2 for zOS vs. Oracle Essbase Report (Updated: April 2025).

Buyer's Guide

CA Database Management for DB2 for zOS vs. Oracle Essbase

April 2025

Download the complete report

Helped 845,564 peers since 2012

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

19th

Average Rating

8.8

Reviews Sentiment

8.2

Number of Reviews

Ranking in other categories

No ranking in other categories

Oracle Essbase

Ranking in Database Development and Management

12th

Average Rating

8.4

Reviews Sentiment

5.5

Number of Reviews

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of April 2025, in the Database Development and Management category, the mindshare of CA Database Management for DB2 for zOS is 0.3%, down from 0.6% compared to the previous year. The mindshare of Oracle Essbase is 1.0%, up from 0.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Database Development and Management

Featured Reviews

JOY GHARAMI

Technical Project Manager at Interra Information Technologies, Inc.

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…

Read full review

RANOJOY PAUL

Analyst at Tata Consultancy

Stores multidimensional data, good customer support and interface is very easy

It is very fast compared to other normal databases, like SQL and MySQL. It doesn't store data in tables in the back end. To load data into Essbase, we need to prepare it in a table format. When we find the data in the table, we need to verify it. This way, you can rate the data. But Essbase stores multidimensional data. We have dimensions, which means the data belongs to some company or some time period. For example, if you work for three years, your salary should be something. In this way, we prepare top-level members called dimensions. The dimension defines your position, the year, and the section you were working in the company. We get an intersection of all these dimensions for certain data, and fetching that data is very fast in Essbase compared to normal SQL. If you store this data in a normal SQL table, you need to prepare a row with your company name, employee name, employee ID, joining date, and everything, and then you need to push it into a SQL table. You can search it using your query, but here, that thing is different. Here, you can collect data using forms, reports, and we use a Microsoft tool, which is an add-in called Smart View. Using that, you would just take that data. Here, you need to just create an integration of all these dimensions, and then only you can find the data.

Read full review

Quotes from Members

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

Pros

"It helps us to reduce hardware costs and to optimize processing times."

"The reports generated and the old statistics shown are really helpful."

"It is very stable. We have had no issues."

"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 takes advantage of new features of DB2."

"Improved monitoring and performance management."

"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."

"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."

"The solution is scalable."

"Oracle Essbase is a web integration system that integrates with other data systems."

"The solution can handle a large volume of data."

"Essbase is extremely stable and low-maintenance."

"It is very fast compared to other normal databases, like SQL and MySQL."

"It helps us fetch specific data sets per users' requirements."

More Oracle Essbase pros

Cons

"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."

"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."

"All the information we need, we could use to have it in a more usable format."

"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."

"The consolidation engine, which is HFM or FCCS, needs some room for improvement."

"I would like to see an integration with application performance management and a version control management tool."

"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."

"There is room for improvement in terms of cost-effectiveness."

"The initial setup could be simplified."

"The ability to drive external reporting out for development could be improved."

"The initial setup is pretty complex."

More Oracle Essbase cons

Pricing and Cost Advice

Information not available

"It is a costly solution."

"The solution is expensive."

"Essbase is competitively priced."

"I believe the licensing is on a monthly base."

See which vendors are best for you

Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.

See recommendations

845,564 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

23%

Computer Software Company

12%

Manufacturing Company

Insurance Company

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,...

See all answers

What is your primary use case for CA Database Management for DB2 for zOS?

See all answers

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.

See all answers

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.

See all answers

What needs improvement with Oracle Essbase?

If I got the opportunity to work with Hyperion, which is the best product, I would definitely go with that. The main concern is that Oracle is ending on-premises server support, so it would be bett...

See all answers

What is your primary use case for Oracle Essbase?

We provide complete ownership of this application to Walmart projects. In the UK system, we support and develop for the Asda account, known as Eltham. We provide installation and support to over 50...

See all answers

Comparisons

No data available

Microsoft Power BI vs Oracle Essbase

Compared 30% of the time

SAP BusinessObjects Business Intelligence Platform vs Oracle Essbase

Compared 16% of the time

SAP Analytics Cloud vs Oracle Essbase

Compared 14% of the time

IBM Planning Analytics vs Oracle Essbase

Compared 7% of the time

Tableau vs Oracle Essbase

Compared 6% of the time

More Oracle Essbase Competitors

Product Reports

Buyer's Guide

Database Development and Management

March 2025

CA Database Management for DB2 for zOS report

Download CA Database Management for DB2 for zOS product report

Buyer's Guide

Oracle Essbase

March 2025

Download Oracle Essbase product report

Also Known As

CA Database Management Solutions for DB2 for z/OS

Essbase

Overview

Database Management for DB2 for z/OS solutions from CA Technologies provide a set of tools designed to ensure optimal database and SQL performance, efficient administration, and reliable backup and recovery of DB2 databases, systems and apps.

Broadcom

Oracle Essbase is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications.

Oracle

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.

Buyer's Guide

CA Database Management for DB2 for zOS vs. Oracle Essbase

April 2025

Free Report: CA Database Management for DB2 for zOS vs. Oracle Essbase

Find out what your peers are saying about CA Database Management for DB2 for zOS vs. Oracle Essbase and other solutions. Updated: April 2025.

DOWNLOAD NOW

845,564 professionals have used our research since 2012.

See our CA Database Management for DB2 for zOS vs. Oracle Essbase report.

See our list of best Database Development and Management vendors.

We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.