IDERA ER/Studio vs Oracle Enterprise Manager 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 Oracle Enterprise Manager 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. Oracle Enterprise Manager 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
"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.""Data lineage tracking: It allows us to identify upstream and downstream systems using data.""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.""The tool is simple to use.""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.""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.""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.""We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."

More IDERA ER/Studio Pros →

"The solution is easy to use and has good performance.""The most valuable feature is the monitoring because it's very useful for checking and troubleshooting compared with other products, like Nagios for example, that have some interaction with Oracle.""Oracle Enterprise Manager helps to control servers.""We use Oracle Enterprise Manager as a tool to monitor Oracle products.""I have found the singular GUI feature very helpful. Fewer DBA resources can be allocated with Toad licenses.""It's easy to implement as it's made by Oracle for Oracle.""The 13cR2 updates to the OEM family, strongly integrate Cloud (off-site, hybrid and on-premise) services providing a seamless way to see all of your resources regardless of where they are deployed.""It is a stable solution...The initial setup of Oracle Enterprise Manager was straightforward."

More Oracle Enterprise Manager Pros →

Cons
"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 model diagram because very clumsy when you save it on the team server and the models are very big.""What needs the most improvement are semantic lineage and usability.""They allow functionalities to be released before the full tests for catching and correcting errors are completed.""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.""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 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.""The visual presentation is a little too colorful and seems that it is dumbed down."

More IDERA ER/Studio Cons →

"We have encountered performance issues when the load is huge.""The solution is not as simple as people say it is.""The deployment is not straightforward.""The tool is expensive.""The fact that Oracle Enterprise Manager is an expensive solution is a matter of concern and needs to be considered for improvement.""Better mobile access would be useful.""We would like to have a single dashboard for monitoring and controlling all of our products.""I would like to improve the cost."

More Oracle Enterprise Manager 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 →

  • "It is part of Real Application Testing, so no new investment is necessary for clients who already are already using RAT."
  • "As with all Oracle products, care should be taken when using any features to ensure that they do not activate licensed features that have not been paid for."
  • "The basic functions are free. You only pay license fees for advanced features."
  • "The pricing is very high."
  • "We are satisfied with the pricing."
  • "There is only the standard licensing fee. There are no other costs."
  • "Evaluate your requirements carefully. Elaborate DR and HA setup of OEM can become expensive."
  • "Be careful to only enable the packs for which you have a license as this is an issue we see time and again."
  • More Oracle Enterprise Manager 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:Oracle Enterprise Manager helps to control servers.
    Top Answer:Initially, our deal was for three years, and we extended it to five years. Oracle solutions are very costly. We have totally our solution and including hardware with its license. we have no product… more »
    Ranking
    Views
    477
    Comparisons
    344
    Reviews
    2
    Average Words per Review
    440
    Rating
    8.5
    Views
    3,242
    Comparisons
    1,649
    Reviews
    22
    Average Words per Review
    412
    Rating
    8.3
    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.

    Oracle Enterprise Manager is an on-premises management platform that provides a comprehensive integrated solution for managing and automating your various Oracle products, including applications, databases, middleware, hardware, and engineered systems located either in your Oracle data center or in the cloud.

    With the Oracle Enterprise Manager's console, you can administer multiple databases and servers, distribute software to multiple servers and clients, monitor objects and events throughout the network, and integrate with other tools.

    Key Oracle Enterprise Manager Features and Products

    • Hardware and virtualization management: Manage all Oracle environments from one central console. Oracle Enterprise Manager provides management and automation for Oracle engineered systems, databases, middleware, and hardware.

    • Database management: Oracle’s Database management provides a full lifecycle solution for updates and configuration management, patching, provisioning, testing, performance management and automatic tuning.

    • Application performance management (APM): User and database monitoring with diagnostics and performance analysis that provide rich reporting on real user activities.

    • Enterprise monitoring: Built-in monitoring of all components of the IT infrastructure enables rapid problem diagnosis. Both Oracle and non-Oracle components are constantly monitored.

    • Oracle real user experience insight: Insights on real user experiences and preferences enable businesses and IT stakeholders to develop a shared understanding into their application users’ experience.

    • Non-Oracle management: Oracle Enterprise Manager manages non-Oracle components with a comprehensive set of plugins. The self-update mechanism allows customers to download, import, and deploy extensions built by Oracle, Oracle partners, and Oracle customers. These extensions enjoy the same level of stability as Oracle's own products.

    • Installation and upgrade: The upgrade process provides efficient, reliable, secure data migration with minimal downtime of your environment.

    Reviews from Real Users

    Oracle Enterprise Manager stands out among its competitors for a number of reasons. Several major ones are its central management and monitoring and its reporting capabilities

    Robin C., head of Oracle Exadata Centre of Excellence at Tata Consultancy Services, writes, "The database performance monitoring features are very useful and allow us to quickly zero in on DB-related issues. Exadata storage server and Infiniband switches can be viewed from the GUI in OEM which cannot be done in other tools. The ability to deploy metric extensions makes this tool extensible for our custom monitoring also."

    PeerSpot users note the effectiveness of these features. A database manager at a tech services company notes, “The solution's most valuable aspect is the fact that it is embedded with the Oracle database and Oracle's engineering system, its extra data, and analytics.  They have plug-ins that are very helpful. Due to the infrastructure's size, the introduction they offer is very, very useful. It helps with an overall understanding of the product. They have a very nice graphical user interface. The monitoring is good. We can capture the SQL tune from us. With Oracle Enterprise Managers, we can see the rich performance tuning.”

    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
    7-Eleven, Halliburton, Cisco, Garmin, Nationwide, Korea Telecom, Allied Irish Bank
    Top Industries
    REVIEWERS
    Government19%
    Healthcare Company14%
    Financial Services Firm14%
    Computer Software Company10%
    VISITORS READING REVIEWS
    Financial Services Firm20%
    Computer Software Company10%
    Government10%
    Manufacturing Company9%
    REVIEWERS
    Financial Services Firm23%
    Energy/Utilities Company14%
    Manufacturing Company10%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Educational Organization66%
    Financial Services Firm6%
    Computer Software Company5%
    Government4%
    Company Size
    REVIEWERS
    Small Business11%
    Midsize Enterprise29%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise9%
    Large Enterprise75%
    REVIEWERS
    Small Business22%
    Midsize Enterprise18%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business5%
    Midsize Enterprise69%
    Large Enterprise26%
    Buyer's Guide
    IDERA ER/Studio vs. Oracle Enterprise Manager
    March 2024
    Find out what your peers are saying about IDERA ER/Studio vs. Oracle Enterprise Manager 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 Oracle Enterprise Manager is ranked 1st in Database Development and Management with 122 reviews. IDERA ER/Studio is rated 8.4, while Oracle Enterprise Manager 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 Oracle Enterprise Manager writes "Provides good stability and has an easy implementation process". 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 Oracle Enterprise Manager is most compared with Zabbix, Quest Spotlight, Dynatrace, Quest Foglight for Databases and AppDynamics. See our IDERA ER/Studio vs. Oracle Enterprise Manager 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.