Azure Data Factory and Fivetran are both leading ETL tools in the data integration category. Azure Data Factory has an advantage due to its comprehensive feature set suitable for complex data scenarios while Fivetran stands out for its simplicity and efficiency in data replication.
Features: Azure Data Factory provides comprehensive ETL support with enhanced scalability and a large selection of connectors. Its robust data transformation capabilities via a visual interface and seamless integration with other Azure services allow for a streamlined process. It is particularly beneficial for complex data scenarios. Fivetran offers simplicity and minimizes manual intervention in data replication. Its managed pipelines and integration with DBT provide advantages, though it lags in advanced transformation capabilities compared to Azure Data Factory.
Room for Improvement: Azure Data Factory users report challenges with debugging tools, user interface intuitiveness, and integration with data providers. Enhancements in data capture features and support for machine learning models are desired, along with simplification of its pricing model. Fivetran could improve logging detail and data pipeline observability for better monitoring. Its high cost for large data sources and limited customization options are also noted, with a need for more connectors and transparent pricing.
Ease of Deployment and Customer Service: Azure Data Factory is well-suited for Microsoft Azure's public cloud, offering deployment flexibility and integration with Azure services, though its support has been criticized for response time and costs. Fivetran's customer service is considered adequate but faces issues with problem resolution speed. While both products allow public cloud deployments, Fivetran is favored for quick and easy data replication setups.
Pricing and ROI: Azure Data Factory employs a pay-as-you-go pricing model, aligning costs with usage but potentially leading to unpredictability. It is generally cost-competitive, with economic value increased when part of the Azure ecosystem. Some users express concerns about costs due to usage spikes. Fivetran is noted for higher costs, especially for large data volumes. Its usage-based pricing model is perceived as expensive by some users, but its rapid deployment and data management benefits can justify the expense.
It saves us the effort of having one to two data engineers managing the tasks that Fivetran handles.
The technical support from Microsoft is rated an eight out of ten.
The technical support is responsive and helpful
The technical support for Azure Data Factory is generally acceptable.
The technical support provided by Fivetran has generally been good, with a response time and competence that I would rate as good.
Azure Data Factory is highly scalable.
The solution has a high level of stability, roughly a nine out of ten.
Incorporating more dedicated API sources to specific services like HubSpot CRM or Salesforce would be beneficial.
There is a problem with the integration with third-party solutions, particularly with SAP.
Sometimes, the compute fails to process data if there is a heavy load suddenly, and it doesn't scale up automatically.
Improvement in existing connectors with new features is desirable.
The pricing is cost-effective.
It is considered cost-effective.
Our current yearly contract for Fivetran is approximately $70,000.
It connects to different sources out-of-the-box, making integration much easier.
I find the most valuable feature in Azure Data Factory to be its ability to handle large datasets.
The interface of Azure Data Factory is very usable with a more interactive visual experience, making it easier for people who are not as experienced in coding to work with.
The most valuable feature of Fivetran is its built-in connectors for a wide range of data sources.
Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.
Fivetran, the global leader in data movement, is trusted by companies like OpenAI, LVMH, Pfizer, Verizon and Spotify to centralize data from SaaS applications, databases, files, and other sources into cloud destinations, including data lakes. With high-performance pipelines, seamless interoperability, and enterprise-grade security, Fivetran empowers organizations to modernize their data infrastructure, power analytics and AI, ensure compliance, and achieve transformative business outcomes. Learn more at Fivetran.com
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.
