IDERA ER/Studio vs Toad Data Modeler 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)
Toad Data Modeler
Ranking in Database Development and Management
11th
Average Rating
8.4
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of June 2024, in the Database Development and Management category, the mindshare of IDERA ER/Studio is 1.8%, down from 2.4% compared to the previous year. The mindshare of Toad Data Modeler is 5.0%, up from 1.4% 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%
No other categories found
 

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.
MG
Jun 20, 2023
Along with an initial setup that is straightforward, the solution offers excellent support to users
I can speak about its functionality but can't talk about it from a technical perspective. It's not for me. As far as I know, it's easy. Everybody with a database uses Toad After-sales from Quest for the company because when it comes to the renewal price, we are not able to negotiate with them.…

Quotes from Members

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

Pros

"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."
"The data modeling and reverse engineering features are most important to us."
"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 data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth."
"The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"It is not feasible for small businesses. It is not used in a small company."
"Auto-complete is the best feature of the solution."
"I found all features valuable and necessary in Toad Data Modeler, particularly how good the solution is for modeling, database schema generation, and database re-engineering. I also found Toad Data Modeler straightforward to use."
 

Cons

"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"The screens are a bit outdated. They could use a new look and feel."
"When building the relationships there should be a little more flexibility."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"This solution needs more precise documentation."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"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"
"It is not feasible for small businesses. It is not used in a small company."
"The product should provide better debugging features."
"Many users don't know how to add licensing to Toad, or where it is shown, so they could make that easier."
"What could be improved in Toad Data Modeler is stability and the complex setup."
 

Pricing and Cost Advice

"Pricing is expensive and on the higher-end."
"It is priced fairly. It's around the same as erwin and other competitors' costs."
"The price of this product is okay."
"As an individual user, the renewal is a little costly."
"I am currently using the trial version, but this solution is definitely worth considering for the price point."
"At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product."
"The process of licensing could be much simpler, from our experience."
"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."
"Price-wise, the lesser it is, the better it is for me, especially in Egypt. I think that the licensing cost ranges from 1,000 to 9,000. Also, it includes maintenance and support for a year."
"Though I'm not involved in the licensing for Toad Data Modeler, I believe it's per user and not cheap."
report
Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
787,779 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
18%
Government
15%
Computer Software Company
9%
Manufacturing Company
8%
 

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.
What do you like most about Toad Data Modeler?
Auto-complete is the best feature of the solution.
What needs improvement with Toad Data Modeler?
The query and design could be improved. The product should provide better debugging features. It should also be easy to set up.
 

Also Known As

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

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
Zions Bancorporation
Find out what your peers are saying about IDERA ER/Studio vs. Toad Data Modeler and other solutions. Updated: May 2024.
787,779 professionals have used our research since 2012.