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

IDERA ER/Studio 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

IDERA ER/Studio
Ranking in Database Development and Management
8th
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
38
Ranking in other categories
Enterprise Architecture Management (7th)
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 IDERA ER/Studio is 3.0%, up from 2.3% 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

Aaron Cutshall - PeerSpot reviewer
Used for data modeling and has a scripting language to write your own scripts
The solution has streamlined our data modeling processes quite a bit. It's a central focus in our data modeling and data cataloging efforts. The tool's reverse engineering capability to bring in existing database structures and create models from them has benefitted our data architecture needs. With the tool's data dictionary capability, we're able to maintain consistency in our models, name use, and actual data domains. The solution's reverse engineering helps with understanding legacy databases. In fact, I've been asked to reverse-engineer several more legacy databases so that we can have them modeled and cataloged. The solution is deployed on the cloud server, but it’s only within our network. The solution has a lot of capabilities. I like the fact that it has a scripting language that allows you to automate and write your own scripts. I think that's been a big bonus for us. I highly recommend the solution because of its capability for logical models, where you can put your business definitions and logic. While less expensive, some other tools can't do that. Overall, I rate the solution an eight out of ten.
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

"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"The most valuable feature of the solution is generating DDL (data definition language)."
"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"I would 100% recommend the product."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"I have found the most valuable aspect is the user-friendly environment and current features."
"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."
"The solution is scalable."
"It is highly efficient and easily scalable, particularly for handling large databases."
"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."
"The solution can handle a large volume of data."
"It is very fast compared to other normal databases, like SQL and MySQL."
"It helps us fetch specific data sets per users' requirements."
 

Cons

"The solution's reporting could be improved because the report writer is terrible."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization"
"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."
"We would always like to see Repository performance improve, checking in and checking out."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"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."
"The initial setup could be simplified."
"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."
"There is room for improvement in terms of cost-effectiveness."
"They should improve the solution's performance."
"The ability to drive external reporting out for development could be improved."
 

Pricing and Cost Advice

"The process of licensing could be much simpler, from our experience."
"Pricing is expensive and on the higher-end."
"I use the product's trial version."
"I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."
"The price of this product is okay."
"I am currently using the trial version, but this solution is definitely worth considering for the price point."
"The solution’s pricing is high."
"I feel the product's pricing is a good value."
"It is a costly solution."
"The solution is expensive."
"I believe the licensing is on a monthly base."
"Essbase is competitively priced."
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
Financial Services Firm
14%
Energy/Utilities Company
11%
Computer Software Company
9%
Government
8%
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 is your experience regarding pricing and costs for IDERA ER Studio?
In terms of pricing, ER/Studio is slightly more expensive compared to Erwin, by about five to ten percent.
What is your primary use case for IDERA ER Studio?
I have been working with data modeling tools. Personally, I have been working with Erwin for many years now. ER/Studio is something I am currently trying to evaluate for acquiring it for our organi...
What advice do you have for others considering IDERA ER Studio?
I would strongly recommend ER/Studio for large teams. Erwin is a very stable product, but for smaller teams, it's okay. If I had to rate ER/Studio, I would give it nine out of ten because the absen...
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

IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
Essbase
 

Overview

 

Sample Customers

Newmont Mining, Entrust, Accolade, TalkTalk, Catalina, Protective Life, NTT Data, dir systèmes, Microsoft; American Express, Astellas Pharma, AstraZeneca, Coriant, Fedex, GlaxoSmithKline, PepsiCo, Prudential, Wells Fargo
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 IDERA ER/Studio vs. Oracle Essbase and other solutions. Updated: July 2025.
865,384 professionals have used our research since 2012.