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

IDERA ER/Studio vs Oracle Coherence 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.2
Number of Reviews
39
Ranking in other categories
Enterprise Architecture Management (7th)
Oracle Coherence
Ranking in Database Development and Management
16th
Average Rating
7.8
Reviews Sentiment
5.8
Number of Reviews
31
Ranking in other categories
In-Memory Data Store Services (4th)
 

Mindshare comparison

As of March 2026, in the Database Development and Management category, the mindshare of IDERA ER/Studio is 2.4%, down from 2.8% compared to the previous year. The mindshare of Oracle Coherence is 2.4%, up from 2.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management Mindshare Distribution
ProductMindshare (%)
IDERA ER/Studio2.4%
Oracle Coherence2.4%
Other95.2%
Database Development and Management
 

Featured Reviews

reviewer2796111 - PeerSpot reviewer
Data Architect at a financial services firm with 10,001+ employees
Improved data modeling has reduced system footprint and strengthened finance workflows
I assess the benefits of IDERA ER_Studio's metadata management for my organization as not as good as Erwin's. Erwin's metadata management is better in how it handles data. There is a lot more user involvement in managing the metadata, primarily because in IDERA ER_Studio, the logical and physical models are separately defined in the same file, so you have to map them every single time. In Erwin, it has a unified structure, so if you make a change in the logical model, it automatically shows up in the physical model. You have to go through a couple of steps in the IDERA model to make sure everything has moved over. While that is not that inconvenient when you are actually doing development, as far as metadata management, that is prone to things getting dropped and missed. The collaboration tools in IDERA ER_Studio are adequate, but I think with Erwin, there is more of an opportunity for things to crash. Changes can be merged in IDERA more fluidly; however, the locking and sharing are a little bit more defined in Erwin. I think the learning curve for Erwin might be easier than IDERA ER_Studio, especially with connecting to different models and systems.
SS
Data Engineer at a financial services firm with 10,001+ employees
Facilitating real-time business insights with enhanced data querying
Coherence is beneficial due to its multi-indexing to the same object and filtering based on data attributes within the object, followed by aggregation. These features facilitate querying data with multiple keys rather than just a single key. Its real-time data processing capabilities provide insights for business decisions with up-to-date information.

Quotes from Members

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

Pros

"This has helped the new application development team in cross-verifying, and understanding, the current setup, proposing and architecting new solutions for the organisation."
"The reverse engineering is the most important feature."
"Customer Service: It's good."
"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."
"I set up this tool and found it to be very simple."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"It does the job."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"The Customer Facing Application response time has been improved 95%."
"Oracle Coherence is a very good product which helps to create internet-scale applications using a high-performance grid."
"The biggest improvement is in speed - everything is faster from record retrieval to workflow processing."
"Oracle Coherence improved site performance and the customer experience."
"It has allowed us to greatly improve our response times in several services by caching part of the database into Coherence and executing complex queries using EntryProcessors."
"The product is great, simple, and easy to use and integrate."
"It helped us to cache the data in memory and improved performance by 10x."
"Other technologies don’t allow the same level of scale and compute capability, while providing rigorous resilience and security underpinnings."
 

Cons

"I assess the benefits of IDERA ER_Studio's metadata management for my organization as not as good as Erwin's."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"Diagram versioning is not very intuitive Data Dictionary Bindings is not very intuitive"
"Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response."
"I cannot evaluate any areas for improvement at this time."
"The deployment and licensing facets of this product are beyond maddening, requiring even small organizations such as ours to install and maintain two server apps to handle real-time license enforcement and centralized (Tool Cloud) product launching."
"This version does not properly generate SQL Server computed columns; future versions do this."
"This platform has issues with stability and performance."
"I would like to see a more modern API like Hazelcast or Infinispan."
"Due to the licensing prices, we are looking for other solutions as an alternative to Coherence."
"Initial setup is very complex; specifically, a lot of XML effort is required."
"Technical support is 3 or even 2 out of 10. Working directly through an account rep or a contact on Coherence dev team helps a lot."
"Monitoring API needs to be improved and needs to be user friendly. Also, the error and exception handling is not that great as it can be difficult to debug issues."
"We have encountered the occasional minor bug and very occasional more serious bug."
"Configuration is too complex."
 

Pricing and Cost Advice

"The solution’s pricing is high."
"I am currently using the trial version, but this solution is definitely worth considering for the price point."
"The setup cost may have been around $1500 to $2000."
"On a scale of one to ten, where one is bad and ten is good, I would rate the licensing cost as a seven or eight. It's not too expensive for us."
"As an individual user, the renewal is a little costly."
"I use the product's trial version."
"The process of licensing could be much simpler, from our experience."
"Pricing is expensive and on the higher-end."
Information not available
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
884,873 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Energy/Utilities Company
13%
Financial Services Firm
12%
Manufacturing Company
8%
Computer Software Company
7%
Financial Services Firm
32%
Computer Software Company
8%
Performing Arts
6%
Comms Service Provider
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Midsize Enterprise12
Large Enterprise25
By reviewers
Company SizeCount
Small Business5
Midsize Enterprise3
Large Enterprise23
 

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 work in the finance industry, and the use cases for this product are very similar to what I mentioned previously when I discussed being in industrial management. It is simply a different product.
What advice do you have for others considering IDERA ER Studio?
I have not used IDERA ER_Studio's impact analysis tools, so I really could not judge that regarding mitigating database risks for security. I am not on the end as far as the pricing, as this is wha...
What needs improvement with Oracle Coherence?
The WebLogic Management is quite cumbersome. The initial setup is complex and time-consuming.
What is your primary use case for Oracle Coherence?
I utilize Coherence for data solutions in the financial industry. Its primary use case includes plain lookup, indexing, filtering, and aggregation.
What advice do you have for others considering Oracle Coherence?
I recommend Coherence, as I don't have any product issues. The main concerns are high pricing and a complex initial setup. Overall, I would rate Coherence as an eight out of ten.
 

Also Known As

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

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
Industrial Bank of Korea, Hotelbeds, Canon Inc., Verizon, Securitas Direct Espa_a, S.A.U., CetelemEspa_aGrupo BNP Paribas, Telus
Find out what your peers are saying about IDERA ER/Studio vs. Oracle Coherence and other solutions. Updated: March 2026.
884,873 professionals have used our research since 2012.