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."We have been using drivers to connect to various data sets and consume data."
"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."
"From what we have seen so far, the solution seems very stable."
"The solution can scale very easily."
"Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations."
"I am one hundred percent happy with the stability."
"Allows more data between on-premises and cloud solutions"
"The function of the solution is great."
"For us, Fivetran has been able to scale both in terms of the data we bring into our warehouse and the amount of data that we use as well."
"The general data ingestion is valuable. It's used for a lot of data. It provides about 90% of the data we use in our data warehouse without needing data engineering."
"Fivetran can perform data migration incredibly fast, depending on the source and target."
"The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized."
"Fivetran's most valuable feature is replication."
"The product is very easy to use and very easy to configure."
"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."
"The simplicity of the solution is its valuable feature."
"Azure Data Factory can improve the transformation features. You have to do a lot of transformation activities. This is something that is just not fully covered. Additionally, the integration could improve for other tools, such as Azure Data Catalog."
"The support and the documentation can be improved."
"There is no built-in pipeline exit activity when encountering an error."
"The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way."
"I rate Azure Data Factory six out of 10 for stability. ADF is stable now, but we had problems recently with indexing on an SQL database. It's slow when dealing with a huge volume of data. It depends on whether the database is configured as general purpose or hyperscale."
"Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."
"When working with AWS, we have noticed that the difference between ADF and AWS is that AWS is more customer-focused. They're more responsive compared to any other company. ADF is not as good as AWS, but it should be. If AWS is ten out of ten, ADF is around eight out of ten. I think AWS is easier to understand from the GUI perspective compared to ADF."
"They require more detailed error reporting, data normalization tools, easier connectivity to other services, more data services, and greater compatibility with other commonly used schemas."
"Some of the pain points we're looking at are trying to integrate some of the items in the Microsoft stack, so SharePoint and Excel, and then some of the newer Azure services."
"More connectors are needed for exotic, popular, and rising star portals."
"Fivetran is very expensive for data sources with a lot of rows, such as email data. I would like to see cheaper pricing for data sources like that."
"The solution is very expensive. I would like to have a better integration of the solution with Azure."
"It should have a few more monitoring functionalities."
"Fivetran would be improved by adding the ability to integrate the data from third-party APIs."
"We use a separate tool for "reverse ETL", which is the opposite of what Fivetran does; it pushes data from your data warehouse back out to business applications. If Fivetran pulls data from those same applications, they should also enable users to push it back. I would love to do both ETL and reverse ETL in the same tool."
"HVR Software's technical support could be improved. Whenever we log a case, the response that we get from the support is a bit delayed."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Fivetran is ranked 13th in Data Integration with 19 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 Microsoft Azure Synapse Analytics, whereas Fivetran is most compared with AWS Database Migration Service, Qlik Replicate, Oracle GoldenGate, Informatica Cloud Data Integration and StreamSets. 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.