Azure Data Factory Reviews & Product Details

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.

Schedules and various types of schedules available in ADF. Review collected by and hosted on G2.com.

We can’t see all our pipeline activities in single page while monitoring. Also data gets erased after 50 days Review collected by and hosted on G2.com.

It's low code interface and integration flexibility is what I like best about azure data factory. You can connect to a wide range of data sources and create complex data pipelines visually without writing heavy code Review collected by and hosted on G2.com.

The debugging experience on the portal can be slow especially for large data flows. Also data flow mapping UI could be more responsive. Review collected by and hosted on G2.com.

I find Azure Data Factory user friendly - it's easy to navigate and find what I am looking for. Review collected by and hosted on G2.com.

Nothing I particularly dislike - haven't used many similar tools. Review collected by and hosted on G2.com.

Orchestrating processes by using various activities within Data Factory. Review collected by and hosted on G2.com.

complex pipeline structure and hard to track Review collected by and hosted on G2.com.

Linked services to connect to all types of services Review collected by and hosted on G2.com.

Simple control flow becomes very complex to achieve Review collected by and hosted on G2.com.

1. Easy to use (Gives access to read data from multiple sources and data of multiple format)

2. Linked services gives lots of connection with other platform almost making it cross platform

3. Excellent ETL tool with lots of inbuilt activities.

4. Connection with Databricks notebook and it's integration is top class.(In case of complex ETL works we can use Databricks and call it directly to ADF pipeline)

5. Data Flow are easy to implement and very minimal code is required. Review collected by and hosted on G2.com.

Fails to perform complex transformation.

Limitation of not able to perform more operations than Int32. Review collected by and hosted on G2.com.

What I like best about Azure Data Factory is its robust and versatile data integration capabilities. It offers a wide range of connectors and tools to efficiently manage and transform data from various sources. Its user-friendly interface, combined with the flexibility to handle complex workflows, makes it an excellent choice for orchestrating data pipelines. The seamless integration with other Azure services also enhances its functionality, making it a powerful tool for data engineering tasks. Review collected by and hosted on G2.com.

The one aspect that could be improved is the cost management, if not carefully monitored, the expenses can add up quickly, particularly when dealing with large volumes of data or frequent pipeline runs. Review collected by and hosted on G2.com.

The best thing I like is its very easy to integrate with various Database and very easy to use the linked servies and also very affordable Review collected by and hosted on G2.com.

The ADF is very limited logging of pileine and monitoring the pipeline Review collected by and hosted on G2.com.

The easiness and the UI is the best among all other of it's competition. The UI is very easy and you create data pipeline in a a few click of buttons. The workflow allows you to perform data transformation which is again a drag-drop feature which allows new users to easily use it. Review collected by and hosted on G2.com.

I only thing which I think is missing is an easier way to integrate with power bi. I wish they could have provide more feature or easier way to refresh and load power bi semantic models. Review collected by and hosted on G2.com.