Try our new research platform with insights from 80,000+ expert users

Matillion ETL pros and cons

Vendor: Matillion

4.2 out of 5

26 reviews
96% willing to recommend

623 followers

Pros & Cons summary

Matillion ETL empowers non-technical users to load data easily into a data warehouse, offering excellent scalability for large data loads and seamless AWS integration. With effective Change Data Capture and responsive support, it excels in enhancing data management. Improvements are needed in database connections, data source integration, and scalability to handle processes efficiently across cloud and on-prem environments. Enhanced integration with AWS Secrets Manager and SAP systems is necessary for comprehensive data privacy and management.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

Matillion ETL allows non-technical users to efficiently load data into data warehouses, reducing the need for technical supervision.

It provides scalability, handling substantial loads effectively, and efficiently manages data integration tasks.

The tool has seamless integration capabilities with Amazon Redshift and other AWS services.

Matillion ETL is praised for its stability and the ability to handle complex data integration tasks reliably.

It features a robust CDC (Change Data Capture) component, enhancing data management processes.

CONS

Matillion ETL requires expanded integration capabilities with more databases and on-prem environments.

Improvement is needed for near-real-time data capture and overall performance efficiency.

Additional features are necessary to match those available in other ETL tools, including support for extensive pre-processing.

Challenges exist with SAP integration and the inclusion of more connectors would be beneficial.

Scalability and stability issues are present, with a need for improvements in handling and executing processes.

Matillion ETL Pros review quotes

Data Lead at InterWorks

Apr 27, 2023

Matillion ETL helps manage data movement, ingestion, and transformation through pipelines.

Read full review

PH

Senior Data Engineer Consultant at a tech company with 201-500 employees

Mar 5, 2023

Matillion ETL has great Git integration that is perfect and convenient to use.

Read full review

Solutions Architect at a financial services firm with 501-1,000 employees

Sep 3, 2019

It's highly scalable. It takes upon itself the Redshift scalability, so it's very good.

Read full review

Free Report: Matillion ETL Reviews and More

Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.

823,875 professionals have used our research since 2012.

Data Architect at Capitec

Jan 23, 2024

It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth

Read full review

MG

Michael Grayson

Director of IT Operations at Broadridge Financial Solutions, Inc.

Feb 21, 2023

It's been able to do everything we require.

Read full review

HS

Director of Data Architecture at a healthcare company with 201-500 employees

Dec 11, 2018

It has helped us to get onto the cloud quickly.

Read full review

Jacques Du Preez

Chief Executive Officer at Intellinexus

Mar 5, 2024

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

Read full review

Specialist Programmer at Infosys

Feb 27, 2023

The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python.

Read full review

AS

Principal Consultant at Eviden France

Apr 4, 2024

The product's initial setup phase was easy.

Read full review

Senior Infrastructure Engineer at GoGuardian

Dec 11, 2018

It is pretty user-friendly, even for people who aren't super technical.

Read full review

Show 10 more reviews (out of 23)

Matillion ETL Cons review quotes

Data Lead at InterWorks

Apr 27, 2023

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

Read full review

PH

Senior Data Engineer Consultant at a tech company with 201-500 employees

Mar 5, 2023

Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves.

Read full review

Solutions Architect at a financial services firm with 501-1,000 employees

Sep 3, 2019

Ideally, I would like it to integrate with Secrets Manager as well as the AWS.

Read full review

Free Report: Matillion ETL Reviews and More

Learn what your peers think about Matillion ETL. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.

823,875 professionals have used our research since 2012.

Data Architect at Capitec

Jan 23, 2024

Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level.

Read full review

MG

Michael Grayson

Director of IT Operations at Broadridge Financial Solutions, Inc.

Feb 21, 2023

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

Read full review

HS

Director of Data Architecture at a healthcare company with 201-500 employees

Dec 11, 2018

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

Read full review

Jacques Du Preez

Chief Executive Officer at Intellinexus

Mar 5, 2024

One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems.

Read full review

Specialist Programmer at Infosys

Feb 27, 2023

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.

Read full review

AS

Principal Consultant at Eviden France

Apr 4, 2024

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.

Read full review

Senior Infrastructure Engineer at GoGuardian

Dec 11, 2018

Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion.

Read full review

Show 10 more reviews (out of 23)

Product Categories

Product Categories

Cloud Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs Matillion ETL

AWS Glue vs Matillion ETL

MuleSoft Anypoint Platform vs Matillion ETL

webMethods.io vs Matillion ETL

AWS Database Migration Service vs Matillion ETL

Palantir Foundry vs Matillion ETL

Denodo vs Matillion ETL

Fivetran vs Matillion ETL

SnapLogic vs Matillion ETL

IBM App Connect vs Matillion ETL

Zapier vs Matillion ETL

Jitterbit Harmony vs Matillion ETL

Rivery vs Matillion ETL

Keboola vs Matillion ETL

See all alternatives

Product Categories

Product Categories

Cloud Data Integration

Popular Comparisons

Popular Comparisons

Informatica Intelligent Data Management Cloud (IDMC) vs Matillion ETL

AWS Glue vs Matillion ETL

MuleSoft Anypoint Platform vs Matillion ETL

webMethods.io vs Matillion ETL

AWS Database Migration Service vs Matillion ETL

Palantir Foundry vs Matillion ETL

Denodo vs Matillion ETL

Fivetran vs Matillion ETL

SnapLogic vs Matillion ETL

IBM App Connect vs Matillion ETL

Zapier vs Matillion ETL

Jitterbit Harmony vs Matillion ETL

Rivery vs Matillion ETL

Keboola vs Matillion ETL

See all alternatives

Related questions

107

Which is better for Snowflake integration, Matillion ETL or Azure Data Factory (ADF) when hosted on Azure?

21

How does Matillion ETL compare to StreamSets?

27

Oracle ICS vs ODI

2

When evaluating Cloud Data Integration, what aspect do you think is the most important to look for?

16

What is data lake storage?

143

Which integration solution is best for a company that wants to integrate systems between sales, marketing, and project development operations systems?

213

Which is the best choice for cloud integration: AWS Glue or Informatica Intelligent Cloud Services (IICS)?

49

Which product would you choose: SAP CPI vs Talend Cloud Integration?

2

Informatica or SSIS on Azure Cloud?

4

Why would you choose AWS Glue over other tools?