Azure Data Factory vs Matillion ETL comparison

The compared Microsoft and Matillion solutions aren't in the same category. Microsoft is ranked #1 in DI , with an average rating of 8.1, and holds a 11.0% mindshare in the category. Matillion is ranked #5 in CDI , with an average rating of 8.4, and holds a 4.1% mindshare. Additionally, 92% of Microsoft users are willing to recommend the solution, compared to 96% of Matillion users who would recommend it.

Azure Data Factory

Read 86 Azure Data Factory reviews

21,615 Views
17,232 Comparison Views

92% willing to recommend

Matillion ETL

Read 26 Matillion ETL reviews

2,014 Views
1,412 Comparison Views

96% willing to recommend

Azure Data Factory

Matillion ETL

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Azure Data Factory and Matillion ETL based on real PeerSpot user reviews.

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

To learn more, read our detailed Azure Data Factory vs. Matillion ETL Report (Updated: May 2023).

Buyer's Guide

Azure Data Factory vs. Matillion ETL

May 2023

Download the complete report

Helped 823,875 peers since 2012

Categories and Ranking

Azure Data Factory

Average Rating

8.0

Reviews Sentiment

6.7

Number of Reviews

Ranking in other categories

Data Integration (1st), Cloud Data Warehouse (3rd)

Matillion ETL

Average Rating

8.4

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Cloud Data Integration (5th)

Mindshare comparison

While both are Data Integration and Access solutions, they serve different purposes. Azure Data Factory is designed for Data Integration and holds a mindshare of 11.0%, down 13.3% compared to last year.
Matillion ETL, on the other hand, focuses on Cloud Data Integration, holds 4.1% mindshare, down 5.7% since last year.

Data Integration

Cloud Data Integration

Featured Reviews

Thulani David Mngadi

Data architect at Old Mutual

Data flow feature is valuable for data transformation tasks

The workflow automation features in GitLab, particularly its low code/no code approach, are highly beneficial for accelerating development speed. This feature allows for quick creation of pipelines and offers customization options for integration needs, making it versatile for various use cases. GitLab supports a wide range of connectors, catering to a majority of integration needs. Azure Data Factory's virtual enterprise and monitoring capabilities, the visual interface of GitLab makes it user-friendly and easy to teach, facilitating adoption within teams. While the monitoring capabilities are sufficient out of the box, they may not be as comprehensive as dedicated enterprise monitoring tools. GitLab's monitoring features are manageable for production use, with the option to integrate log analytics or create custom dashboards if needed. The data flow feature in Azure Data Factory within GitLab is valuable for data transformation tasks, especially for those who may not have expertise in writing complex code. It simplifies the process of data manipulation and is particularly useful for individuals unfamiliar with Spark coding. While there could be improvements for more flexibility, overall, the data flow feature effectively accomplishes its purpose within GitLab's ecosystem.

Read full review

AntonHaupt

Data Architect at Capitec

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

Quotes from Members

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

Pros

"The data mapping and the ability to systematically derive data are nice features. It worked really well for the solution we had. It is visual, and it did the transformation as we wanted."

"I like the basic features like the data-based pipelines."

"This solution will allow the organisation to improve its existing data offerings over time by adding predictive analytics, data sharing via APIs and other enhancements readily."

"The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable."

"Feature-wise, one of the most valuable ones is the data flows introduced recently in the solution."

"The security of the agent that is installed on-premises is very good."

"From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connects and we can connect them to the system and copy the data from its respective system to any environment. That is the best feature."

"The overall performance is quite good."

More Azure Data Factory pros

"The product has a good user interface."

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

"The technical support treats us well. They already have a support portal, and they are responsive, which helps."

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

"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."

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

"We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL)."

"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."

More Matillion ETL pros

Cons

"Data Factory's monitorability could be better."

"Data Factory could be improved in terms of data transformations by adding more metadata extractions."

"Data Factory could be improved by eliminating the need for a physical data area. We have to extract data using Data Factory, then create a staging database for it with Azure SQL, which is very, very expensive. Another improvement would be lowering the licensing cost."

"There aren't many third-party extensions or plugins available in the solution."

"The speed and performance need to be improved."

"If the user interface was more user friendly and there was better error feedback, it would be helpful."

"The pricing model should be more transparent and available online."

"When the record fails, it's tough to identify and log."

More Azure Data Factory cons

"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."

"The product must enhance its near-real-time data capture feature."

"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."

"While the UI is good, it could be improved in its efficiency and made easier to use."

"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."

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

"Sometimes, we have issues with the solution's stability and need to restart it for three weeks or more."

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

More Matillion ETL cons

Pricing and Cost Advice

"I would not say that this product is overly expensive."

"Pricing appears to be reasonable in my opinion."

"It's not particularly expensive."

"The pricing is pay-as-you-go or reserve instance. Of the two options, reserve instance is much cheaper."

"The solution's pricing is competitive."

"ADF is cheaper compared to AWS."

"This is a cost-effective solution."

"The pricing is a bit on the higher end."

More Azure Data Factory pricing and cost advice

"The price of Matillion ETL is reasonable."

"The solution is very cheap. You're paying $2.50 an hour and if you set your service up, which you can do, you're not getting charged. Currently, our ETL process is just an overnight process that runs for about an hour. I can start and stop my server just for an hour if I want to and spent $2.50 a day for an ETL solution. There are no additional costs."

"I think it is cost conscious. It used to be very cheap and they have more recently bumped up the pricing, so it is competitive now."

"The absence of licensing commitments makes it easy to experiment with the tool, and if we decide it's not suitable, we can simply stop the ETL instance and cease incurring charges."

"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."

"A rough estimation of the cost is around 20,000 dollars a month, however, this is dependent on the machine used and how Matillion ETL is used."

"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 prices needs to be lower."

More Matillion ETL pricing and cost advice

See which vendors are best for you

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

See recommendations

823,875 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

13%

Computer Software Company

12%

Manufacturing Company

Healthcare Company

Financial Services Firm

16%

Computer Software Company

14%

Manufacturing Company

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

How do you select the right cloud ETL tool?

AWS Glue and Azure Data factory for ELT best performance cloud services.

See all answers

How does Azure Data Factory compare with Informatica PowerCenter?

Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...

See all answers

How does Azure Data Factory compare with Informatica Cloud Data Integration?

Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...

See all answers

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

Comparisons

Informatica PowerCenter vs Azure Data Factory

Compared 13% of the time

Snowflake vs Azure Data Factory

Compared 10% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Azure Data Factory

Compared 8% of the time

Alteryx Designer vs Azure Data Factory

Compared 7% of the time

Microsoft Azure Synapse Analytics vs Azure Data Factory

Compared 2% of the time

More Azure Data Factory Competitors

SSIS vs Matillion ETL

Compared 9% of the time

AWS Glue vs Matillion ETL

Compared 9% of the time

Snowflake vs Matillion ETL

Compared 7% of the time

Informatica PowerCenter vs Matillion ETL

Compared 6% of the time

SnapLogic vs Matillion ETL

Compared 5% of the time

More Matillion ETL Competitors

Product Reports

Buyer's Guide

Azure Data Factory

December 2024

Download Azure Data Factory product report

Buyer's Guide

Matillion ETL

November 2024

Download Matillion ETL product report

Also Known As

No data available

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

Learn More

Microsoft

Matillion

Overview

Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.

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.

Sample Customers

1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa

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

Buyer's Guide

Azure Data Factory vs. Matillion ETL

May 2023

Free Report: Azure Data Factory vs. Matillion ETL

Find out what your peers are saying about Azure Data Factory vs. Matillion ETL and other solutions. Updated: May 2023.

DOWNLOAD NOW

823,875 professionals have used our research since 2012.

See our Azure Data Factory vs. Matillion ETL report.

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