We performed a comparison between IDERA ER/Studio and Toad Data Modeler based on real PeerSpot user reviews.
Find out in this report how the two Database Development and Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"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."
"Valuable features include the ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used."
"It's easy to model and has a user-friendly interface. I like the team portal because, once we upload, the entire team can see the model."
"The reverse engineering is the most important feature."
"It is not feasible for small businesses. It is not used in a small company."
"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."
"Auto-complete is the best feature of the solution."
"This solution needs more precise documentation."
"When building the relationships there should be a little more flexibility."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"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."
"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 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."
"What needs the most improvement are semantic lineage and usability."
"The screens are a bit outdated. They could use a new look and feel."
"It is not feasible for small businesses. It is not used in a small company."
"What could be improved in Toad Data Modeler is stability and the complex setup."
"Many users don't know how to add licensing to Toad, or where it is shown, so they could make that easier."
"The product should provide better debugging features."
IDERA ER/Studio is ranked 13th in Database Development and Management with 33 reviews while Toad Data Modeler is ranked 9th in Database Development and Management with 18 reviews. IDERA ER/Studio is rated 8.4, while Toad Data Modeler is rated 8.4. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". On the other hand, the top reviewer of Toad Data Modeler writes "Along with an initial setup that is straightforward, the solution offers excellent support to users". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Sparx Systems Enterprise Architect, erwin Evolve by Quest and LeanIX, whereas Toad Data Modeler is most compared with Oracle SQL Developer, Aqua Data Studio, Redgate SQL Toolbelt, Toad Edge and Toad for Oracle. See our IDERA ER/Studio vs. Toad Data Modeler report.
See our list of best Database Development and Management vendors.
We monitor all Database Development and Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.