We just raised a $30M Series A: Read our story
2019-07-29T10:11:00Z

What advice do you have for others considering Azure Data Factory?

15

If you were talking to someone whose organization is considering Azure Data Factory, what would you say?

How would you rate it and why? Any other tips or advice?

ITCS user
Guest
2424 Answers

author avatar
Real User

It works very well. I would rate Azure Data Factory an eight out of ten.

2021-11-04T19:59:04Z
author avatar
Top 10LeaderboardReal User

On a scale of one to ten, I would give Azure Data Factory a seven. Compared to Informatica, it's really crude. I think it's a very crude solution. Would I recommend Azure Data Factory? It depends if they need a straight reading in data, then I would say it's perfect. But with Informatica, you can do data storing and data quality checks - there is a lot there than just a data center. I think Azure Data Factory is a mature product. We used Version One in my project and a lot of it isn't possible on this version. The Version Two is much faster and much better. It's not at the same level as Informatica.

2021-08-31T13:03:00Z
author avatar
Top 5LeaderboardReal User

It is proven, and it works. Make sure you have a well-defined use case and build a quick prototype to ensure that it, in fact, does what you need. Give yourself some benchmarks. That's exactly what we did. We defined the use case, and then we set up Data Factory. We found a couple of things that it didn't do. We figured out a way to work around those things and have it do those things. After that, we confirmed it. It is operational, and it is doing its job. It has been pretty much error-free since then. It would become easier to use as more people become Azure-capable. If I want to find an AWS SME, I can get tons. They're expensive, but I have them. If I want to find an Azure SME, I usually have to create them. Azure was later to market than AWS. So, there are fewer people who are experts in Azure, and they are in high demand. I would rate Azure Data Factory a nine out of 10. They just don't have enough good examples out there of things.

2021-08-11T18:32:33Z
author avatar
Top 20Real User

If you have Azure as a cloud service and you want to perform ETL then Azure Data Factory is a product that I can recommend. I would rate this solution a six out of ten.

2021-05-17T14:02:46Z
author avatar
Top 20Real User

I would tell potential users that there are many technologies to do this. For example, if you like to manage big data and do something with it, it would be better to use Databricks. On a scale from one to ten, I would give Azure Data Factory a nine.

2021-04-17T15:16:14Z
author avatar
Top 20Real User

We are like an integrator. We are a data warehouse NPI consulting company and we use Data Factory to pull data from different legacy systems and do all these transformations that are necessary in order to provide analytical models. In our normal scenario is that we are providing Azure SQL Databases together with Azure Data Factory and Power BI. 80% of our customers have recognized such a scenario. On a scale from one to ten, I'd rate the solution at an eight. We've been largely happy with the capabilities of the product.

2021-03-10T08:56:59Z
author avatar
Top 20Real User

We are customers and end-users. I'd advise companies considering the solution that they need to be very clear about the use case they are trying to address. They need to understand the data ecosystem that they have and what percentage of data is coming in from the various ERP systems. Do that study properly and then come up with the right solution. If, for example, it is that the underlying data that they want to analyze is more than 60% residing in SAP, then probably Azure would not be the right platform to move ahead with. We're mostly satisfied with the product. However, getting it connected to closed ERP systems like SAP would make it more powerful. I would rate the solution eight out of ten.

2021-02-14T15:56:02Z
author avatar
Top 5LeaderboardReal User

In general, I would recommend this product. However, it depends on the target IT ecosystem. If they are utilizing a lot of Microsoft products like Power BI, Office, Project, SharePoint, and so forth, it's better to implement Data Factory because it will reduce a lot of effort spent to consume data from other sources. At this point, I can only rate based on my pre-implementation experience, so I would rate this solution an eight out of ten.

2020-12-18T22:33:34Z
author avatar
Top 20LeaderboardReal User

If you're a Microsoft shop, if you want to get there easily, I think Azure is one of the better choices. Otherwise, other tools generally require specialized skills and specialized partners to come and implement it. Once implemented, then it becomes much easier to install. I can't comment right now. I've not talked to it in that fashion. Whatever was required by us, business users have been satisfied in the Data Factory setup. On a scale of one to ten, I would give Azure Data Factory an eight.

2020-12-09T10:31:00Z
author avatar
Top 5LeaderboardReal User

I would definitely recommend this solution to anyone who is interested in using it. I would rate Azure Data Factory an eight out of ten.

2020-10-27T00:17:44Z
author avatar
Top 20Real User

I would definitely recommend Azure Data Factory. On a scale from one to ten, I would give this solution a rating of eight. If there were a larger amount of automated features, I would give them a higher rating. As I mentioned earlier, if we are working on complex applications, then there is a lot of coding involved. What we hope is that over time, there'll be less coding and more "off the shelf" functionality.

2020-10-21T11:46:00Z
author avatar
Real User

I would rate this solution a five out of ten.

2020-09-21T06:33:00Z
author avatar
Top 20Real User

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.

2020-08-19T07:57:30Z
author avatar
Top 20Real User

I would rate this solution a seven out of ten.

2020-07-13T06:55:56Z
author avatar
Top 20Real User

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, however, it means the solution isn't exactly perfect just yet.

2020-06-15T07:33:55Z
author avatar
Top 20LeaderboardReal User

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.

2020-01-12T12:03:00Z
author avatar
Top 5LeaderboardReal User

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 background you need, you will be successful. If not, then my advice would be to learn a little more about it before using Data Factory. I would rate Data Factory as an eight out of ten.

2019-12-31T09:39:00Z
author avatar
Real User

We have nine people using Azure Data Factory. On a scale of one to ten, I give it an eight.

2019-12-23T07:05:00Z
author avatar
Real User

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 solves the problems while conforming to the business model. On a scale from one to ten where one is the worst and ten is the best, I would rate the product overall as an eight-out-of-ten.

2019-12-16T08:14:00Z
author avatar
Top 20LeaderboardReal User

My advice for anybody who is implementing this solution is to first get in touch with the Microsoft team to get their support so that you don't spend too much on research. I would rate this solution a seven out of ten.

2019-12-12T07:48:00Z
author avatar
Top 20LeaderboardReal User

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 code rather than hard-coding everything into the jobs. That's the biggest recommendation. I'd rate the solution seven out of ten. It's a pretty good solution, but over the past year, I've been limited on the number of cases I have on it. If it had a better user interface and was more intuitive I would have rated it higher.

2019-12-09T10:58:00Z
author avatar
Consultant

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 is the best way to start with this service, as opposed to planning. I'd rate the solution eight out of ten.

2019-12-05T11:14:00Z
author avatar
MSP

We use both the on-premises and cloud deployment models. We typically work with enterprise-level companies. Azure Data Factory is pretty good but should be considered as an orchestrator, not as an integrated tool. We can use some building components in that tool to orchestrate the entire workflow but if we are thinking about more details, processing, or data modification during the flow, we'd have to consider Azure Databricks or Data Flow for making those calculations or changes. Users will need Azure Data Factory plus third party tools to reach that level of functionally. I would recommend using Data Factory. I don't have a lot of experience with integration or with integration services, for example, SQL server integration services. However, there are points that should be considered if you are already using SQL server integration services already. You can implement the packages already prepared in Azure Data Factory. It's something that needs to be considered when deciding which technology you are going to use. I'd rate the solution eight out of ten.

2019-11-18T07:22:00Z
author avatar
Consultant

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 just click and go. I would rate this solution ten out of ten.

2019-07-29T10:11:00Z
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: December 2021.
554,676 professionals have used our research since 2012.