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."The function of the solution is great."
"The security of the agent that is installed on-premises is very good."
"We use the solution to move data from on-premises to the cloud."
"Feature-wise, one of the most valuable ones is the data flows introduced recently in the solution."
"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
"An excellent tool for pipeline orchestration."
"The data factory agent is quite good and programming or defining the value of jobs, processes, and activities is easy."
"For me, it was that there are dedicated connectors for different targets or sources, different data sources. For example, there is direct connector to Salesforce, Oracle Service Cloud, etcetera, and that was really helpful."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"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 has good integrations with Amazon Redshift and other AWS services."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"The loading of data is the most valuable feature of Matillion ETL."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"It has improved the costs of managing my customer’s data."
"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."
"Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."
"The support and the documentation can be improved."
"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"For some of the data, there were some issues with data mapping. Some of the error messages were a little bit foggy. There could be more of a quick start guide or some inline examples. The documentation could be better."
"We have experienced some issues with the integration. This is an area that needs improvement."
"Occasionally, there are problems within Microsoft itself that impacts the Data Factory and causes it to fail."
"When the record fails, it's tough to identify and log."
"Data Factory could be improved in terms of data transformations by adding more metadata extractions."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"The cost of the solution is high and could be reduced."
"The tool's lineage is very weak."
"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."
"In the next release, we would like to have connections to more databases."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
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 Microsoft Azure Synapse Analytics, 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.