IDERA ER/Studio vs Toad for Oracle comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IDERA ER/Studio and Toad for Oracle 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.
To learn more, read our detailed IDERA ER/Studio vs. Toad for Oracle Report (Updated: March 2024).
765,234 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""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.""We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify.""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 data modeling and reverse engineering features are most important to us.""This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process.""The interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer.""One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."

More IDERA ER/Studio Pros →

"It is very easy to manage all of the objects.""The most valuable feature of Toad for Oracle is the fashion browser and the Schema browser. It is very complete.""Oracle has advanced query optimization and tuning features that help improve the performance of SQL queries.""I find Toad easy to use and I love the Workspace feature, which allows me to set up projects so that I can open SQL files applicable to what I am working on at any particular time.""The best product for working with Oracle databases for support, checking and loading data.""The product's most valuable features are UI and monitoring.""The tool evaluates non-optimized queries and generates the queries in a way that is more optimal - in addition to giving us some good practices for code development.""The most valuable feature is the navigation within the UI, where you can right-click on an object in an SQL query and go right to it, versus going through all of the menus to find what you are looking for."

More Toad for Oracle Pros →

Cons
"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""What needs the most improvement are semantic lineage and usability.""The visual presentation is a little too colorful and seems that it is dumbed down.""One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct.""Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business.""We would always like to see Repository performance improve, checking in and checking out.""The only thing I had an issue with was licensing, and the support was very good.""Sometimes our version is a little unstable. But I think this problem occurs because our version is old."

More IDERA ER/Studio Cons →

"Query optimization is still very resource-intensive.""I'd like reporting to be more available. If it was a feature that was already installed, more people would take advantage of it.""It would be better if they had an online option allowing me to connect from anywhere on any device. Sometimes I face some errors, depending on the network and setup. It's not a big issue.""Improvement wise, for the user it should show the minimum features on the screen and not all the features. Toad has a lot of features, but most users will use only 5 or 10 based on their role. Nobody needs all the features, and they should provide the option to choose only the required features. Only minimum requirements should be enabled by default. When all the features are shown, the performance is not good; it loads slowly and has hundreds of popups and unnecessary questions.""An area where the solution could use some improvement is in terms of user-friendliness. During the initial setup phase, the solution was not very intuitive when attempting to establish connections.""There may be an issue with processing limitations but this cannot be confirmed as a problem with the product or with the newest releases.""I would like to see an improvement in the performance because opening the browser and the editor should be faster.""Once in a while, I may encounter a memory exception and have to abort the application. On a few occasions, the file that stores the saved connections for the New Connection window will become corrupt and I will lose all of my saved connections. I am not sure if that is a Windows or TOAD issue, but it has happened to all of my developers at some point or another."

More Toad for Oracle Cons →

Pricing and Cost Advice
  • "The product is pricey."
  • "The process of licensing could be much simpler, from our experience."
  • "I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."
  • "I feel the product's pricing is a good value."
  • "Pricing is on point, but do your due diligence - not every developer needs the tool."
  • "As an individual user, the renewal is a little costly."
  • "Pricing is expensive and on the higher-end."
  • "At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product."
  • More IDERA ER/Studio Pricing and Cost Advice →

  • "There are paid and free-for-use versions of the product."
  • "The professional edition is about $1,000 AUD ($700 USD) and the developer version is about twice that much."
  • "In my opinion, this solution is a little expensive, but I understand that good programs cost more money."
  • "My advice is to try to use the three-year maintenance agreement if possible."
  • "Toad for Oracle has a relatively high cost compared to other similar tools."
  • "The product's pricing is just right because if it were slightly higher, it would not have been as widely adopted as it currently is in our organization."
  • "I would rate it six, where one is a low price, and ten is a high price."
  • "The pricing is okay, it's reasonable."
  • More Toad for Oracle Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
    765,234 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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
    Top Answer:The product's most valuable features are UI and monitoring.
    Top Answer:The pricing is okay, it's reasonable. I would rate the pricing a seven out of ten, where one is cheap and ten is expensive. It's a little bit on the pricey side.
    Top Answer:There could be a tool for automated SQL query functioning.
    Ranking
    Views
    477
    Comparisons
    344
    Reviews
    2
    Average Words per Review
    440
    Rating
    8.5
    Views
    2,028
    Comparisons
    888
    Reviews
    10
    Average Words per Review
    452
    Rating
    8.5
    Comparisons
    Also Known As
    IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
    Learn More
    Overview

    IDERA ER/Studio is a powerful suite for business-driven data modeling that enables companies to create an enterprise architecture foundation for data governance. With round-trip support for multiple database platforms, data architects have the power to reverse-engineer, analyze, and optimize existing databases easily from diverse platforms. Data professionals can easily capture and share models, metadata, data sources, and glossaries across the organization for improved alignment between the organization and Information Technology. Organizational stakeholders can take part in the metadata definition workflow and access information on models and metadata at the right level for their needs.

    Unlike its competition, it provides the broadest range of data platform support, industry-leading enterprise-level capabilities, visual data lineage and flow modeling, full dimensional modeling for data warehousing and business intelligence, and business data objects to bridge the gap between developers and data architects. It also provides a complete solution for enterprise architecture and data governance, extensive model change management, unique incorporation of true enterprise data dictionaries, unique linking of constructs across models, integrated visual data lineage import, and integrated data and business process modeling.

    With Toad for Oracle, you'll reduce costs and risks by easily ensuring the health and performance of your Oracle Cloud Platform and on-premises databases. ... On the operations side, you can automate administration tasks and proactively manage your databases while embracing performance optimization and risk mitigation.

    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
    intel, ebay, uber, mars, microsoft
    Top Industries
    REVIEWERS
    Government19%
    Financial Services Firm14%
    Healthcare Company14%
    Insurance Company10%
    VISITORS READING REVIEWS
    Financial Services Firm20%
    Computer Software Company10%
    Government10%
    Manufacturing Company9%
    REVIEWERS
    Financial Services Firm30%
    Transportation Company20%
    Government20%
    Educational Organization10%
    VISITORS READING REVIEWS
    Financial Services Firm23%
    Computer Software Company10%
    Government9%
    Manufacturing Company7%
    Company Size
    REVIEWERS
    Small Business11%
    Midsize Enterprise29%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise9%
    Large Enterprise75%
    REVIEWERS
    Small Business21%
    Midsize Enterprise14%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise10%
    Large Enterprise73%
    Buyer's Guide
    IDERA ER/Studio vs. Toad for Oracle
    March 2024
    Find out what your peers are saying about IDERA ER/Studio vs. Toad for Oracle and other solutions. Updated: March 2024.
    765,234 professionals have used our research since 2012.

    IDERA ER/Studio is ranked 13th in Database Development and Management with 33 reviews while Toad for Oracle is ranked 3rd in Database Development and Management with 15 reviews. IDERA ER/Studio is rated 8.4, while Toad for Oracle is rated 8.8. 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 for Oracle writes "Advanced query optimization and tuning features ". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, Sparx Systems Enterprise Architect, SAP PowerDesigner, erwin Evolve by Quest and Aqua Data Studio, whereas Toad for Oracle is most compared with Toad Edge, Oracle Enterprise Manager, Aqua Data Studio, DbVisualizer and Redgate SQL Toolbelt. See our IDERA ER/Studio vs. Toad for Oracle 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.