Oracle Enterprise Manager vs Oracle GoldenGate comparison

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

We performed a comparison between Oracle Enterprise Manager and Oracle GoldenGate based on real PeerSpot user reviews.

Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management.
To learn more, read our detailed Database Development and Management Report (Updated: March 2024).
763,955 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
"It's a useful feature to be able to see the top SQL, the number of executions, the CPU, and the resources that it's using.""I have found the singular GUI feature very helpful. Fewer DBA resources can be allocated with Toad licenses.""SQL Tuning Advisor, ADDM, Top Activity, ASM Space Manager, Incident Notifications""Oracle Enterprise Manager has eased the responsibilities among our DBAs. We can now assign individual tasks to separate DBAs.""Some of the most valuable features are its real-time performance view/dashboard, metric history, real-time monitoring and alerts, as well as quick access to Oracle's tuning and diagnostic options.""The job subsystem, monitoring subsystem, alerting, grouping of targets, and reporting features are valuable to us.""It is the best database management system.""I have found the uptime of all of our systems to be most valuable with this solution. This is important because we need to guarantee specific uptime and preventive maintenance. We need to know upfront if there are going to be any issues on the database so we can proactively solve those."

More Oracle Enterprise Manager Pros →

"Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service).""It is a scalable solution.""It works best with Oracle.""GoldenGate can connect and collect data from multiple sources, such as SQL Server.""The initial setup is straightforward. It doesn't take too much time or effort to implement the solution.""It scales well. You can either have it working in with the databases, or you can move it outside. It's got the ability to parallelize up, so you can certainly extract and replay the data from your databases in parallel. So it does have horizontal scalability. That is probably one of its stronger features, the ability just to automatically parallelize the replay and playing of data to allow to scale to large volumes.""CDC is the most valuable feature.""Many of the features of Oracle GoldenGate are valuable. We use Oracle databases and this tool is from Oracle, making it have superior compatibility."

More Oracle GoldenGate Pros →

Cons
"We could use it but definitely with some effort we can streamline much better and sometimes some box here and there, like 13C you have to really wait, but there are great features. Just have to make sure it is a stable product.""I rate Oracle Enterprise Manager six out of 10 for affordability. It's expensive.""The solution’s pricing could be improved.""There's a lot of documentation to go through as a new user.""The solution is not as simple as people say it is.""Technical support could be faster.""The solution has a very large resource system. It's too big. There are too many items.""Patching. It's extremely difficult to determine what requires patching and the process to patch each component is slightly different."

More Oracle Enterprise Manager Cons →

"What needs improvement in Oracle GoldenGate is the support. Another feature that needs to be improved in the solution is its GUI. It would be useful for programmers or users to be able to work from the GUI, not just from the command line. Simplifying how Oracle GoldenGate is used would also make the solution better.""Monitoring must be a bit more enhanced.""Oracle GoldenGate can enhance its functionality by enabling the merging of multiple migrations into one.""GoldenGate is expensive. It's costly because this solution is unique in our market. The GoldenGate Cloud Service is cheaper than the on-premise solution.""The main problem of Oracle GoldenGate is that sometimes, the processes get abended. Data consistency is also challenging.""It would be great if Oracle added some enhanced features or more functionalities to Oracle GoldenGate.""Regarding improvements, the focus should be on addressing data quality issues and minimizing delays, particularly in Oracle databases. The technical support should be improved as well. Additionally, in terms of features, it would be great if the solution could support APIs. The support is not friendly. They don’t respond on time.""It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure."

More Oracle GoldenGate Cons →

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 →

  • "The one feature that I think Oracle could perhaps consider is, at the moment, the Veridata option is an extra cost. Golden Gate is an expensive product. You pay a lot for the best. But not including the Veridata license to prove that everything is working correctly... The big improvement for me would be to have that license built in. That would take it to the next level. That would make it a much better product. You may want to look at buying term licenses if you've just got a single migration to do. In that situation, you might want a term license for perhaps a year to save a lot of money, rather than buying a perpetual license."
  • "The licensing model should be improved to be more cost-effective for the end users."
  • "We do like the price of this solution."
  • "Pricing is based on anual licensing with additional costs for support packages."
  • "The price of this solution is good."
  • "We have an enterprise license for it. It might be for three years or so. I'm not aware of any additional costs to the standard licensing fee."
  • "Its price can be better. It is a bit crazy, and its licensing is very difficult to understand. I would rate it one out of five in terms of pricing. There don't seem to be any additional costs."
  • "We have purchased corporate licensing to use Oracle GoldenGate."
  • More Oracle GoldenGate Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Database Development and Management solutions are best for your needs.
    763,955 professionals have used our research since 2012.
    Questions from the Community
    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 »
    Top Answer:The most valuable feature of Oracle GoldenGate is its cost-effectiveness compared to other solutions like Oracle Data Guard, especially for Oracle-to-non-Oracle replication scenarios.
    Top Answer:It's a middleware. The price depends on the customers and the number of licenses they buy.
    Top Answer:In the future, I would appreciate a more user-friendly monitoring interface for easier management and troubleshooting. I believe enhancing the monitoring tools would make GoldenGate even more… more »
    Ranking
    Views
    3,242
    Comparisons
    1,649
    Reviews
    22
    Average Words per Review
    412
    Rating
    8.3
    6th
    out of 94 in Data Integration
    Views
    10,534
    Comparisons
    7,733
    Reviews
    25
    Average Words per Review
    377
    Rating
    8.2
    Comparisons
    Also Known As
    GoldenGate
    Learn More
    Overview

    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.”

    Oracle GoldenGate is a real-time data integration and database replication solution. It can detect data events and route them across networks at very low latencies and integrates well with 100s of combinations of non-Oracle databases, data stores, and clouds.

    Oracle GoldenGate Features

    Oracle GoldenGate has many valuable key features, including:

    • Simple to use web interface
    • Fast and easy installation or provisioning
    • Command line access via AdminClient that can run anywhere
    • RESTful APIs for DevOps
    • Offers built-in monitoring but also can be easily adapted to roll your own monitoring
    • APIs are protected by Cross Site Request Forgery (CSRF) authentication.

    Oracle GoldenGate Benefits

    Some of the benefits of using Oracle GoldenGate include:

    • Oracle GoldenGate is deeply integrated with the Oracle Database (logging, redo, backup and recovery layer, security, administration, data guard, data vault, autonomous database etc.).

    • It is the most stable, performant, and reliable CDC / replication solution for Oracle.

    • High performance: Oracle GoldenGate is capable of sub-second latency for data movement. featuring low impact capture, routing, transformation, and delivery of transactional data.

    • GoldenGate is the only CDC / replication tool that keeps pace with new and emerging innovations (security, features, data types, etc) in the core Oracle Database.

    • The solution supports a wide range of use cases, from conventional OLTP data replication and high availability to data lake ingestion or multi-cloud ingestion, SaaS application replication, and messaging replication.
    • GoldenGate is the only CDC / replication technology certified for Exadata, Exadata Cloud Service, and Exadata Cloud at Customer.

    • For fault-tolerance, GoldenGate has its own mechanism to keep track of how much work is completed and how much is pending. This mechanism is independent of any database and ensures, with the help of automatic gap-resolution, that no data loss occurs.

    • GoldenGate uses its own proprietary format files for keeping the committed data coming from the source database, making it independently functional irrespective of the database in use.

    • To maintain the performance and consistency, only committed data is sent. Uncommitted data is captured by GoldenGate, but is discarded after receiving a Rollback.

    • With GoldenGate, data sending is in “near real time,” which reduces the possibility of latency.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by Oracle GoldenGate users.

    PeerSpot user Steve-J., Cloud Migration Software Consultant - UK & EMEA at 1PLACE, says, "What I have found the most valuable about GoldenGate is that it does real-time and no-downtime migrations. Its migrations are fast. There are not many tools like it on the marketplace."

    Pinak S., Senior Manager of System and Database at ESL, mentions, “We like how in GoldenGate the heterogeneous database is supported. Sometimes the client actually needs a schedule and needs to ensure the state of databases for reporting purposes. With that in mind, we have been able to configure GoldenGate for certain schema. The solution is quite stable. They've recently improved the ease of implementation.”

    A Database Administrator at a manufacturing company explains, "It moves the data as you set it up, and it works. I am also very impressed with its stability and scalability. It is not super feature-rich, but the new releases have more functionality. It recently had more native integrations with Oracle Database. If you are using it against an Oracle database, it has a lot more functionality."

    An Oracle ERP DBA Consultant - Oracle Super Cluster T5-8 Admin at a government comments, "GoldenGate can connect and collect data from multiple sources, such as SQL Server."






    Sample Customers
    7-Eleven, Halliburton, Cisco, Garmin, Nationwide, Korea Telecom, Allied Irish Bank
    Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom
    Top Industries
    REVIEWERS
    Financial Services Firm23%
    Energy/Utilities Company14%
    Manufacturing Company10%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Educational Organization66%
    Financial Services Firm6%
    Computer Software Company5%
    Government4%
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company19%
    Healthcare Company12%
    Comms Service Provider8%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    Computer Software Company13%
    Manufacturing Company8%
    Government7%
    Company Size
    REVIEWERS
    Small Business22%
    Midsize Enterprise18%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business5%
    Midsize Enterprise69%
    Large Enterprise26%
    REVIEWERS
    Small Business42%
    Midsize Enterprise8%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    Buyer's Guide
    Database Development and Management
    March 2024
    Find out what your peers are saying about Oracle, Quest Software, SolarWinds and others in Database Development and Management. Updated: March 2024.
    763,955 professionals have used our research since 2012.

    Oracle Enterprise Manager is ranked 1st in Database Development and Management with 25 reviews while Oracle GoldenGate is ranked 6th in Data Integration with 26 reviews. Oracle Enterprise Manager is rated 8.4, while Oracle GoldenGate is rated 8.2. The top reviewer of Oracle Enterprise Manager writes "Enable centralized control & administration and cost containment of Oracle products from a single console". On the other hand, the top reviewer of Oracle GoldenGate writes "Great for migrating data from Oracle platforms and is extremely scalable". Oracle Enterprise Manager is most compared with Zabbix, Quest Spotlight, Dynatrace, Quest Foglight for Databases and AppDynamics, whereas Oracle GoldenGate is most compared with AWS Database Migration Service, Qlik Replicate, Quest SharePlex, Azure Data Factory and Oracle Data Integrator (ODI).

    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.