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."In terms of my personal experience, it works fine."
"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."
"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
"The overall performance is quite good."
"The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components."
"The most important feature is that it can help you do the multi-threading concepts."
"The most valuable feature is the copy activity."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"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 helped us to get onto the cloud quickly."
"The product has a good user interface."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"The tool's middle-dimensional structure significantly simplifies obtaining the right data at the appropriate level. This feature makes deploying our applications easier since we utilize a single source without publishing data from various sources."
"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."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"The Microsoft documentation is too complicated."
"It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."
"The thing we missed most was data update, but this is now available as of two weeks ago."
"It can improve from the perspective of active logging. It can provide active logging information."
"The solution needs to be more connectable to its own services."
"Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."
"Data Factory could be improved in terms of data transformations by adding more metadata extractions."
"Some known bugs and issues with Azure Data Factory could be rectified."
"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."
"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."
"The product must enhance its near-real-time data capture feature."
"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 cost of the solution is high and could be reduced."
"Performance can be improved for efficiency, and it can be made faster."
"The tool's lineage is very weak."
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, SSIS, Informatica PowerCenter 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.