Oracle Enterprise Manager and IDERA ER/Studio are leading products in enterprise IT solutions, with Oracle Enterprise Manager having the edge in cloud integration and real-time monitoring, while IDERA ER/Studio stands out in data modeling and change management.
Features: Oracle Enterprise Manager is known for resource management, automated provisioning, and cloud integration, which support a wide array of Oracle applications and enable detailed policy definitions for SLA compliance. IDERA ER/Studio offers strong data modeling, reverse engineering, and data lineage tracking capabilities, facilitating database design and change management with collaborative features for team environments.
Room for Improvement: Oracle Enterprise Manager users report extensive patch requirements, complex system management, and high add-on pricing, suggesting the interface and installation process could benefit from simplification. IDERA ER/Studio users call for licensing flexibility, a simplified interface for less experienced users, better Active Directory integration, and improved large dataset performance.
Ease of Deployment and Customer Service: Oracle Enterprise Manager provides extensive deployment options, including hybrid clouds, but the setup can be complex. Its technical support is generally satisfactory, though some users face delays reaching higher-level technicians. IDERA ER/Studio, primarily on-premises, offers straightforward deployment and generally positive customer service, though support efficiency varies with large setups.
Pricing and ROI: Oracle Enterprise Manager offers basic functions for free with costly add-ons, providing comprehensive capabilities but perceived as steep by some users. IDERA ER/Studio has high pricing with complex licensing, yet it delivers good value, especially in extensive enterprise use.
There is plenty of documentation available online for assistance, making it straightforward to address any issues.
I would rate Oracle Enterprise Manager's technical support at an eight.
It scales well to teams of one hundred plus people.
When trying to connect with non-Oracle products and applications, the connection process is not very straightforward.
Erwin is a very stable product.
We have not faced any challenges or difficulties with it.
Both Erwin and ER/Studio do not have AI or machine learning features for automation.
Adding AI features for automated replies or helpdesk support would improve Oracle Enterprise Manager.
Setting up the Oracle Enterprise Manager is challenging as it requires setting up a separate server.
The areas where Oracle Enterprise Manager could improve include the dashboarding, which could be made more intuitive.
The setup cost may have been around $1500 to $2000.
In terms of pricing, ER/Studio is slightly more expensive compared to Erwin, by about five to ten percent.
In terms of pricing, Oracle Enterprise Manager is on the premium side compared to other monitoring tools.
The licensing is based on the core.
When we built an application, it facilitated the development process by providing the skeleton of the application and the foundation for functions.
It has strong versioning support and can even integrate with third-party versioning tools like GitHub.
The tool allows us to monitor 24/7, configure dashboards, and quickly check the status of databases that are in critical states.
It also has features like the AWR report, which helps analyze resource usage during specific times.
One of the most valuable features of Oracle Enterprise Manager has been the preventive reporting capability.
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
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.”
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.