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

IBM InfoSphere Optim 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

IBM InfoSphere Optim
Ranking in Database Development and Management
16th
Average Rating
6.6
Reviews Sentiment
6.1
Number of Reviews
3
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
14
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of May 2025, in the Database Development and Management category, the mindshare of IBM InfoSphere Optim is 2.5%, up from 2.2% compared to the previous year. The mindshare of Oracle Essbase is 1.0%, up from 0.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management
 

Featured Reviews

Ajai Lal - PeerSpot reviewer
Very supportive of Db2 and easy to customize, but IMS features are not user friendly and the support of these features is lacking
We work on two different types of databases, one being IMS and the other Db2. While the solution is very supportive of Db2, it is not so friendly when it comes to IMS databases. When we had questions for the support team conerning the IMS database, we found their knowledge to be lacking, likely owing to lack of experience on their part. I would not say that the initial setup is complex. Neither would I say that it is straightforward. Certain features require technical knowledge.
RANOJOY PAUL - PeerSpot reviewer
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.

Quotes from Members

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

Pros

"We like that we can easily restore the database with just a few clicks. The database is linked as well."
"I feel the solution to be a bit faster than the traditional methods, which makes it easy to customize."
"Essbase is extremely stable and low-maintenance."
"It is very fast compared to other normal databases, like SQL and MySQL."
"The solution is stable and reliable."
"Essbase is a kind of backbone, or back end, for systems like Hyperion Planning."
"Oracle Essbase is a web integration system that integrates with other data systems."
"I have found the most valuable aspect is the user-friendly environment and current features."
"The solution is scalable."
"It helps us fetch specific data sets per users' requirements."
 

Cons

"We're looking for a solution that can be implemented on AWS. IBM InfoSphere Optim can be implemented on AWS, but it costs more than double what we're currently paying. So, it's not really of good value for us."
"While the solution is very supportive of Db2, it is not so friendly when it comes to IMS databases."
"It's an expensive product to use."
"The reporting tool of Essbase needs improvement."
"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."
"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"There is room for improvement in terms of cost-effectiveness."
"I would like to see an integration with application performance management and a version control management tool."
 

Pricing and Cost Advice

"IBM InfoSphere Optim is a very expensive solution. Actually, it's the most expensive archiving solution that we have."
"Essbase is competitively priced."
"It is a costly solution."
"The solution is expensive."
"I believe the licensing is on a monthly base."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
849,963 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
26%
Insurance Company
8%
Healthcare Company
8%
Computer Software Company
7%
Financial Services Firm
22%
Computer Software Company
12%
Manufacturing Company
7%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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

Also Known As

IBM Optim, Optim
Essbase
 

Overview

 

Sample Customers

Durham Police Department, Coca-Cola Enterprises Inc., Continental, KCE Electronics Public Company Limited, The University of Adelaide, Migros Zurich, COPROB
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 IBM InfoSphere Optim vs. Oracle Essbase and other solutions. Updated: April 2025.
849,963 professionals have used our research since 2012.