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 scalability and reliability, making it suitable for handling large data volumes and complex data transformations.
It offers robust integration capabilities with various data sources, leveraging a wide range of connectors for seamless data movement.
Its ability to automate ETL processes through drag-and-drop features allows users to create custom pipelines efficiently.
Azure Data Factory stands out for its built-in security, ensuring secure data ingestion and integration in the cloud environment.
The platform provides extensive support for Microsoft Azure's ecosystem, enabling end-to-end data integration and orchestration with other Azure components.

CONS

Azure Data Factory's technical support and documentation require improvements, with delayed responses and complex guidance, impacting user efficiency.
The setup, pricing structure, and licensing model are considered complex and opaque, deterring user accessibility and financial transparency.
Connectivity is limited with essential databases and systems, posing challenges in integration and seamless database interaction, particularly with Oracle and SAP.
Azure Data Factory exhibits limited performance and stability during intensive data processing tasks, reflecting the need for scalable optimization and robust data handling capabilities.
The reliance on a code-oriented approach over a configuration-oriented one diminishes the accessibility for users seeking less technical involvement, which impacts workflow efficiency.
 

Azure Data Factory Pros review quotes

Kunal Das - PeerSpot reviewer
Test Engineer at Happiest Minds Technologies
Aug 16, 2026
Since I have mentioned that I can use the drag-and-drop activities, by using that, Azure Data Factory is saving a lot of time, my organization has already been saving the time and generating more income with that.
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: September 2026.
911,994 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.
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.
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.
 

Azure Data Factory Cons review quotes

Kunal Das - PeerSpot reviewer
Test Engineer at Happiest Minds Technologies
Aug 16, 2026
If the AI features were more improved so that I don't have to provide each and every detail, Azure Data Factory could be improved in a much better way by improving the AI features.
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: September 2026.
911,994 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.
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.
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.