We performed a comparison between Azure Data Factory and Fivetran 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."I like how you can create your own pipeline in your space and reuse those creations. You can collaborate with other people who want to use your code."
"It's extremely consistent."
"In terms of my personal experience, it works fine."
"ADF is another ETL tool similar to Informatica that can transform data or copy it from on-prem to the cloud or vice versa. Once we have the data, we can apply various transformations to it and schedule our pipeline according to our business needs. ADF integrates with Databricks. We can call our Databricks notebooks and schedule them via ADF."
"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."
"Azure Data Factory became more user-friendly when data-flows were introduced."
"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."
"When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit."
"The ease of usability is the most valuable feature. It's very easy and quick to set up. It also has a central hub as opposed to GoldenGate which is one direct interface. For GoldenGate I would have needed three interfaces whereas with HVR I have a central interface that manages everything."
"Its arrays are powerful enough to handle migrations even when the replication is happening in the background, without causing any trouble with the ongoing traffic."
"The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized."
"Fivetran can perform data migration incredibly fast, depending on the source and target."
"The compare feature is the most valuable piece of it."
"There's the general feature of the platform where it just makes it very easy to integrate different things, but I would say a specific difference is their integration of DBT,."
"The product has some seamless connectors, which are readily available."
"SysTrack load is the best feature."
"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."
"The product could provide more ways to import and export data."
"Azure Data Factory can improve by having support in the drivers for change data capture."
"The support and the documentation can be improved."
"Real-time replication is required, and this is not a simple task."
"Data Factory has so many features that it can be a little difficult or confusing to find some settings and configurations. I'm sure there's a way to make it a little easier to navigate."
"Data Factory could be improved in terms of data transformations by adding more metadata extractions."
"Lacks a decent UI that would give us a view of the kinds of requests that come in."
"Fivetran should add more connectors because its competitors, like Airbyte, have more connectors."
"More connectors are needed for exotic, popular, and rising star portals."
"The environment must be more development-friendly."
"I would like Fivetran to implement additional resource monitoring and restriction policies."
"The documentation is decent, but it's hard to find information online about Fivetran. For example, if you try to search for an error code, you won't find much information about it in forums."
"There was a random change to our contract in a unilateral manner after the first year. The overall cost of using Fivetran was then unclear and this is the reason I would not recommend this solution."
"I would like for them to incorporate additional transformations. A valuable aspect of the product is that it does inflight transformations and that could be expanded."
"Fivetran would be improved by adding the ability to integrate the data from third-party APIs."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Fivetran is ranked 13th in Data Integration with 21 reviews. Azure Data Factory is rated 8.0, while Fivetran is rated 8.0. 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 Fivetran writes "Solution reduces time-to-value; high ROI". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and IBM InfoSphere DataStage, whereas Fivetran is most compared with AWS Database Migration Service, Qlik Replicate, Oracle GoldenGate, Informatica Cloud Data Integration and Confluent. See our Azure Data Factory vs. Fivetran report.
See our list of best Data Integration vendors.
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.