Matillion ETL Reviews

Name: Matillion ETL
Brand: Matillion
Rating: 4.2 (26 reviews)

4.2 out of 5

26 reviews
96% willing to recommend

623 followers

What is Matillion ETL?

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.

Get the Matillion ETL Buyer's Guide and find out what your peers are saying about Matillion ETL, Informatica Intelligent Data Management Cloud (IDMC), AWS Glue and more!

Matillion ETL is the #5 ranked solution in top Cloud Data Integration solutions. PeerSpot users give Matillion ETL an average rating of 8.4 out of 10. Based on the analysis of the 26 most recent Matillion ETL reviews, the overall sentiment is positive, with a sentiment score of 7.4. Matillion ETL is most commonly compared to Informatica Intelligent Data Management Cloud (IDMC): Matillion ETL vs Informatica Intelligent Data Management Cloud (IDMC). Matillion ETL is popular among the large enterprise segment, accounting for 69% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 16% of all views.

Helped 823,875 peers since 2012

Featured reviews

AntonHaupt

Data Architect at Capitec

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

Tomáš Hronek

Data Engineer at Merck

I use Matillion ETL for wrangling or transforming data from sources like S3 and Databricks The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation. Sometimes, we have issues with the solution's stability and need to restart it for…

Read full review

Sunny Kumar

Specialist Programmer at Infosys

The decision to use Matillion ETL depends on the specific requirements. If the requirements can be met without Matillion ETL in a short amount of time, then using it would be unnecessary. However, if dealing with large data sets and frequent data migrations to and from the cloud, then Matillion ETL would be a suitable choice. I have a lot of experience in this field of data and I was able to achieve results with Matillion ETL that I was not able to with the traditional approach. The solution is helpful for large amounts of data. I rate Matillion ETL an eight out of ten.

Read full review

Matillion ETL mindshare

As of December 2024, the mindshare of Matillion ETL in the Cloud Data Integration category stands at 4.1%, down from 5.7% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Cloud Data Integration

PeerAnalyst reports

Type	Title	Date
Category	Cloud Data Integration	Dec 18, 2024	Download
Product	Reviews, tips, and advice from real users	Dec 18, 2024	Download
Comparison	Matillion ETL vs AWS Glue	Dec 18, 2024	Download
Comparison	Matillion ETL vs AWS Database Migration Service	Dec 18, 2024	Download
Comparison	Matillion ETL vs Informatica Intelligent Data Management Cloud (IDMC)	Dec 18, 2024	Download

Title	Rating	Mindshare	Recommending
Informatica Intelligent Data Management Cloud (IDMC)	4.0	N/A	93%	181 interviews Add to research
AWS Glue	3.9	24.8%	91%	46 interviews Add to research

Valuable Features

Valuable features of Matillion ETL include its seamless integration with various data sources, built-in verification, and scheduling capabilities. Its user-friendly interface and simplicity make it accessible for non-technical users. It excels in organizing and modularizing pipelines, facilitating data sampling, and leveraging AWS services. Its graphical interface and minimal coding requirements enhance workflow efficiency. Matillion ETL's dynamic data handling, robust processing capabilities, and excellent support further enhance its appeal.

"The solution's most valuable feature is the CDC (Change Data Capture) component."
"The product is quite stable and can handle complex data integration tasks well."
"The product's initial setup phase was easy."

Room for Improvement

Matillion ETL requires more frequent API updates due to rapid changes from platforms like Google and Facebook. Integration with more databases and services, improved UI and documentation, and better concurrency handling are needed. Current pricing could be more competitive. Addressing these enhancements, particularly in backend integration and real-time data capture, could alleviate existing limitations. Enhanced SAP connectivity and expanded pre-processing features are also highlighted areas for improvement. Users express a need for increased customization and connectors.

"Matillion ETL should include more enhanced capabilities for extracting data from the SAP systems."
"The product's scalability needs improvement. Perhaps adding more connectors would be beneficial."
"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."

ROI

ROI from Matillion ETL was achieved in less than a year, saving significant time. While some are still transitioning data with no current measurements, it is apparent that Matillion will reduce costs once legacy servers are retired. Cloud-based operation offers transparent billing, with decreased operational costs by 15% to 20%. Users observe recuperation of costs, as shown by a public health service in the UK, although their benefit is in cost savings rather than profit.

Pricing

Matillion ETL pricing offers a flexible pay-as-you-go model, primarily determined by the EC2 instance size and runtime hours, making it suitable for various team sizes. The hourly prices can range from $1.37 for smaller instances to $5.40 for larger ones, with opportunities for cost savings through the AWS Marketplace's annual discounts. Larger teams or intensive usage may lead to higher costs, yet its competitive pricing and straightforward AWS Marketplace integration appeal to enterprise buyers seeking efficient data integration solutions.

"The solution's pricing is not based on the licensing cost but on the running hours when the Matillion instance is up and running."
"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."
"Matillion ETL has a pay-as-you-go pricing model of a few dollars per hour of runtime."

Popular Use Cases

Users primarily utilize Matillion ETL for data transformation, migration, and integration tasks. It efficiently manages ETL pipelines, transfers data to cloud data warehouses like Snowflake, and supports diverse datasets from various sources including on-premise databases. Some perform data warehousing, analytics, or loading tasks, while others use it for cloud architecture development. Its cloud-native design offers compatibility with many cloud platforms and enables complex processes for bridging on-premises and cloud systems.

Service and Support

Matillion ETL provides outstanding customer service and support, praised for its responsiveness and efficiency. Users commend the team for quick responses, helpfulness, and comprehensive documentation, including videos and articles. The support portal and ideas platform are frequently highlighted. Matillion ETL's ability to swiftly resolve issues within 24 hours is appreciated, alongside their readiness to communicate via Zoom. Some suggest improvements in response time, but the overall sentiment remains positive, emphasizing their commitment to customer satisfaction.

Deployment

Users found Matillion ETL's initial setup straightforward and quick. Deployment is often completed in minutes due to cloud support. Configuration and integration with AWS and Amazon Redshift are easy, with minimal requirements. Many appreciate its intuitive interface and compatibility with various databases like Snowflake and Salesforce. Setup can vary with data size but often requires only a few hours or even minutes, involving small teams. Security concerns can affect ease for some.

Scalability

Matillion ETL demonstrates strong scalability, leveraging Redshift's MPP capabilities and cloud solutions like Snowflake. Users note it scales well by managing computing resources efficiently and offers features like easy configuration and elastic containers. Although minor challenges exist with Python components and virtual machines, newer versions improve scalability options. Scalability ratings often hit high marks, indicating it effectively handles large workloads across diverse environments without additional cost when scaling nodes.

Stability

Users generally find Matillion ETL stable, rating it around eight to nine out of ten. Some encountered initial issues, but support was responsive. Stability can depend on hosting; robust virtual machines improve performance. A few experienced problems, needing restarts occasionally. Most users report no issues and appreciate its performance, reliability, and ease for tasks on Snowflake. Some suggest restarting instances to manage memory leakage.

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our Matillion ETL Buyer's Guide for additional reliable information.

Review data by company size

By reviewers

By visitors reading reviews

Top industries

By visitors reading reviews

Financial Services Firm

16%

Computer Software Company

14%

Manufacturing Company

Government

Healthcare Company

Energy/Utilities Company

Retailer

University

Insurance Company

Construction Company

Educational Organization

Media Company

Real Estate/Law Firm

Non Profit

Logistics Company

Legal Firm

Comms Service Provider

Wholesaler/Distributor

Mining And Metals Company

Transportation Company

Outsourcing Company

Recreational Facilities/Services Company

Pharma/Biotech Company

Consumer Goods Company

Performing Arts

Non Tech Company

Hospitality Company

Compare Matillion ETL with alternative products

Learn more about Matillion ETL

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.

Matillion ETL was previously known as Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery.