Azure Data Factory Reviews

Azure Data Factory is the #4 ranked solution of our top Data Integration Tools tools. It's rated 3.9 out of 5 stars, and is most commonly compared to Informatica PowerCenter - Azure Data Factory vs Informatica PowerCenter

Filter by:
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
MayankRakesh
Consultant
Sr. Technology Architect at a tech services company with 10,001+ employees
Dec 10 2019

What is most valuable?

Data Factory itself is great. It's pretty straightforward. You can easily add sources, join and lookup information, etc. The ease of use is pretty good. They have a lot of other components like a newer monitor, which helps track and generate alerts for any failed jobs and things of that nature… more »

What needs improvement?

At this point in time, they should work on somehow integrating the big data capabilities within it. I have not explored it, but it would be good if somehow we could call a Spark job or something to do with the Spark SQL within ADS so that we wouldn't need a Spark tested outside. On the UI side, they… more »

What's my experience with pricing, setup cost, and licensing?

In terms of licensing costs, we pay somewhere around S14,000 USD per month. There are some additional costs. For example, we would have to subscribe to some additional computing and for elasticity, but they are minimal. For disaster recovery and readability setups, we did that on Data Lake.

What other advice do I have?

We use the public cloud deployment model. I'd warn others to ensure that the design should be frozen before you start building because overriding each other's code and managing code takes effort. To avoid or to reduce that effort, ensure that the design is frozen. You can build some configurable… more »
Real User
Technical Architect at a computer software company with 10,001+ employees
Dec 31 2019

What is most valuable?

From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connectors and we can connect them to the system and copy the data from its respective system to any environment. That is the best… more »

What needs improvement?

The user interface could use improvement. It's not a major issue but it's something that can be improved. It has the ability to create separate folders to organize objects, Data Factory objects. But any time that we created a folder we were… more »

Which solution did I use previously and why did I switch?

I have only used Data Factory for the cloud. For on-prem we have used SSIS.

What other advice do I have?

The advice that I would give to someone considering this solution is to have some background in data warehousing and ETL concepts. Have the background about data warehousing and ETL that extract, transform, and load. If you have the… more »

Which other solutions did I evaluate?

We also evaluated AWS.
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
438,725 professionals have used our research since 2012.
Real User
Delivery Manager at a tech services company with 1,001-5,000 employees
Jan 20 2020

What is most valuable?

Our clients find that this solution has a very good performance. They like the speed. It is easy to deploy workflows and schedule jobs. You can just click on the desktop and it works.

What needs improvement?

The setup and configuration process could be simplified.

What's my experience with pricing, setup cost, and licensing?

This is a cost-effective solution.

Which solution did I use previously and why did I switch?

We have used other ETL solutions in the past, and Azure Data Factory is the best one. Compared to SSIS, for example, ADF is easier to use and the performance is better. Our clients are migrating from… more »

What other advice do I have?

Within the next six months, we are planning to enter into the machine learning part of this solution. This is a product that I can recommend. I would rate this solution an eight out of ten.

Which other solutions did I evaluate?

We have another team that is moving to AWS, but for now, we will continue working with Azure Data Factory. Once they have explored the AWS solution fully, we will compare the two.
Real User
Head of IT at a logistics company with 10,001+ employees
Dec 19 2019

What is most valuable?

The most valuable part of this product is the ease of use. It is easy to use and rather intuitive. Because it is easy to use, you can do things with it easily. The more things make your work easy, the more valuable they are.

What needs improvement?

Because I have not really done a really deep benchmark against competitors, I may not be familiar enough with the potential of competing products and capabilities to be able able to say what is missing or should be improved definitively. From my perspective, the pricing seems like it could be more user-friendly. Of course, nothing is ever as inexpensive as you want. Perhaps one good additional… more »

What other advice do I have?

The advice I would give to someone who is looking to implement this product is to understand the IT technology of the product first and why it would be needed. That is the point where you have to start. Next, you have to understand if the product itself fits your organizational needs. That is you have to look at the business requirements and see whether the product really fits the organization and… more »
Consultant
Principal Consultant at a tech services company with 11-50 employees
Jul 29 2019

What is most valuable?

I like the feature that allows you to connect to different sources. You can go through forms and click on them and you don't have to provide the scripts. The solution has a good interface and the integration with GitHub is very useful. There is also a self-service integration that allows you to run… more »

What needs improvement?

I think more integration with existing Azure platform services would be extremely beneficial. In the next release, it's important that some sort of scheduler for running tasks is added. A built-in scheduling mechanism for running the treasury will be a very helpful improvement.

What's my experience with pricing, setup cost, and licensing?

I'm not sure of the specific cost, but it is monthly and is somewhere in the ballpark of a few hundred Euros. You don't have to pay for extras. Everything is included in the cost.

What other advice do I have?

I don't use Azure Data Factory for my own company; I help clients implement the solution for their companies. In terms of advice that I would give to others looking to implement the solution, I would say you have to learn. You have to really understand the overall concept. It does not allow you to… more »
Real User
Data Strategist | Azure Solutions Architect at a tech services company with 11-50 employees
Jun 19 2020

What is most valuable?

So far, I'm quite happy with the solution overall. It's got a lot of tools that I use in my work, and these are items I'm already recommending to my clients. I'm quite happy with it.

What needs improvement?

I'm not sure if I have any complaints about the solution at the moment. There are a few bits and pieces that we would like to see improved. These include improvements related to the solution's ease of use and some quality flash upgrades. However, these are minor complaints. If the user interface was… more »

What's my experience with pricing, setup cost, and licensing?

I don't have any information about the pricing. I don't deal with that aspect of the solution.

What other advice do I have?

I typically work with small to medium-sized companies. I'm a consultant, so I give different advice based on what my clients need and what they want to do. However, I would recommend this product. I'd rate the solution eight out of ten. All of the issues I have with the solution are very minor… more »
Avi Shvartz
Real User
CTO at a construction company with 1,001-5,000 employees
Aug 19 2020

What is most valuable?

The reason that we implemented this product is for the full integration with the whole Azure environment. It is very important because you don't have to deal with security, identity flow, or audit flow. The security of the agent that is… more »

How has it helped my organization?

The integration with the whole environment is smooth and transparent.

What needs improvement?

The pricing scheme is very complex and difficult to understand. Analyzing it upfront is impossible, so we just decided to start using it and figure out the costs on a weekly or monthly basis.

Which solution did I use previously and why did I switch?

We started with iConduct and as we migrated to the Azure environment, we began the process of switching to the Microsoft Azure Data Factory.

What other advice do I have?

To this point, we are still learning the system and have only tried a very simple data flow. At this point, we haven't had any issues. I would rate this solution an eight out of ten.
Consultant
Microsoft Consultant at a tech services company with 201-500 employees
Dec 05 2019

What is most valuable?

The support for SAP services and databases, specifically SAP HANA, has been a game-changer for us.

What needs improvement?

It would be helpful if they could adjust the data capture feature so that when there are source-side changes ADF could automatically figure it out. The solution needs to integrate more with other providers and should have a closer integration with Oracle BI.

What's my experience with pricing, setup cost, and licensing?

In general, we've been satisfied with the pricing. However, since it's a service based on usage, it's really hard to estimate the cost in advance for this product. This makes it hard to quote. It's not so easy to estimate the costs in advance when giving a quote. That makes it difficult to convince… more »

What other advice do I have?

We primarily use the solution in a hybrid environment. We're Azure partners. I would suggest others start with a small POC and with a smaller dataset or simple pipeline to test the product before fully implementing it. Users shouldn't hesitate to try it, because there are not so many risks. Practice… more »
See 6 More Azure Data Factory Reviews

What is Azure Data Factory?

Create, schedule, and manage your data integration at scale with Azure Data Factory - a hybrid data integration (ETL) service. Work with data wherever it lives, in the cloud or on-premises, with enterprise-grade security.

Azure Data Factory customers

Milliman, Pier 1 Imports, Rockwell Automation, Ziosk, Real Madrid