IDERA ER/Studio vs Oracle Coherence comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IDERA ER/Studio
Ranking in Database Development and Management
14th
Average Rating
8.4
Number of Reviews
34
Ranking in other categories
Enterprise Architecture Management (10th)
Oracle Coherence
Ranking in Database Development and Management
22nd
Average Rating
7.8
Number of Reviews
30
Ranking in other categories
In-Memory Data Store Services (9th)
 

Market share comparison

As of June 2024, in the Database Development and Management category, the market share of IDERA ER/Studio is 1.8% and it decreased by 25.1% compared to the previous year. The market share of Oracle Coherence is 1.1% and it increased by 91.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Database Development and Management
Unique Categories:
Enterprise Architecture Management
5.8%
In-Memory Data Store Services
6.4%
 

Featured Reviews

AndersonMoura - PeerSpot reviewer
Oct 19, 2022
The solution has important reverse engineering features, but it needs a single sign-on feature
With ER/Studio, the roadmap to send us new versions with the new database is slow. I think it could allow us to test and use new database versions faster. Sometimes we get new functionalities like, for example, the Collibra integration. We receive these new functionalities, and sometimes we start to test them and we find errors that we need to correct by talking with tech support. I think they allow functionalities to be released before the full tests for catching and correcting errors are completed. My other point is about the team server. We're using the web portal, and the interface is not so good. The client was modified, and we have the new version. It's good. The client is good to us, but the web portal is using the old UI. It's not as modern, and it's limited. We found that the new version is slow when compared to the older version. We are trying to investigate what component is causing the slowness, because you have the client access, the repository, the API, the team server, and the web portal. Getting a single sign-on feature is very important to us.
it_user514590 - PeerSpot reviewer
Sep 19, 2016
Pro-active caching improved risk calculation time and allowed the risk grid to scale with volume growth.
Oracle Coherence is mature and feature-rich product. However, there are a few old pain points. One pain point is cluster configuration. On complex projects, it is a challenge to consistently maintain custom Coherence XML and the rest of application configuration (often based on a Spring framework). Another pain point is testing. Due to internal implementation, it is impossible to start multiple Coherence nodes in a single JVM without special tricks. Multi-node test setup is important if the application is exploiting advanced features of the product. This is somehow addressed by the community (there are three open-source frameworks for testing Coherence), but the problem could have been solved by Oracle once and for all.

Quotes from Members

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

Pros

"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."
"The tool is simple to use."
"The reverse engineering is the most important feature."
"Technical support from Oracle is okay."
 

Cons

"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"The screens are a bit outdated. They could use a new look and feel."
"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."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"The number of options can be overwhelming at times. That is not necessarily a bad thing but for a newbie, it can be daunting."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"The solution's reporting could be improved because the report writer is terrible."
"This platform has issues with stability and performance."
 

Pricing and Cost Advice

"I use the product's trial version."
"At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product."
"Pricing is expensive and on the higher-end."
"It is priced fairly. It's around the same as erwin and other competitors' costs."
"I am currently using the trial version, but this solution is definitely worth considering for the price point."
"The price of this product is okay."
"The process of licensing could be much simpler, from our experience."
"I feel the product's pricing is a good value."
Information not available
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
787,226 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Computer Software Company
12%
Government
10%
Manufacturing Company
9%
Financial Services Firm
36%
Computer Software Company
10%
University
7%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What needs improvement with IDERA ER/Studio?
The solution's reporting could be improved because the report writer is terrible. Writing definitions and not being able to generate a nice report to view is useless. To me, that's a huge problem.
Ask a question
Earn 20 points
 

Also Known As

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

Learn More

 

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: May 2024.
787,226 professionals have used our research since 2012.