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 excels in flexibility, allowing users to efficiently move and integrate data at scale.
It offers extensive connectivity with various sources, thanks to numerous out-of-the-box connectors.
The drag-and-drop interface simplifies workflow management and speeds up pipeline development.
Azure Data Factory's scalability and reliability make it ideal for handling large data volumes and meeting business needs.
The integration capabilities with other Microsoft Azure components enhance its effectiveness in data orchestration.

CONS

Azure Data Factory has complex pricing and integration challenges which can be improved for better transparency and user-friendliness.
The setup and configuration process could be simplified to enhance user experience and accessibility.
There are issues with connectivity and integration, especially with third-party solutions, highlighting the need for more comprehensive connector support.
The need for more detailed error reporting and better technical support is apparent, as current delays and unclear messages hinder effective troubleshooting.
Azure Data Factory's performance could be improved, particularly in terms of speed and handling large data volumes effectively.
 

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.
SubrataDey - PeerSpot reviewer
Principal Data Engineer at Oracle
May 10, 2026
Azure Data Factory is a very easy to use ETL tool for loading and transforming data from one location to another.
Hafiz Abdul Mannan - PeerSpot reviewer
Senior Consultant Oracle Technologies at a tech vendor with 10,001+ employees
May 10, 2026
Azure Data Factory is easy to use and integrates well, providing good classification to bring data from diverse parts of the data infrastructure, whether from CSV files coming from the Cisco server, MySQL, Excel machines, or local network data from remote files.
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,747 professionals have used our research since 2012.
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.
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.
DT
Data Engineer at Vthinktechnologies
May 15, 2025
Our stakeholders and clients have expressed satisfaction with Azure Data Factory's efficiency and cost-effectiveness.
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.
 

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.
SubrataDey - PeerSpot reviewer
Principal Data Engineer at Oracle
May 10, 2026
There is one particular problem with Azure Data Factory. When you have a parent-to-child relationship and the child has one more relationship, creating a hierarchy situation, there are issues.
Hafiz Abdul Mannan - PeerSpot reviewer
Senior Consultant Oracle Technologies at a tech vendor with 10,001+ employees
May 10, 2026
Additionally, the ability to handle the largest volumes of data is another concern; if I have to manage more than one terabyte of data every day, I am not comfortable dealing with Azure Data Factory and had to switch to Oracle Data Integrators (ODI) because it lacks performance features.
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,747 professionals have used our research since 2012.
Victor Sokolov - PeerSpot reviewer
Data Architect/Engineering manager at Intellias
Dec 3, 2025
They should work on optimizing their licensing model and pricing structure.
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.
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.
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.