Matillion ETL vs Oracle GoldenGate comparison

Matillion and Oracle are both solutions in the Cloud Data Integration category. Additionally, 96% of Matillion users are willing to recommend the solution, compared to 96% of Oracle users who would recommend it.

Matillion ETL

Read 26 Matillion ETL reviews

2,234 Views
1,536 Comparison Views

96% willing to recommend

Oracle GoldenGate

Read 49 Oracle GoldenGate reviews

7,797 Views
5,636 Comparison Views

96% willing to recommend

Matillion ETL

Oracle GoldenGate

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Matillion ETL and Oracle GoldenGate based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Matillion ETL vs. Oracle GoldenGate Report (Updated: October 2024).

Buyer's Guide

Matillion ETL vs. Oracle GoldenGate

October 2024

Download the complete report

Helped 815,854 peers since 2012

Categories and Ranking

Matillion ETL

Average Rating

8.4

Number of Reviews

Ranking in other categories

Cloud Data Integration (5th)

Oracle GoldenGate

Average Rating

8.2

Number of Reviews

Ranking in other categories

Data Integration (8th)

Featured Reviews

AntonHaupt

Data Architect at Capitec

Jan 23, 2024

Efficient data integration and transformation with seamless cloud-native integration

In our small business unit, we currently have around four users, with two of them utilizing Matillion within our organization. Considering our growing needs, we're contemplating transitioning to an enterprise SaaS solution where we would share the same instance. Currently, each user is billed individually, but consolidating to a shared instance seems more efficient. Scalability is excellent when using the SaaS solution, easily reaching a rating of ten out of ten. Each data pipeline request is encapsulated within a Docker container and spun off, allowing for instant scalability. Overall, I would rate it a nine out of ten in terms of performance and scalability.

Read full review

Vijay Manoharan

IT Technical Specialist at a healthcare company with 10,001+ employees

Mar 7, 2024

Performs real-time replication without data loss, but we cannot do much automation

The setup with the classic GoldenGate architecture was easy. Oracle has now moved to Microservices Architecture. It is a real pain. There are a lot of new things we have to learn. I rate the ease of setup of the classic architecture a seven out of ten. For Microservices, I rate the ease of setup a three out of ten. The deployment takes a couple of hours. We need one system administrator to deploy the tool. We need to maintain the tool. We are a team of four people. We need at least three people for maintenance. The time taken for maintenance depends on how big the environment is. We spend a lot of time on maintenance because our environment is big.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"Matillion ETL is one hundred percent stable."

"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."

"The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."

"It has good integrations with Amazon Redshift and other AWS services."

"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."

"It's been able to do everything we require."

"The product has a good user interface."

"It has helped us to get onto the cloud quickly."

More Matillion ETL pros

"When we are replicating data between similar databases then it is straightforward."

"GoldenGate can connect and collect data from multiple sources, such as SQL Server."

"We can replicate data across different data centers and different technologies."

"Ease of installation, maintenance and powerful outputs and supporting Big Data and Cloud environment as well as OGGCS (Oracle Golden Gate Cloud Service)."

"It allows us to migrate from one system to another, from one server to another, with no downtime, no outage. We can get the data synchronized with multiple databases and then switch the connectivity across to the new servers."

"I am impressed with the tool's possibility of integrating different systems in a unified place."

"CDC is the most valuable feature."

"The initial setup is straightforward. It doesn't take too much time or effort to implement the solution."

More Oracle GoldenGate pros

Cons

"The tool's lineage is very weak."

"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."

"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."

"Performance can be improved for efficiency, and it can be made faster."

"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."

"I am looking forward to seeing the expansion of the source range for their data loader product."

"Matillion’s on-premises capabilities don’t allow you to build something customized."

"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."

More Matillion ETL cons

"The front-end management isn't very good."

"In some cases, expectations were not met, especially when specific tables were expected to be disabled, and changes were anticipated in the target environment. We had to take backups from the source and refresh the address to address this."

"Some issues regarding stability need to be resolved."

"The main problem of Oracle GoldenGate is that sometimes, the processes get abended. Data consistency is also challenging."

"The solution's licensing price is very expensive and could be made more competitive."

"The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement."

"It's stable but you have to know how to maintain it. That's why it's not 10 out of 10 for me. There are some bugs, there are some issues here and there. All of a sudden your process is not working and you have to figure out why, and sometimes it's not so clear."

"A clean and user-friendly graphical interface based on common design principles would be beneficial."

More Oracle GoldenGate cons

Pricing and Cost Advice

"Its price depends on what you expect. You pay on a monthly basis, but there is a possibility to have special contracts depending on the installation."

"The pricing depends on what edition the customer opts for. For example, the standard edition is priced at $2.00 per credit. And you are only charged when you use it. You're not charged when it's idle."

"I have heard from my manager and other higher ups, "This product is cheaper than other things on the market," and they have done the research."

"The product must improve its pricing."

"Purchasing it through the AWS Marketplace is pretty convenient. There is a little bit of back and forth in terms of the licensing based on the machine size, but it seems to have worked out well. it is convenient to have it all as part of our AWS billing."

"The price of Matillion ETL is reasonable."

"The cost of the solution is high and could be reduced."

"Matillion ETL is expensive."

More Matillion ETL pricing and cost advice

"The tool needs to improve its pricing."

"In addition to the licensing fee, customers are also required to pay an additional 24 percent for the support."

"Oracle GoldenGate's license can be expensive compared to other solutions like Qlik Replicate or SAP Replicate."

"We pay a yearly licensing fee for Oracle GoldenGate, which is very expensive."

"The product is expensive."

"The tool is a bit expensive."

"The licensing model should be improved to be more cost-effective for the end users."

"The price of this solution is good."

More Oracle GoldenGate pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Integration solutions are best for your needs.

See recommendations

815,854 professionals have used our research since 2012.

Comparison Review

it_user99375

Database Administrator at a tech services company with 51-200 employees

Mar 31, 2014

Oracle GoldenGate vs. Oracle Active Dataguard

As an Oracle DBA, while working upon high availability of your database you may stumble upon various Oracle strategic capabilities that fall into categories of Oracle Replication. Oracle provides various technologies for replication like GoldenGate, streams, and Active Dataguard. Replication…

Read full review

Top Industries

By visitors reading reviews

Financial Services Firm

16%

Computer Software Company

14%

Manufacturing Company

Government

Financial Services Firm

22%

Computer Software Company

13%

Manufacturing Company

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about Matillion ETL?

The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.

See all answers

What is your experience regarding pricing and costs for Matillion ETL?

The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running. Its pricing model is different from the traditional pricing models ...

See all answers

What needs improvement with Matillion ETL?

Depending on the use case, the solution's pricing could be improved. Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems.

See all answers

What do you like most about Oracle GoldenGate?

The product is reliable for data integrity.

See all answers

What is your experience regarding pricing and costs for Oracle GoldenGate?

The product is expensive. Due to the high cost, we are considering alternative solutions.

See all answers

What needs improvement with Oracle GoldenGate?

The solution sometimes has issues with long transactions and replication delays. Its pricing needs improvement.

See all answers

Comparisons

Azure Data Factory vs Matillion ETL

Compared 13% of the time

SSIS vs Matillion ETL

Compared 9% of the time

AWS Glue vs Matillion ETL

Compared 9% of the time

Snowflake vs Matillion ETL

Compared 8% of the time

Informatica PowerCenter vs Matillion ETL

Compared 7% of the time

More Matillion ETL Competitors

AWS Database Migration Service vs Oracle GoldenGate

Compared 18% of the time

Qlik Replicate vs Oracle GoldenGate

Compared 13% of the time

Quest SharePlex vs Oracle GoldenGate

Compared 7% of the time

Azure Data Factory vs Oracle GoldenGate

Compared 7% of the time

Fivetran vs Oracle GoldenGate

Compared 6% of the time

More Oracle GoldenGate Competitors

Product Reports

Buyer's Guide

Matillion ETL

November 2024

Download Matillion ETL product report

Buyer's Guide

Oracle GoldenGate

November 2024

Download Oracle GoldenGate product report

Also Known As

Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery

GoldenGate

Learn More

Matillion

Oracle

Overview

Matillion ETL is a powerful tool for extracting, transforming, and loading large amounts of data from various sources into cloud data warehouses like Snowflake. Its ability to load data dynamically and efficiently using metadata is a standout feature, as is its open-source ETL with good performance and high efficiency.

The solution has a graphical interface for jobs, is easily adjustable and extensible, and allows for scheduling and error reporting. Matillion ETL has helped organizations move to a cloud-based solution, bridge the gap between on-premises and on-cloud, and perform complex migration projects.

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

Thrive Market, MarketBot, PWC, Axtria, Field Nation, GE, Superdry, Quantcast, Lightbox, EDF Energy, Finn Air, IPRO, Twist, Penn National Gaming Inc

Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom

Buyer's Guide

Matillion ETL vs. Oracle GoldenGate

October 2024

Free Report: Matillion ETL vs. Oracle GoldenGate

Find out what your peers are saying about Matillion ETL vs. Oracle GoldenGate and other solutions. Updated: October 2024.

DOWNLOAD NOW

815,854 professionals have used our research since 2012.

See our Matillion ETL vs. Oracle GoldenGate report.

See our list of best Cloud Data Integration vendors.

We monitor all Cloud Data Integration 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.