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."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 best part of this product is the extraction, transformation, and load."
"Most of our customers are Microsoft shops and prefer Azure Data Factory because they have good licensing options and a trust factor with Microsoft."
"From what we have seen so far, the solution seems very stable."
"The most valuable feature is the ease in which you can create an ETL pipeline."
"It is a complete ETL Solution."
"The most valuable features are data transformations."
"Azure Data Factory's most valuable features are the packages and the data transformation that it allows us to do, which is more drag and drop, or a visual interface. So, that eases the entire process."
"The simplicity of this tool is nice. It has a good graphical user interface. You can also do a lot of generic stuff in the tool. If there is good connectivity to a cloud database, such as Snowflake, and you can have a lot of Snowflake functionality in the tool."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"It can scale to a great extent. It can handle the load that we are putting on it, which is about 5TBs."
"The product has a good user interface."
"It has improved the costs of managing my customer’s data."
"It has good integrations with Amazon Redshift and other AWS services."
"It is pretty user-friendly, even for people who aren't super technical."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"The deployment should be easier."
"Data Factory could be improved in terms of data transformations by adding more metadata extractions."
"The solution needs to integrate more with other providers and should have a closer integration with Oracle BI."
"Azure Data Factory's pricing in terms of utilization could be improved."
"The pricing scheme is very complex and difficult to understand."
"Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."
"Lacks in-built streaming data processing."
"There is no built-in pipeline exit activity when encountering an error."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"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 tool's lineage is very weak."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"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 current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"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."
"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."
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 and Snowflake, 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.