TrustRadius: an HG Insights company

Aqua Data Studio vs. Oracle Coherence vs. Oracle GoldenGate

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Aqua Data Studio

    Score10 out of 10
    N/AAqua Data Studio is a multiple-platform, integrated development environment (IDE) for data. It provides benefits to a variety of data-centric roles, allowing them to manage a wide range of data sources. Aqua Data Studio provides scalable, cross-platform data management, supporting IT and data-centric specialists, including developers, database administrators, as well as data analysts, data modelers, and data architects. Simplifies tedious tasks involving SQL queries, data,…

    $499

    per year per user

    Oracle Coherence

    Score7.9 out of 10
    N/AOracle Coherence is database management and development software.N/A

    Oracle GoldenGate

    Score8.7 out of 10
    N/AOracle Cloud Infrastructure (OCI) GoldenGate is a managed service providing a real-time data mesh platform, which uses replication to keep data highly available, and enabling real-time analysis.

    $250

    Per License

    Pricing
    Aqua Data StudioOracle CoherenceOracle GoldenGate
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Data Integration
    $250.00
    Per License
    Offerings
    Pricing Offerings
    Aqua Data StudioOracle CoherenceOracle GoldenGate
    Free Trial
    YesNoYes
    Free/Freemium Version
    NoNoNo
    Premium Consulting/Integration Services
    NoNoNo
    Entry-level Setup FeeNo setup feeNo setup feeNo setup fee
    Additional Details12-month term license. Sold per user. Full support and maintenance are included.——
    More Pricing Information
    Community Pulse
    Aqua Data StudioOracle CoherenceOracle GoldenGate
    Considered Multiple Products
    Idera, Inc.
    No answer on this topic
    Oracle
    No answer on this topic
    Oracle
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    95%
    Would buy again
    20 Answers
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    94%
    Delivers good value for the price
    15 Answers
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    95%
    Happy with the feature set
    20 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    100%
    Lived up to sales and marketing promises
    10 Answers
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    95%
    Implementation went as expected
    19 Answers
    Features
    Aqua Data StudioOracle CoherenceOracle GoldenGate
    Database Development
    Comparison of Database Development features of Aqua Data Studio and Oracle Coherence and Oracle GoldenGate
    Feature
    Aqua Data Studio
    -
    Ratings
    Oracle Coherence
    8.7
    4 Ratings
    2% above category average
    Oracle GoldenGate
    -
    Ratings
    Version control tools00 Ratings9.02 Ratings00 Ratings
    Test data generation00 Ratings8.21 Ratings00 Ratings
    Performance optimization tools00 Ratings9.34 Ratings00 Ratings
    Schema maintenance00 Ratings9.02 Ratings00 Ratings
    Database change management00 Ratings8.02 Ratings00 Ratings
    Database Administration
    Comparison of Database Administration features of Aqua Data Studio and Oracle Coherence and Oracle GoldenGate
    Feature
    Aqua Data Studio
    -
    Ratings
    Oracle Coherence
    8.3
    4 Ratings
    3% above category average
    Oracle GoldenGate
    -
    Ratings
    User management00 Ratings8.02 Ratings00 Ratings
    Database security00 Ratings10.01 Ratings00 Ratings
    Database status reporting00 Ratings7.23 Ratings00 Ratings
    Change management00 Ratings8.02 Ratings00 Ratings
    Best Alternatives
    Aqua Data StudioOracle CoherenceOracle GoldenGate
    Small Businesses
    No answers on this topic
    DBeaver
    Score8.6 out of 10
    No answers on this topic
    Medium-sized Companies
    Redgate SQL Toolbelt Essentials
    Score9.6 out of 10
    DBeaver
    Score8.6 out of 10
    Qlik Replicate
    Score10 out of 10
    Enterprises
    Redgate SQL Toolbelt Essentials
    Score9.6 out of 10
    DBeaver
    Score8.6 out of 10
    Qlik Replicate
    Score10 out of 10
    All AlternativesView all alternativesView all alternativesView all alternatives
    User Ratings
    Aqua Data StudioOracle CoherenceOracle GoldenGate
    Likelihood to Recommend
    -
    (0 ratings)
    7.8
    (5 ratings)
    9.1
    (41 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    -
    (0 ratings)
    9.2
    (3 ratings)
    Usability
    -
    (0 ratings)
    -
    (0 ratings)
    8.6
    (3 ratings)
    Availability
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Performance
    -
    (0 ratings)
    -
    (0 ratings)
    9.0
    (1 ratings)
    Support Rating
    -
    (0 ratings)
    10.0
    (1 ratings)
    8.8
    (3 ratings)
    In-Person Training
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Online Training
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Implementation Rating
    -
    (0 ratings)
    -
    (0 ratings)
    8.6
    (3 ratings)
    Configurability
    -
    (0 ratings)
    -
    (0 ratings)
    9.0
    (1 ratings)
    Ease of integration
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Product Scalability
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Vendor post-sale
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Vendor pre-sale
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    User Testimonials
    Aqua Data StudioOracle CoherenceOracle GoldenGate
    Likelihood to Recommend
    Idera, Inc.
    No answers on this topic
    Oracle
    Oracle Coherence can be used to solve latency problems by caching data near the application tier. In-memory performance helps to reduce data contention, thus improving application response time. Oracle Coherence does a great job at scaling linearly and can do so dynamically. Oracle Coherence can replicate data so it can be part of a disaster recovery solution. One thing that is often overlooked with elastic caches is their ability to analyze data in memory, leveraging the processing power of the data grid. This is something Oracle Coherence does exceptionally well. Oracle Coherence also provided event handling capabilities to allow applications to respond to events triggered by transactions.
    Incentivized
    Read full review
    Oracle
    I think it's a great product. We apply Oracle GoldenGate to several use cases in our organization. 1. Business Continuity Planning, 2. Query Offloading through data replication to a reporting instance of our data, 3. looking into data transformations to help support various queries for different teams within the business.
    Incentivized
    Read full review
    Pros
    Idera, Inc.
    No answers on this topic
    Oracle
    • Performance. Superfast resolution of complex data grid queries.
    • Reliability. Availability domain support for disaster recovery.
    • Programming model. Frictionless API for use with Java 8.
    Incentivized
    Read full review
    Oracle
    • As the product under the Oracle umbrella, it perfectly and natively supports the Oracle database very well.
    • For the standard scenario and use cases, the configuration is straight-forward (in our case uni-direction copy from source to target).
    • It is robust and the performance meets our SLA, even for a large amount of data volume.
    • The error report is not only detailed but hits the right points, so trouble shooting is easy.
    Incentivized
    Read full review
    Cons
    Idera, Inc.
    No answers on this topic
    Oracle
    • I can't really come up with too many flaws, but possibly a bit expensive considering there are good open source caches like Ehcache.
    Incentivized
    Read full review
    Oracle
    • The earlier versions of Golden Gate were complex to use as there was no front end. All that works was the command line.
    • The cost of the product can be a detriment to most companies.
    • The product has been augmented over the years and has so many features that it can be overwhelming.
    Incentivized
    Read full review
    Likelihood to Renew
    Idera, Inc.
    No answers on this topic
    Oracle
    No answers on this topic
    Oracle
    Oracle GoldenGate is a core part of our business.
    Incentivized
    Read full review
    Usability
    Idera, Inc.
    No answers on this topic
    Oracle
    No answers on this topic
    Oracle
    Once set up, it's very easy to use and keep running, it's getting to that point that can make it cumbersome to some. Also, depending on the data that you want to replicate, the configuration files can become quite cumbersome to maintain. Learning curve can be high for some who are not as experienced with databases and transactions.
    Incentivized
    Read full review
    Reliability and Availability
    Idera, Inc.
    No answers on this topic
    Oracle
    No answers on this topic
    Oracle
    Oracle GoldenGate has only gone down for us when the data being sent was bad.
    Incentivized
    Read full review
    Performance
    Idera, Inc.
    No answers on this topic
    Oracle
    No answers on this topic
    Oracle
    Oracle GoldenGate's performance is great for our use cases. Your mileage may vary.
    Incentivized
    Read full review
    Support Rating
    Idera, Inc.
    No answers on this topic
    Oracle
    Oracle Coherence support team is responsive and knowledgeable. We contacted them to ask a couple of design questions about how we were setting up Oracle Coherence based on how we used IBM's Datapower Extreme Scale. They were able to guide us so that we got the design correct the first time and didn't have to go back and re-architect our design later.
    Incentivized
    Read full review
    Oracle
    Oracle Support for Oracle GoldenGate has been quite responsive and quite helpful in the few situations where we've needed it. Furthermore, the documentation on Oracle GoldenGate is so good that we often do not need to contact support with issues as the fix is already documented and able to be run by us without needing to open a ticket.
    Incentivized
    Read full review
    In-Person Training
    Idera, Inc.
    No answers on this topic
    Oracle
    No answers on this topic
    Oracle
    We've had Oracle consultants come as well for training days to talk about new features, parts of Oracle GoldenGate we may not be using and things of that nature. The consultants they send are great as they're very knowledgeable about all things Oracle GoldenGate and great resources for any questions or concerns you may have with the product.
    Incentivized
    Read full review
    Online Training
    Idera, Inc.
    No answers on this topic
    Oracle
    No answers on this topic
    Oracle
    We used Oracle University for our Oracle Golden Gate Training and it was top notch. We were able to turn our whole DBA team to Oracle GoldenGate newbies to Oracle GoldenGate troubleshooting experts in a matter of a few days, while this obviously did not come cheap, the company felt that it was worth the investment.
    Incentivized
    Read full review
    Implementation Rating
    Idera, Inc.
    No answers on this topic
    Oracle
    No answers on this topic
    Oracle
    If Oracle GoldenGate is new to your organization, expose as many DBAs as possible to it. Having your whole team fluent in it will overcome early operational hurdles and allow it to more quickly become an accepted and supported part of your supported platform for your team that will enable the business to use it to its fullest.
    Incentivized
    Read full review
    Alternatives Considered
    Idera, Inc.
    No answers on this topic
    Oracle
    DataSynapse GridServer has the same cache functionality connected with a grid distributed application deployment platform. It provides all the necessary tools to configure and manage these applications. On the otherhand Oracle Coherence has more a flexible configuration and better performance. Also the Oracle configuration and monitoring tools are more convenient and informative than the DataSynapse ones.
    Incentivized
    Read full review
    Oracle
    We use Oracle Data Guard as a backup tool, but not for data replication. Data Guard is not suited for real-time data replication in our non-normalized reporting database nor for the database we are using for our upgrade project, as Data Guard is not able to transform data and is not able to synchronize data into different schemas, which is necessary for our project. Additionally, our project database is on Oracle 12g not 11i: I am not 100% sure Data Guard is able to replicate from 11i to 12g
    Incentivized
    Read full review
    Scalability
    Idera, Inc.
    No answers on this topic
    Oracle
    No answers on this topic
    Oracle
    Have never had any issues with scaling Oracle GoldenGate itself, however Oracle GoldenGate Monitor does have scaling issues, but with Oracle GoldenGate now able to be monitored by Oracle Enterprise Manager, this is no longer an issue, in my opinion.
    Incentivized
    Read full review
    Return on Investment
    Idera, Inc.
    No answers on this topic
    Oracle
    • In my current project, it is yet to be decided as we are on the way to make it live for users. But I am sure it will be an added value to obtain timely calculations.
    Incentivized
    Read full review
    Oracle
    • In earlier versions, DDL support was limited as well as the need of primary key constraints in the source tables. This made me create partitions, sub-partitions, truncatations and perform other operations upon they are performed in source systems and I need to discuss with source system administrators and need to convince them to let them create primary keys for replicated tables.
    • But both issues are solved now.
    • Installation is straightforward, easy.
    • Deployed everything within Oracle Data Integrator.
    • Developing 1000 of ODI interfaces for loading into Operational Data Store took not more than 100 man/days. But, adding them to Golden Gate is taking not more than 5 man/days.
    • Management Pack and VeriData are additional packs for your management and data verification needs.
    Incentivized
    Read full review
    ScreenShots

    Aqua Data Studio Screenshots

    Screenshot of A tool for all the data of an organization.Screenshot of The graphical user interface with the Dark Theme of Aqua Data Studio.Screenshot of The visual Query Builder of Aqua Data Studio.Screenshot of The SQL Debugger of Aqua Data Studio.Screenshot of The Query Analyzer of Aqua Data Studio.Screenshot of SQL History and SQL Archive of Aqua Data Studio.