Azure Data Factory vs Matillion ETL comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
25,660 views|20,160 comparisons
91% willing to recommend
Matillion Logo
3,247 views|2,215 comparisons
95% willing to recommend
Comparison Buyer's Guide
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).
771,212 professionals have used our research since 2012.
Q&A Highlights
Question: Which is better for Snowflake integration, Matillion ETL or Azure Data Factory (ADF) when hosted on Azure?
Answer: Below is a comparison between Matillion ETL and Azure Data Factory for Snowflake integration when Azure Data Factory and Snowflake are hosted on Azure, based on feedback from others: If you are using Snowflake on Azure, Azure Data Factory may be a good choice because of its tight integration with Azure. If you need to perform complex data transformations, then Matillion ETL may be a better choice because it offers more powerful ETL functionality. If you are on a tight budget, Azure Data Factory may be a better choice because it is reportedly more affordable. Matillion ETL Pros: They say it is more powerful and flexible Reportedly has better support for complex data transformations May be easier to use and maintain Cons:Reportedly more expensive than Azure Data Factory Azure Data Factory Pros: Reportedly more affordable than Matillion ETL More tightly integrated with Azure Reportedly more scalable and reliable Cons: They say it is less powerful and flexible May not offer as much good support for complex data transformations May be more difficult to use and maintain Matillion ETL may be a better choice for organizations that need a powerful and flexible ETL solution, even if it may be more expensive. Azure Data Factory may be a better choice for organizations that need an affordable and scalable ETL solution, even if it may be less powerful and flexible.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It makes it easy to collect data from different sources.""I can do everything I want with SSIS and Azure Data Factory.""I like the basic features like the data-based pipelines.""When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit.""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.""The feature I found most helpful in Azure Data Factory is the pipeline feature, including being able to connect to different sources. Azure Data Factory also has built-in security, which is another valuable feature.""It's extremely consistent.""The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."

More Azure Data Factory Pros →

"The most valuable feature of Matillion ETL is its user-friendly graphical interface.""It's been able to do everything we require.""The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple.""It's highly scalable. It takes upon itself the Redshift scalability, so it's very good.""Matillion ETL helps manage data movement, ingestion, and transformation through pipelines.""The loading of data is the most valuable feature of Matillion ETL.""Matillion ETL is one hundred percent stable.""The technical support treats us well. They already have a support portal, and they are responsive, which helps."

More Matillion ETL Pros →

Cons
"There should be a way that it can do switches, so if at any point in time I want to do some hybrid mode of making any data collections or ingestions, I can just click on a button.""Occasionally, there are problems within Microsoft itself that impacts the Data Factory and causes it to fail.""The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others.""The deployment should be easier.""Data Factory's performance during heavy data processing isn't great.""The setup and configuration process could be simplified.""The product's technical support has certain shortcomings, making it an area where improvements are required.""The solution needs to integrate more with other providers and should have a closer integration with Oracle BI."

More Azure Data Factory Cons →

"One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems.""The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine.""The tool's lineage is very weak.""I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly.""Performance can be improved for efficiency, and it can be made faster.""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.""Our main challenge currently is that Matillion runs on an EC2 instance, limiting us to running only two processes simultaneously at the entry level.""It needs integration with more data sources."

More Matillion ETL Cons →

Pricing and Cost Advice
  • "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."
  • "This is a cost-effective solution."
  • "The price you pay is determined by how much you use it."
  • "Understanding the pricing model for Data Factory is quite complex."
  • "I would not say that this product is overly expensive."
  • "The licensing is a pay-as-you-go model, where you pay for what you consume."
  • "Our licensing fees are approximately 15,000 ($150 USD) per month."
  • "The licensing cost is included in the Synapse."
  • More Azure Data Factory Pricing and Cost Advice →

  • "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."
  • "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 prices needs to be lower."
  • "It was very easy to purchase through the AWS Marketplace, but it was also expensive."
  • "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."
  • "It is not necessarily a cheap solution. However, it's reasonable priced, especially with the smaller machines that we run it on."
  • "The AWS pricing and licensing are a cost-effective solution for data integration needs."
  • "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."
  • More Matillion ETL Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
    771,212 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:AWS Glue and Azure Data factory for ELT best performance cloud services.
    Top Answer: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 and… more »
    Top Answer: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… more »
    Top Answer:The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand.
    Top Answer:The pricing depends on what edition the customer opts for. For example, a standard edition and then business critical of different editions. Each of those has a different cost per unit, which is… more »
    Top Answer:One of the features that's in development is data privacy in the cloud, along with further SAP integration. For connectivity to SAP systems.
    Ranking
    1st
    out of 101 in Data Integration
    Views
    25,660
    Comparisons
    20,160
    Reviews
    47
    Average Words per Review
    509
    Rating
    8.0
    4th
    Views
    3,247
    Comparisons
    2,215
    Reviews
    13
    Average Words per Review
    687
    Rating
    8.6
    Comparisons
    Also Known As
    Matillion ETL for Redshift, Matillion ETL for Snowflake, Matillion ETL for BigQuery
    Learn More
    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
    Top Industries
    REVIEWERS
    Computer Software Company34%
    Insurance Company11%
    Manufacturing Company8%
    Financial Services Firm8%
    VISITORS READING REVIEWS
    Computer Software Company13%
    Financial Services Firm13%
    Manufacturing Company8%
    Healthcare Company7%
    REVIEWERS
    Financial Services Firm33%
    Manufacturing Company33%
    Healthcare Company8%
    Computer Software Company8%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Financial Services Firm14%
    Manufacturing Company8%
    Government8%
    Company Size
    REVIEWERS
    Small Business29%
    Midsize Enterprise19%
    Large Enterprise52%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    REVIEWERS
    Small Business22%
    Midsize Enterprise35%
    Large Enterprise43%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise13%
    Large Enterprise69%
    Buyer's Guide
    Azure Data Factory vs. Matillion ETL
    May 2023
    Find out what your peers are saying about Azure Data Factory vs. Matillion ETL and other solutions. Updated: May 2023.
    771,212 professionals have used our research since 2012.

    Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. Azure Data Factory is rated 8.0, while Matillion ETL is rated 8.6. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and IBM InfoSphere DataStage, whereas Matillion ETL is most compared with Snowflake, AWS Glue, Informatica PowerCenter, SSIS and Informatica Cloud Data Integration. 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.