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.0, and holds a 11.1% mindshare in the category. Matillion is ranked #5 in CDI , with an average rating of 8.4, and holds a 4.4% 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

23,087 Views
18,331 Comparison Views

92% willing to recommend

Matillion ETL

Read 26 Matillion ETL reviews

2,234 Views
1,536 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 815,854 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

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.1%, down 13.3% compared to last year.
Matillion ETL, on the other hand, focuses on Cloud Data Integration, holds 4.4% mindshare, down 6.0% since last year.

Data Integration

Cloud Data Integration

Featured Reviews

Thulani David Mngadi

Data architect at Old Mutual

Mar 18, 2024

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

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

Quotes from Members

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

Pros

"What I like best about Azure Data Factory is that it allows you to create pipelines, specifically ETL pipelines. I also like that Azure Data Factory has connectors and solves most of my company's problems."

"Data Flow and Databricks are going to be extremely valuable services, allowing data solutions to scale as the business grows and new data sources are added."

"The data copy template is a valuable feature."

"An excellent tool for pipeline orchestration."

"It's extremely consistent."

"I can do everything I want with SSIS and Azure Data Factory."

"One of the most valuable features of Azure Data Factory is the drag-and-drop interface. This helps with workflow management because we can just drag any tables or data sources we need. Because of how easy it is to drag and drop, we can deliver things very quickly. It's more customizable through visual effect."

"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."

More Azure Data Factory pros

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

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

"The solution's most valuable feature is the CDC (Change Data Capture) component."

"The loading of data is the most valuable feature of Matillion ETL."

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

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

"Matillion ETL is one hundred percent stable."

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

More Matillion ETL pros

Cons

"Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations."

"On the UI side, they could make it a little more intuitive in terms of how to add the radius components. Somebody who has been working with tools like Informatica or DataStage gets very used to how the UI looks and feels."

"The setup and configuration process could be simplified."

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

"It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."

"We have experienced some issues with the integration. This is an area that needs improvement."

"It can improve from the perspective of active logging. It can provide active logging information."

"Real-time replication is required, and this is not a simple task."

More Azure Data Factory cons

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

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

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

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

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

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

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

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

More Matillion ETL cons

Pricing and Cost Advice

"I would rate Data Factory's pricing nine out of ten."

"In terms of licensing costs, we pay somewhere around S14,000 USD per month. There are some additional costs. For example, we would have to subscribe to some additional computing and for elasticity, but they are minimal."

"I rate the product price as six on a scale of one to ten, where one is low price and ten is high price."

"The licensing model for Azure Data Factory is good because you won't have to overpay. Pricing-wise, the solution is a five out of ten. It was not expensive, and it was not cheap."

"My company is on a monthly subscription for Azure Data Factory, but it's more of a pay-as-you-go model where your monthly invoice depends on how many resources you use. On a scale of one to five, pricing for Azure Data Factory is a four. It's just the usage fees my company pays monthly."

"The price is fair."

"I don't see a cost; it appears to be included in general support."

"The solution's fees are based on a pay-per-minute use plus the amount of data required to process."

More Azure Data Factory pricing and cost advice

"It is cost-effective. Based on our use case, it's efficient and cheap. It saves a lot of money and our upfront costs are less."

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

"The AWS pricing and licensing are a cost-effective solution for data integration needs."

"The product must improve its pricing."

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

"It was procured through the AWS Marketplace because it keeps things simple. They offer retail-like checkout and bill through your existing Amazon Web Services account."

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

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

815,854 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 14% of the time

Snowflake vs Azure Data Factory

Compared 11% 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

MuleSoft Anypoint Platform 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 8% of the time

Informatica PowerCenter vs Matillion ETL

Compared 7% of the time

SnapLogic vs Matillion ETL

Compared 5% of the time

More Matillion ETL Competitors

Product Reports

Buyer's Guide

Azure Data Factory

November 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

815,854 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.