Azure Data Factory Reviews & Product Details

The best part is its low-code/no-code (drag-and-drop) functionality. It makes development easier for developers and also makes the process more understandable for business users. Review collected by and hosted on G2.com.

Sometimes it’s hard to debug. I need to check why a record is not populated before the sink. Since all my tables have a lot of data, once I join them it becomes even more, and then it’s difficult to verify why a specific record isn’t coming through. To figure it out, I have to go back and change the source table, filter down to that record, and then see which join or filter isn’t working. That’s hard and time-consuming. The parameterization syntax is also an issue and can be difficult to work with. It would help if we had AI integration for this. Review collected by and hosted on G2.com.

Azure Data Factory makes it much easier to build and manage data integration workflows in the cloud. The visual pipeline designer is intuitive and allows you to create complex data workflows without writing large amounts of code. It supports a wide variety of data sources and destinations, which makes integrating systems across databases, storage accounts, APIs, and SaaS platforms very straightforward.

Another strong point is the scalability and reliability of the platform. Data pipelines can handle large volumes of data, and scheduling or triggering pipelines based on events is easy to configure. The integration with other Azure services like Azure Storage, Synapse, and monitoring tools also makes it a strong component of a modern data platform. Review collected by and hosted on G2.com.

Debugging and troubleshooting pipelines can sometimes be difficult. Error messages are not always very detailed, which can slow down the process of identifying issues. The UI is helpful, but complex pipelines can become harder to manage and visualize as they grow. Additionally, monitoring and cost tracking for large workloads requires careful attention, as pipeline executions and data movement activities can accumulate costs quickly. Review collected by and hosted on G2.com.

I especially like its ability to orchestrate pipelines in a centralized and quite intuitive way. Azure Data Factory is designed precisely to create and schedule data-driven workflows, with native integration with many Azure sources and services. If I have to be more specific, the main advantage for me is that it allows me to organize data flows: I connect different sources, automate recurring steps, and control everything from a single environment, without having to manually manage each individual transfer. Review collected by and hosted on G2.com.

One aspect I don't particularly appreciate about Azure Data Factory is the lack of immediacy in the environment, which often doesn't seem intuitive, especially in the initial stages. The presence of many components and configuration steps makes its use less streamlined than expected and requires time to become familiar with the tool's logic. As a result, some tasks become more cumbersome, especially when working on complex pipelines or having to manage frequent changes. Review collected by and hosted on G2.com.

What I like best about Azure Data Factory (ADF) is that it hits a really nice spot between enterprise-grade orchestration and day-to-day practicality. A few highlights that genuinely stand out:

Orchestration without friction:

ADF is excellent at coordinating many moving parts: Blob storage, ADLS Gen2, Azure SQL, Synapse, Databricks, Functions, REST APIs, without forcing you to glue everything together manually. Pipelines, triggers, and dependencies feel very natural once you’ve used them a bit.

Clear separation of concerns:

The way ADF separates control flow (pipelines, activities, triggers) from data processing (Spark, SQL, Functions) is a big win. It doesn’t try to be the compute engine; it just orchestrates things cleanly and lets the right service do the heavy lifting.

Parameterization & reusability:

Pipelines, datasets, and linked services are highly parameterizable. This makes it easy to build config-driven ingestion frameworks (single pipeline, many sources), which scales really well in real enterprise setups.

First-class integration with the Azure ecosystem:

Native integration with Synapse, Key Vault, Event Grid, Functions, and Managed Identity is a huge plus. Secure access without secrets flying around is something you really appreciate in production.

Operational visibility:

Monitoring, retry logic, failure paths, and alerts are built in. When something breaks at 3 a.m., you can quickly see what failed, why, and with what input, without digging through logs for hours.

Low barrier to entry, high ceiling:

You can start with simple copy pipelines very quickly but still grow into advanced patterns: metadata-driven pipelines, conditional branching, dynamic execution, and hybrid solutions with Spark or Functions. Review collected by and hosted on G2.com.

ADF is an excellent tool at orchestration, but it can feel clunky for debugging, complex logic, and large-team development. Review collected by and hosted on G2.com.

Supports all the sources you need and handles data transformation operations efficiently Review collected by and hosted on G2.com.

It doesn’t have AI support for actions that need to be done in ADF, and more complex operations are difficult to complete quickly. Review collected by and hosted on G2.com.

It offers a drag and drop interface that allows users to build data workflows very easily, even non-technical users can leverage it while a technical user can still write a custom code if needed. Review collected by and hosted on G2.com.

Certain limitations like 5000 entities per factory and a limit of 120 activities per pipeline can be a bummer. Also, there are certain restrictions on concurrent operations. Review collected by and hosted on G2.com.

Supports 100+ connectors (SQL, NoSQL, SaaS, Self-hosted IR). It offers scalable execution using Azure-managed compute, along with built-in monitoring, logging, and alerting. It also supports CI/CD with Azure DevOps and GitHub integration, and includes RBAC for secure access. Review collected by and hosted on G2.com.

Limited error details and fragmented logs make it harder to debug pipelines. Dependency management and error handling in pipelines can also get complex, especially across enterprise-scale implementations. Review collected by and hosted on G2.com.

It is easy to use, and component based which is good for us to learn quickly and also the multiple connectors Review collected by and hosted on G2.com.

This is good in all aspects but while it comes to compute or other storage aspects it would be more cost consumptions compared to other ETL tools. Review collected by and hosted on G2.com.

What’s great about ADF is how easy it makes connecting all my different data sources whether they’re on-prem or in the cloud without having to write a lot of code. I can visually drag and drop to build complex data pipelines, automate repetitive data tasks, and seamlessly move and transform huge volumes of data as my projects grows. I can also monitor and manage everything from one place, which takes a lot of stress out of dealing with data integration and makes life much simpler for everyone involved. Review collected by and hosted on G2.com.

The things I dislike most about ADF are usually around its complexity and limitations. Debugging pipelines is often tricky and can be frustrating, especially when something fails, there aren’t many tools for step-by-step troubleshooting. If my workflow is complex, managing and understanding everything can get overwhelming with so many moving pieces and screens to keep track of. Additionally, its integration with non-Azure services is quite limited, so I may run into roadblocks if I need to connect other platforms or work in a Azure cloud setup. And while it handles simple tasks well, customizing things beyond standard connectors or data flows often means writing extra code or finding difficult workarounds. Review collected by and hosted on G2.com.

easy ETL pipeline orchestration, strong integration with Azure services, visual pipeline builder, scalable data movement, scheduling and monitoring features, good for cloud data migration Review collected by and hosted on G2.com.

debugging pipelines can be difficult, monitoring logs lack detail, UI can feel slow, complex pipelines become hard to manage, limited version control support Review collected by and hosted on G2.com.