Try our new research platform with insights from 80,000+ expert users
Anirban Bhattacharya - PeerSpot reviewer
Practice Head, Data & Analytics at a tech vendor with 10,001+ employees
Real User
Beneficial guides, scales well, and helpful support
Pros and Cons
  • "The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
  • "Azure Data Factory can improve the transformation features. You have to do a lot of transformation activities. This is something that is just not fully covered. Additionally, the integration could improve for other tools, such as Azure Data Catalog."

What is our primary use case?

Azure Data Factory can be deployed on the cloud and hybrid cloud. There have been very few deployments on private clouds.

What is most valuable?

The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain.

Across the whole field of use, from accepting the ingestion and real-time SaaS ingestion for which we often use other components. These areas have been instrumental across the board.

What needs improvement?

Azure Data Factory can improve the transformation features. You have to do a lot of transformation activities. This is something that is just not fully covered. Additionally, the integration could improve for other tools, such as Azure Data Catalog.

For how long have I used the solution?

I have been using Azure Data Factory for approximately four years.

Buyer's Guide
Azure Data Factory
August 2025
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
865,295 professionals have used our research since 2012.

What do I think about the stability of the solution?

The stability of Azure Data Factory is good.

I rate the scalability of Azure Data Factory a seven out of ten.

What do I think about the scalability of the solution?

Azure Data Factory is scalable. The solution can move up and be aligned to resources or scaled down.

We have a lot of customers using the solution, approximately 100.

How are customer service and support?

The support from Azure Data Factory is very good. There are some improvements needed.

I rate the support from Azure Data Factory a four out of five.

How would you rate customer service and support?

Positive

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

I have previously used Informatica. When comparing Informatica to Azure Data Factory, Informatica is a bit behind.

How was the initial setup?

The initial setup of Azure Data Factory is not complex if you know what you are doing. If you do not know the technology you will have a problem.

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

Azure Data Factory gives better value for the price than other solutions such as Informatica.

What other advice do I have?

I recommend this solution to others.

I rate Azure Data Factory an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
Zubair_Ahmed - PeerSpot reviewer
Senior Consultant at Veraqor
MSP
Top 5
Seamless cloud-based data integration providing a versatile platform with scalable data processing, diverse data connectors, and comprehensive monitoring and management capabilities
Pros and Cons
  • "The most valuable aspect is the copy capability."
  • "Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."

What is our primary use case?

My task involves extracting data from a source, performing necessary transformations, and subsequently loading the data into a target destination, which happens to be Azure SQL Database.

How has it helped my organization?

The company is experiencing significant benefits as one of our customers is successfully implementing the solution we provide. We offer support to the customer in utilizing Azure Data Factory, and their satisfaction level is quite high.

What is most valuable?

The most valuable aspect is the copy capability.

What needs improvement?

Implementing a standard pricing model at a more affordable rate could make it accessible to a larger number of companies. Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue.

For how long have I used the solution?

I have been working with it for more than six months.

What do I think about the stability of the solution?

The stability is quite satisfactory. I would rate it nine out of ten.

What do I think about the scalability of the solution?

It provides impressive scalability. There are a total of eight switches currently in use. I would rate it nine out of ten.

How are customer service and support?

Technical support is available for all products, and you can reach them without any hassle. They offer assistance through various channels and are proficient in addressing technical issues, ensuring the highest level of support. I would rate it nine out of ten.

How would you rate customer service and support?

Positive

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

In the past, we used Oracle Data Integrator.

How was the initial setup?

The initial setup has been smooth and without any difficulties.

What about the implementation team?

Deployment time is contingent on the volume of data. If there are millions of records to process, it will understandably take a significant amount of time. Conversely, for smaller datasets, the deployment can be relatively quick, often within a matter of minutes to reach the destination. In the cloud deployment process, the initial step involves defining the instance. Subsequently, in the copy activity, we specify both the source and destination. Following this, communication with the destination takes place. This process constitutes the necessary steps for deployment, and we proceed accordingly. Due to the cloud system being provided by Microsoft, they handle the maintenance of the servers.

What was our ROI?

The routing value is quite impressive, especially considering that we successfully implemented it for one of our clients, and they expressed satisfaction. For our latest projects, we've acquired additional customers who also require this product for their setups. I would rate it eight out of ten.

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

While I can't specify the actual cost, I believe it is reasonably priced and comparable to similar products.

What other advice do I have?

I would recommend considering this solution because, from my perspective, it is not overly expensive. The pricing seems reasonable, making it a viable option to explore. Overall, I would rate it nine out of ten.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Azure Data Factory
August 2025
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
865,295 professionals have used our research since 2012.
reviewer826419 - PeerSpot reviewer
CIO, Director at Prosys Infotech Private Limited
Real User
Easy to deploy, good support, and scalable
Pros and Cons
  • "We have been using drivers to connect to various data sets and consume data."
  • "We require Azure Data Factory to be able to connect to Google Analytics."

What is our primary use case?

The primary use case is to connect to various different data sets and do an EAT into our data warehouse.

What is most valuable?

We have been using drivers to connect to various data sets and consume data. The solution gives everything under one roof, which is an important feature.

What needs improvement?

We require Azure Data Factory to be able to connect to Google Analytics.

For how long have I used the solution?

I have been using the solution for two years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

The solution is scalable.

How are customer service and support?

We had a few technical calls with the Microsoft technical support team for some issues that we were facing, which they helped us resolve.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup is straightforward and the team is able to deploy between six and seven days.

What about the implementation team?

The implementation was completed in-house.

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

The cost is based on the amount of data sets that we are ingesting. The more data we ingest the more we pay.

What other advice do I have?

I give the solution a nine out of ten. We have been happy with all the customer implementations, and the customers are satisfied with the ADF pipelines. We are also currently examining the Synapse pipelines, which are likely similar.

We have six developers using the solution in our organization.

People should use the solution for two reasons. Firstly, we can switch off any data pipelines we set up to save costs. Secondly, there are several connectors available in one place, including most standard connectors.

Which deployment model are you using for this solution?

Public Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer.
PeerSpot user
Gyanendu Rai - PeerSpot reviewer
Senior Tech Consultant at Crowe
Real User
Improved flexibility when compared to other solutions
Pros and Cons
  • "I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
  • "I would like to be informed about the changes ahead of time, so we are aware of what's coming."

What is our primary use case?

Azure Data Factory allows us to provide BI service. We pull the data and put it into Synapse. From there, we create our dimension fact tables that are being used for reporting. 

What is most valuable?

The most valuable feature of Azure Data Factory is the improved flexibility compared to SSIS that we previously used for our ETL transformation. I also enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management. All we need to do is create ARM templates.

What needs improvement?

Microsoft is constantly upgrading its product. Changes can happen every week. Every time you open Data Factory you see something new and need to study what it is. I would like to be informed about the changes ahead of time, so we are aware of what's coming.

In future releases, I would like to see Azure Data Factory simplify how the information of logs is presented. Currently, you need to do a lot of clicks and go through steps to find out what happened. It takes too much time. The log needs to be more user-friendly.

For how long have I used the solution?

I have been using Azure Data Factory for two years.

What do I think about the scalability of the solution?

Scalability depends on the use case. 

How are customer service and support?

As far as customer service and support with Azure Data Factory, we are not always satisfied with the response time. However, once they attend to the issue, everything is good.

How would you rate customer service and support?

Positive

How was the initial setup?

All we needed to do was create ARM templates and deployment is easy.

What about the implementation team?

We deployed in-house. For deployment, we use ARM templates that are a part of Azure's deployment strategy. It's not only available for Data Factory, it is built in. It links with DevOps, then the ICD integration.

What other advice do I have?

Azure Data Factory is a good tool. Given that the data platform ecosystem is provided by Microsoft, you know it is good.

I would rate the solution an eight out of ten overall.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
Pavan Yogender - PeerSpot reviewer
Founder and CEO at Zertain
Real User
A stable solution that can be used to set up a data lake information repository
Pros and Cons
  • "Most of our customers are Microsoft shops and prefer Azure Data Factory because they have good licensing options and a trust factor with Microsoft."
  • "Azure Data Factory's pricing in terms of utilization could be improved."

What is our primary use case?

We use Azure Data Factory to set up a data lake information repository.

What is most valuable?

Most of our customers are Microsoft shops and prefer Azure Data Factory because they have good licensing options and a trust factor with Microsoft. Our core customers are traditional Microsoft shops who prefer to expand on Microsoft on-cloud.

What needs improvement?

Azure Data Factory's pricing in terms of utilization could be improved. Our customers complain that the solution's bills keep growing.

For how long have I used the solution?

I have worked with Azure Data Factory for more than five years as a consultant.

What do I think about the stability of the solution?

Azure Data Factory is a pretty stable solution. I rate Azure Data Factory a nine out of ten for stability.

What do I think about the scalability of the solution?

Azure Data Factory is a scalable solution. We have around 15 to 20 customers, of which about 8 to 10 use Azure Data Factory.

How was the initial setup?

Azure Data Factory's initial setup needs some amount of professional training and qualification.

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

It seems very low initially, but as the data grows, the solution’s bills grow exponentially.

What other advice do I have?

Azure Data Factory is deployed on-cloud for our clients.

Azure Data Factory is a pretty solid solution with all the factors and integration built in. It's as good as any product.

I recommend users compare with Snowflake before choosing Azure Data Factory. We've had customers who prefer Snowflake just for its ease of use. Since we're not a Microsoft official reseller, I give options to customers and then let them pick and choose some from Azure Data Factory, Snowflake, or anything on Amazon.

Overall, I rate Azure Data Factory an eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer2148636 - PeerSpot reviewer
BI Technical Development Lead at a energy/utilities company with 10,001+ employees
Real User
A solution that is ideal for individuals or teams looking to extract, transform, and load data into a database
Pros and Cons
  • "Feature-wise, one of the most valuable ones is the data flows introduced recently in the solution."
  • "Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."

What is our primary use case?

Our company uses the solution to extract, transform, and load the data into the database.

What is most valuable?

Feature-wise, one of the most valuable ones is the data flows introduced recently in the solution.

What needs improvement?

Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory. Although the platform displays which pipelines are running, it doesn't offer a monitoring tool that allows for the sequential execution of pipelines and the ability to visualize end-to-end data flow. As such, this feature is currently missing from the platform.

For how long have I used the solution?

I have been using Azure Data Factory for more than six years. Also, I am an end-user of the solution, and I initially used to work on Azure Data Factory V1. Now, I have switched to Azure Data Factory V2.

What do I think about the stability of the solution?

It is a stable solution. Stability-wise, I rate the solution an eight or nine out of ten.

What do I think about the scalability of the solution?

Scalability-wise, I rate the solution a seven or eight out of ten. So, scalability can be improved. Also, there are around 150 people in my company using the solution. Moreover, we use the solution daily in our company.

How are customer service and support?

I rate the technical support between eight to nine out of ten.

How would you rate customer service and support?

Positive

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

Previously, I was using Informatica. My company wanted to shift to a solution that could be deployed on the cloud, so we chose Azure Data Factory.

How was the initial setup?

The solution's initial setup process was easy. On a scale where one is difficult and ten is easy, I rate the initial setup process an eight out of ten. The solution is deployed on the cloud.

Since multiple projects are going on in my organization, there is no uniformity in the time taken to deploy the solution in our company. However, I can say that it only takes a few days to carry out the deployment process.

Our organization has multiple project teams, so each team carries out its deployment process.

To give an average, I would consider that if there are fifty ongoing projects in our company, and if we consider a person from each project, fifty people are needed for the deployment and maintenance process.

What about the implementation team?

The solution's implementation process was done with our in-house team's help.

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

I cannot comment on the pricing parts since our company's admin team handles it.

What other advice do I have?

Those who want to move to a cloud platform can choose Azure Data Factory since it is the best tool. Since certain improvements are required in the solution, I rate the overall solution an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Kevin McAllister - PeerSpot reviewer
Executive Manager at Hexagon AB
Real User
Light, inexpensive way to ingest data
Pros and Cons
  • "Data Factory's best features are simplicity and flexibility."
  • "Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."

What is our primary use case?

I primarily use Data Factory to ingest data. For example, if we need to pull data into our data warehouse from somewhere like Azure Event Hub or salesforce.com.

How has it helped my organization?

We have telemetry that streams into an Azure Event Hub, and Data Factory allowed us to move that data from the Event Hub into our data lake and reduce the cost of that compared to the other tooling we were using.

What is most valuable?

Data Factory's best features are simplicity and flexibility. It's been very easy to set up connections to different types of data sources to pull data into our warehouse.

What needs improvement?

Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features.

For how long have I used the solution?

I've been using Data Factory for about three years.

What do I think about the stability of the solution?

I would rate Data Factory's stability eight out of ten.

What do I think about the scalability of the solution?

I would rate Data Factory's scalability eight out of ten.

How was the initial setup?

The initial setup was straightforward, and only one person was required for deployment.

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

I would rate Data Factory's pricing nine out of ten.

What other advice do I have?

I think Data Factory is a good fit when you need a light, inexpensive way to ingest data. I would rate it eight out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Joaquin Marques - PeerSpot reviewer
CEO - Founder / Principal Data Scientist / Principal AI Architect at Kanayma LLC
Real User
Provides great consistency that has made implementations less buggy and less complex
Pros and Cons
  • "The function of the solution is great."
  • "Lacks a decent UI that would give us a view of the kinds of requests that come in."

What is our primary use case?

We use this solution to quickly instantiate certain components in Azure with the aim of having consistent use of certain components and objects. It provides one point of reference rather than having the need to replicate points of references, and then having to keep them in sync. 

How has it helped my organization?

It has helped our company by providing consistency. For example, by making sure that the way certain objects and components are defined is consistent throughout every step. If things change at any point, they should be reflected at all points. It's the consistency that makes implementations less buggy and less complex.

What is most valuable?

The function is the central point of reference and the most valuable thing about Data Factory.

What needs improvement?

I'd like to see videos on YouTube or the Microsoft site with more detailed implementations. The solution lacks a decent UI that allows us to see what kinds of requests are for what objects and how the population of objects is being requested and compared. Right now we have to look at logs to get an idea of what types of calls the data factory receives in what sequence, for example. It would be nice to be able to see it graphically because we currently have to interpret the logs and then create a graphical representation to have an idea of what's going on. In general, it could be simplified and made more user-friendly.

For how long have I used the solution?

I've been using this solution for six months.

What do I think about the stability of the solution?

This solution is stable. 

What do I think about the scalability of the solution?

There are thousands of users so the solution is scalable. 

How are customer service and support?

The customer service is excellent. 

How would you rate customer service and support?

Positive

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

I previously used a combination of solutions to achieve the same end. Data Factory simplifies things which is why we switched to it. 

How was the initial setup?

The initial setup was complex. The deployment was carried out in-house and we had around 10 people involved in the implementation. 

What was our ROI?

In terms of time and effort savings, we have a return on our investment. 

What other advice do I have?

It's important to have a good data model before you start using the solution; an idea of the types of data architecture, data objects and components in order to use them. Because of the lack of more user-friendly interfaces, especially for the people debugging the system, I rate this solution eight out of 10.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.
Updated: August 2025
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.