My use case for Azure Data Factory is mainly for integrating the data for the ETL process.
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.



| Author info | Rating | Review Summary |
|---|---|---|
| Director at a computer software company with 1,001-5,000 employees | 4.0 | I've used Azure Data Factory for over five years, valuing its data flow, integration, and reusable components, though I see room for improvement in transformations, AI insights, and real-time monitoring dashboards. I rate it an 8. |

The most valuable feature I have found at Azure Data Factory is the data flow function.
Regarding the integration feature in Azure Data Factory, the integration part is excellent; we have major source connectors, so we can integrate the data from different data sources and also perform basic transformation while transforming, which is a great feature in Azure Data Factory.
The main benefits users can receive from Azure Data Factory include building reusable common components. We do not want to create a pipeline for each different data set, so we can create a framework to build the model, allowing us to use reusable components for any number of sources based on configuration. This is a great capability in Azure Data Factory.
The orchestration features in Azure Data Factory are definitely useful, as it is not only for Azure Data Factory; we can also include DataBricks and other services for integrating the data solution, making it a very beneficial feature.
Regarding potential areas of improvement for Azure Data Factory, there is a need for better data transformation, especially since many people are now depending on DataBricks more for connectivity and data integration. Azure Data Factory should consider how to enhance integration or filtering for more transformations, such as integrating with Spark clusters.
I am satisfied with Azure Data Factory so far, but I suggest integrating some AI functionality to analyze data during the transition itself, providing insights such as null records, common records, and duplicates without running a separate pipeline or job.
The monitoring tools in Azure Data Factory are helpful for optimizing data pipelines; while the current feature is adequate, they can improve by creating a live dashboard to see the online process, including how much percentage has been completed, which will be very helpful for people who are monitoring the pipeline.
I have been working with Azure Data Factory for more than five to six years.
I would rate the stability of Azure Data Factory as 8.5.
For scalability, I rate Azure Data Factory as eight.
The initial setup for Azure Data Factory is not complex; it is simple, except when using the integration service for on-premises where a separate VM is needed, but it is not complex for people who are technical.
My main competitor in the market for Azure Data Factory would be DataBricks, as they are making many improvements for integrating data sources, and I believe DataBricks will become a big competitor in the future.
I am still working with Azure Data Factory and continue to use the product.
I am satisfied with the built-in connectors for data transformation in Azure Data Factory because there are more than 150 plus and around 200 connectors available now, which means we do not need to use any custom solutions for most of the major data sources.
Azure Data Factory supports hybrid data scenarios, which I find very useful because most sources are moving to the cloud, but some applications remain on-premises or in different clouds, so this hybrid feature is much required.
Azure Data Factory is applicable for all companies, from small to mid-size and enterprise-level use cases.
On a scale of 1-10, I rate Azure Data Factory an 8.
| Product | Mindshare (%) |
|---|---|
| Azure Data Factory | 2.2% |
| SSIS | 4.0% |
| Informatica Intelligent Data Management Cloud (IDMC) | 3.8% |
| Other | 90.0% |
| Company Size | Count |
|---|---|
| Small Business | 24 |
| Midsize Enterprise | 17 |
| Large Enterprise | 49 |
| Company Size | Count |
|---|---|
| Small Business | 441 |
| Midsize Enterprise | 172 |
| Large Enterprise | 585 |
1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa