No more typing reviews! Try our Samantha, our new voice AI agent.
Azure Data Factory Logo

Azure Data Factory pros and cons

Vendor: Microsoft
4.0 out of 5
Badge Leader

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Azure Data Factory allows for seamless integration with various data sources and provides robust ETL capabilities.
The platform is highly scalable and reliable, supporting large data transformation tasks.
Azure Data Factory offers an extensive range of connectors facilitating easy data movement between diverse environments.
Its integration capabilities with Microsoft Azure components and other platforms enhance its versatility.
The low code/no code approach simplifies the development of ETL pipelines, speeding up the process while maintaining flexibility.

CONS

Azure Data Factory's integration with third-party tools and services, such as Oracle BI and SAP, needs improvement.
Azure Data Factory's documentation is seen as complicated and lacking in detailed examples and use cases.
There is room for improvement in Azure Data Factory's performance, especially during heavy data processing and high load situations.
Azure Data Factory's pricing structure is considered complex, and there is a need for greater transparency and ease of understanding.
There are not enough prebuilt connectors and limitations in data transformation and metadata handling capabilities within Azure Data Factory.
 

Azure Data Factory Pros review quotes

KandaswamyMuthukrishnan - PeerSpot reviewer
Director at a computer software company with 1,001-5,000 employees
Aug 27, 2025
The most valuable feature I have found at Azure Data Factory is the data flow function.
DT
Data Engineer at Vthinktechnologies
May 15, 2025
Our stakeholders and clients have expressed satisfaction with Azure Data Factory's efficiency and cost-effectiveness.
Victor Sokolov - PeerSpot reviewer
Data Architect/Engineering manager at Intellias
Dec 3, 2025
I value the integration capabilities with other platforms and software in Azure Data Factory the most.
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
893,164 professionals have used our research since 2012.
Revital Hajaj - PeerSpot reviewer
Sales & Projects Manger at ACS
Mar 17, 2026
Azure Data Factory was not difficult to deploy because it is a small area, so we completed it very quickly.
Joy Maitra - PeerSpot reviewer
Sr. Technical Architect at Hexaware Technologies Limited
Dec 26, 2024
Azure Data Factory is a low code, no code platform, which is helpful.
Brian Sullivan - PeerSpot reviewer
Chief Analytics Officer at Idiro Analytics
Dec 20, 2024
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.
Rama Subba Reddy Thavva - PeerSpot reviewer
Solution Architect at Mercedes-Benz AG
Jan 22, 2025
The data is more scalable.
reviewer2394240 - PeerSpot reviewer
Complementary Worker On Assignment at a manufacturing company with 10,001+ employees
Nov 5, 2024
The valuable feature of Azure Data Factory is its integration capability, as it goes well with other components of Microsoft Azure.
Monalisha Nayak - PeerSpot reviewer
Senior Data Engineer at Shell
Jul 16, 2024
The solution handles large volumes of data very well. One of its best features is its ability to integrate data end-to-end, from pulling data from the source to accessing Databricks. This makes it quite useful for our needs.
Ramya Kuppala - PeerSpot reviewer
Technical Manager at PalTech
Jul 23, 2024
The data flows were beneficial, allowing us to perform multiple transformations.
 

Azure Data Factory Cons review quotes

KandaswamyMuthukrishnan - PeerSpot reviewer
Director at a computer software company with 1,001-5,000 employees
Aug 27, 2025
There is a need for better data transformation, especially since many people are now depending on DataBricks more for connectivity and data integration.
DT
Data Engineer at Vthinktechnologies
May 15, 2025
The inability to connect local VMs and local servers into the data flow is a limitation that prevents giving Azure Data Factory a perfect score.
Victor Sokolov - PeerSpot reviewer
Data Architect/Engineering manager at Intellias
Dec 3, 2025
They should work on optimizing their licensing model and pricing structure.
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
893,164 professionals have used our research since 2012.
Revital Hajaj - PeerSpot reviewer
Sales & Projects Manger at ACS
Mar 17, 2026
I did not see any positive impact from Azure Data Factory overall.
Joy Maitra - PeerSpot reviewer
Sr. Technical Architect at Hexaware Technologies Limited
Dec 26, 2024
There are performance issues, particularly with the underlying compute, which should be configurable.
Brian Sullivan - PeerSpot reviewer
Chief Analytics Officer at Idiro Analytics
Dec 20, 2024
Some prebuilt data source or data connection aspects are generic.
Rama Subba Reddy Thavva - PeerSpot reviewer
Solution Architect at Mercedes-Benz AG
Jan 22, 2025
I have encountered a problem with the integration with third-party solutions, particularly with SAP.
reviewer2394240 - PeerSpot reviewer
Complementary Worker On Assignment at a manufacturing company with 10,001+ employees
Nov 5, 2024
Customer service is not satisfactory. Third-party personnel handle support and rely on a knowledge repository.
Monalisha Nayak - PeerSpot reviewer
Senior Data Engineer at Shell
Jul 16, 2024
The main challenge with implementing Azure Data Factory is that it processes data in batches, not near real-time. To achieve near real-time processing, we need to schedule updates more frequently, which can be an issue. Its interface needs to be lighter.
Ramya Kuppala - PeerSpot reviewer
Technical Manager at PalTech
Jul 23, 2024
When we initiated the cluster, it took some time to start the process.