Attunity Replicate Vs. Oracle Golden Gate

by | Jan 27, 2017

Data Integration, replication and acquisition tools are a hot topic in the Business Intelligence world. Gartner’s 2016 Magic quadrant for Data Integration tools included Oracle, IBM, Informatica, SAP, Talend and SAS in the Leaders quadrant with Microsoft, Adeptia and Attunity as Challengers. Their description for inclusion is:

Data integration tools must support different modes of interaction with this range of data structure types, including:

  • Bulk/batch acquisition and delivery
  • Granular trickle-feed acquisition and delivery
  • Change data capture (CDC) — the ability to identify and extract modified data
  • Event-based acquisition (time-based, data-value-based or links to application integration tools to interact with message request/reply, publish/subscribe and routing)

OptimalBI is lucky enough to work with many of the Leader and Challengers products so today I’m going to look at Attunity Replicate and Oracle GoldenGate. Kate has previously compared Attunity Replicate with Microsoft SSIS here.

What is Attunity Replicate?

Attunity describe it as a ‘Universal Platform for Data Replication and Data Ingest’

What does it do?

Attunity Replicate moves data. It replicates, ingests and streams your data where you want it.

How does Attunity Replicate make things better?

  • It takes away the need for manual coding to move data
  • It supports the databases you probably use including DB2, MySQL, and SQL
  • It shortens the time required to get analysis and reports to decision makers
  • It enables operational reporting without impacting production databases
  • It replicates data without the need to install software on the target databases

Where can you find out more?

There is a well-supported customer forum which is a good place to start.

What is Oracle GoldenGate?

Oracle describe GoldenGate as ‘a comprehensive software package for real-time data integration and replication in heterogeneous IT environments’.

What does it do?

Oracle GoldenGate ‘enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems.’

How does Oracle GoldenGate make things better?

  • High performance
  • Simple configuration and management
  • Tight integration with Oracle databases
  • Support for Cloud environments

Oracle GoldenGate comes with Management Pack for Oracle GoldenGate which provides a visual management and monitoring solution for Oracle GoldenGate deployments. There is also Oracle GoldenGate Veridata, which allows high-speed, high-volume comparison between two in-use databases.

Where can you find out more?

You can visit the Oracle GoldenGate forum here to find out more.

How do the two compare?

While our team work with Oracle GoldenGate and enjoy its rich feature set we find it doesn’t meet the needs of our non-Oracle customers. Looking for an alternative we became Attunity partners. Below are some of the questions we are often asked by companies leading to our working with Attunity in recent instances.

Feature
Attunity Replicate
Oracle GoldenGate
Does the tool support new SQL Server users? Yes No
Can the tool handle automated DDL replication for non-Oracle environments? Yes No
Can the tool work without installing and maintaining agents on every end point? Yes No
Will the tool work without manual data type mapping? Yes No
Is there support for AWS, Azure and Google Cloud? Yes No

The OptimalBI team have written other blogs about Attunity Replicate, you can find them here or Contact us here to find out how we can help you bring the power of Attunity Replicate to your business.
Success is preparation meets opportunity – Jack
Jack blogs about community, social media and how all this data stuff impacts the rest of us.
We run regular instructor led courses to help you with your AgileBI project approach or get your started gathering Data Driven Requirements – you can read more about our course offerings here
Want to read more from Jack – Try 5 Qlik blogs you should check out.

6 Comments
  1. Colby James

    Attunity best in all aspects

    Reply
    • Jack Prichard

      Hi Colby,
      That is pretty much what I found.

      Reply
  2. moneyxmoney

    This is incorrect. GoldenGate supported Microsoft SQL server but stopped sales for a while for new customers. It is resumed now from Q3 2017.
    GoldenGate can handle DDL to non-Oracle environments such as Big Data.
    Tool can work without installing agents at every end point. For example GoldenGate Cloud service is a remote access only.
    GoldenGate can be deployed on any cloud environment, AWS or Azure or Oracle cloud. There is no restriction

    Reply
  3. Oracle Job Support

    Hi Jack,
    You did great work on both Attunity Replicate and Oracle GoldenGate and shared experience with us. I really thank to you to spread light on this topic. Because here few people who share their experience with others.

    Reply
  4. Suresh Punna

    Hi Jack,

    Thanks for putting this comparison together. Helps!
    Do you have any visibility into how this comparison will look like for both these data integration tools for performing the change data capture and other data integration abilities mentioned above on Vertica (columnar) Database on AWS

    Thanks
    Suresh.

    Reply
    • Bronwyn Scott

      Hi Suresh,
      Thanks for your question. We haven’t specifically done a comparison on Vertica so can’t comment. We will have blogs on other AWS deployed CDC tools coming out very soon.

      Reply
Submit a Comment

Your email address will not be published. Required fields are marked *