Our primary use case is mainly for ETL and transforming the data and then using it for power VA. So there we are handling multiple projects. It is not just a single thing, but mainly used at the end is data analytics only.
Senior Consultant at a computer software company with 1,001-5,000 employees
Top notch stability, technical support very good, and multiple project client
Pros and Cons
- "I am one hundred percent happy with the stability."
- "I would like to see this time travel feature in Snowflake added to Azure Data Factory."
What is our primary use case?
What needs improvement?
I would like to see this time travel feature in Snowflake added to Azure Data Factory. In addition to taking care of data internally, how it is instead of using indexing, they have some different mechanisms to quickly execute the query instead of normal indexes. Both of these would be great to see implemented in future upgrades.
For how long have I used the solution?
I have been working with Azure Data Factory for the past twelve months.
What do I think about the stability of the solution?
I am one hundred percent happy with the stability.
Buyer's Guide
Azure Data Factory
October 2026
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: October 2026.
916,582 professionals have used our research since 2012.
How are customer service and support?
Technical support is excellent.
What other advice do I have?
I would rate Azure Data Factory an eight on a scale of one to 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?
Microsoft Azure
Disclosure: My company has a business relationship with this vendor other than being a customer. customer/partner
Senior Director/ Advisory Architect at a tech vendor with 10,001+ employees
Mature and highly configurable solution
Pros and Cons
- "Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
- "Data Factory's performance during heavy data processing isn't great."
What is most valuable?
Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure. It's also highly configurable and integrates well with the rest of the Azure services.
What needs improvement?
Data Factory's performance during heavy data processing isn't great.
What do I think about the stability of the solution?
Data Factory is stable - I have customers running thousands of jobs a day without problems.
What do I think about the scalability of the solution?
Data Factory is scalable.
How are customer service and support?
Microsoft's technical support is pretty good.
How was the initial setup?
The initial setup is complex because there are a lot of prerequisites, including plumbing in the network, but that's typical for any cloud-based solution.
What other advice do I have?
Data Factory is a good, mature solution, and I would rate it as eight out of ten.
Which deployment model are you using for this solution?
Private Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
Buyer's Guide
Azure Data Factory
October 2026
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: October 2026.
916,582 professionals have used our research since 2012.
ETL/BI Senior Consultant at Qrious
A good data migration tool that has strong security features, but needs more development to be able to deal with complex data transformations
Pros and Cons
- "This solution has provided us with an easier, and more efficient way to carry out data migration tasks."
- "This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations."
What is our primary use case?
We mainly use this solution to carry out data movement and transformation.
What is most valuable?
This solution has provided us with an easier, and more efficient way to carry out data migration tasks.
What needs improvement?
This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations.
For how long have I used the solution?
We have been using this solution for a year.
What do I think about the stability of the solution?
We have found this to be a stable solution.
What do I think about the scalability of the solution?
This is an easily scalable product, due to it being cloud-based.
How are customer service and support?
The customer support for this solution is very good.
How was the initial setup?
The initial setup of this product is straightforward, if you deploy the solution using a template; rather than implementing the solution first, and configuring the features afterwards.
What about the implementation team?
We implemented the product using both in-house staff, and members of a vendor team. The vendor team were very helpful, and gave good advice while we were deploying the solution.
What other advice do I have?
We would recommend this solution as it is very solid and has good security features.
I would rate this solution an eight out of 10.
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
Head of Product at Tata Consultancy
Stable storage solution used to extract and store data to improve our BI functionality
Pros and Cons
- "When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit."
- "The one element of the solution that we have used and could be improved is the user interface."
What is our primary use case?
When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit. We use this solution to collect data from multiple data sources and store it in the cloud. We are using it every day and sometimes multiple times a day.
What needs improvement?
We use this solution within a limited context, specifically for extracting data and moving it to the Azure Cloud to develop our BI solution. Based on our usage, we have not found any challenges using the solution but have not explored every feature. The one element of the solution that we have used and could be improved is the user interface.
For how long have I used the solution?
I have used this solution for four years.
What do I think about the stability of the solution?
This is a stable solution.
How are customer service and support?
We have not had a reason to reach out to the support team. The documentation that they provide has been good enough for our technical team to work out the solution that we needed to use.
What other advice do I have?
I would advise future users of this solution to have a clear definition of their use case. In my experience in certain contexts, PBI worked great for us but we did have concerns around security. The most important thing is to contextualize the use of this tool to work out if it meet the needs of a particular business.
I would rate this solution a nine out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PRESIDENT at a computer software company with 51-200 employees
Flexible, responsive support, and good integration
Pros and Cons
- "The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components."
- "Azure Data Factory can improve by having support in the drivers for change data capture."
What is our primary use case?
We use Azure Data Factory to connect to clients' on-premise networks and data sources to bring the data into Azure. Additionally, Azure Data Factory orchestrates data movement and transformations. It can connect to a number of different cloud data sources to bring the information into something, such as a data lake or a formal SQL database. Azure Data Factory has the ability to handle large data workloads and can orchestrate them well.
What is most valuable?
The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components.
What needs improvement?
Azure Data Factory can improve by having support in the drivers for change data capture.
For how long have I used the solution?
I have been using Azure Data Factory for approximately three years.
What do I think about the stability of the solution?
Azure Data Factory is a very reliable and stable solution.
What do I think about the scalability of the solution?
The solution is highly scalable.
How are customer service and support?
The technical support is very good, they are responsive.
Which solution did I use previously and why did I switch?
We previously use Attunity and we switch to Azure Data Factory mainly because of cost reasons and integration.
The biggest difference between Azure Data Factory and Attunity is Attunitys has the ability to perform change data capture. Whereas Azure Data Factory is more centered around batch or bulk loads.
How was the initial setup?
The initial setup is of a moderate level of difficulty. However, it can be complex. The solution is able to fit both of our use cases.
What about the implementation team?
We normally use one or two people to update and maintain Azure Data Factory.
What's my experience with pricing, setup cost, and licensing?
There's no licensing for Azure Data Factory, they have a consumption payment model. How often you are running the service and how long that service takes to run. The price can be approximately $500 to $1,000 per month but depends on the scaling.
What other advice do I have?
My advice to others that want to implement Azure Data Factory is to use a metadata approach.
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
Senior Data Engineer at a real estate/law firm with 201-500 employees
Effective, easy to scale, stable, and reasonably priced
Pros and Cons
- "It's extremely consistent."
- "I like Azure Data Factory, it works quite well."
- "Real-time replication is required, and this is not a simple task."
What is most valuable?
I like Azure Data Factory, it works quite well.
It is always effective. It's extremely consistent.
What needs improvement?
The only thing I wish it had was real-time replication when replicating data over, rather than just allowing you to drop all the data and replace it. It would be beneficial if you could replicate it.
Real-time replication is required, and this is not a simple task.
For how long have I used the solution?
We are using the latest version of Azure Data Factory.
What do I think about the stability of the solution?
I have no issues with the stability of the Azure Data Factory. We have not had any glitches.
What do I think about the scalability of the solution?
Azure Data Factory is extremely simple to scale.
This solution is used by a dozen people in our company.
How are customer service and support?
I have not contacted technical support. We haven't needed the assistance of technical support.
Which solution did I use previously and why did I switch?
We use Microsoft products such as Azure Databricks.
Azure Data Factory is the only solution that I have used since I started with this company.
How was the initial setup?
The initial setup is pretty straightforward. However, there is a bit of a learning curve, but once you get it, it's pretty simple.
What's my experience with pricing, setup cost, and licensing?
It's not particularly expensive.
What other advice do I have?
It works very well.
I would rate Azure Data Factory an eight out of ten.
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.
Lead BI&A Consultant at a computer software company with 10,001+ employees
Stable and works fine but is relatively crude
Pros and Cons
- "In terms of my personal experience, it works fine."
- "Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."
- "Compared to Informatica, it's really crude. I think it's a very crude solution."
What is our primary use case?
We had an old, traditional data warehouse. We decided to put it into the cloud and we used Azure Data Factory to reform the EEL process from SQL server integration services to extra data.
What is most valuable?
Azure Data Factory was chosen by the team that I was not on at the time and who decided that this would be the move to the future. So I just went along with it.
In terms of my personal experience, it works fine.
What needs improvement?
We didn't have a very good experience. The first steps were very easy but it turned out that we used Europe for a Microsoft data center, also partly abroad for our alpha notes. As soon as we started using Azure Data Factory, the bills got higher and higher. At first we couldn't understand why, but it is very expensive to put data into a data center abroad. So instead, we decided to use only Northern Europe, which worked out for a while in the beginning. And then we had nothing to show for it. They gave me a really hard time for this.
Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters.
What I really miss is the integration of Microsoft TED quality services and Microsoft Data services. If they were to combine those features in Data Factory, I think they would have a very strong proposition. They promise something like that on Microsoft Congress. That was years ago and it's still not here.
For how long have I used the solution?
I have been using Azure Data Factory for a couple of years now, since about 2017.
What do I think about the stability of the solution?
Azure Data Factory is a stable solution.
What do I think about the scalability of the solution?
Yes, Azure Data Factory is scalable.
Which solution did I use previously and why did I switch?
We previously used SSIS because of Microsoft.
How was the initial setup?
The installation is straightforward.
What about the implementation team?
We use data engineers to do the install.
What's my experience with pricing, setup cost, and licensing?
We pay monthly for this.
What other advice do I have?
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.
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.
Enterprise Data Architect at a financial services firm with 201-500 employees
Good support, easy to use, and integrates well with the rest of the activities on Azure
Pros and Cons
- "Its integrability with the rest of the activities on Azure is most valuable."
- "It can improve from the perspective of active logging. It can provide active logging information."
What is our primary use case?
In my new organization, we are currently analyzing this solution. In my previous organization, I have worked with Azure Data Factory and Databricks.
It is deployed in a virtual private cloud.
What is most valuable?
Its integrability with the rest of the activities on Azure is most valuable.
It is also easier to work with. It has a nice user interface that would seem very familiar to some of the people who are coming from Microsoft SSIS and other similar kinds of activities. It makes it easy for them to pick it up quickly.
What needs improvement?
It can improve from the perspective of active logging. It can provide active logging information.
It should provide support for changing data capture on several other platforms.
For how long have I used the solution?
I have been using this solution for two years.
What do I think about the scalability of the solution?
It is scalable. From the security perspective, it depends on how we implement it. It depends on the organization, but I don't see a challenge.
In my previous organization, we had close to a hundred people.
How are customer service and technical support?
Their technical support is very good.
How was the initial setup?
It was very easy.
What other advice do I have?
I would generally recommend this solution if you have an Azure setup or Azure as a baseline.
I would rate Azure Data Factory an eight out of 10.
Which deployment model are you using for this solution?
Private Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Senior Systems Analyst at a non-profit with 201-500 employees
Good stability and scalability with a valuable data copy template
Pros and Cons
- "The data copy template is a valuable feature."
- "The data copy template is a valuable feature, and with the pipeline template, it takes only a few clicks for the on-premises data to come in."
- "There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
What is our primary use case?
We use the solution to gather data from four separate operational systems.
What is most valuable?
The data copy template is a valuable feature. With the pipeline template, it takes only a few clicks for the on-premises data to come in.
What needs improvement?
There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run. I believe this requires a bit of development through power ups, but it would be nice to have a task for firing off an email through the GUI.
For how long have I used the solution?
I have been using Azure Data Factory for around six months.
What do I think about the stability of the solution?
When it comes to stability, the solution is similar to the previous Azure Synapse Analytics. They are both very easy.
What do I think about the scalability of the solution?
When it comes to scalability, the solution is similar to the previous Azure Synapse Analytics. They are both very easy.
What's my experience with pricing, setup cost, and licensing?
The licensing cost is included in the Synapse.
What other advice do I have?
I rate Azure Data Factory as an eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Director of Product Management at EIM solutions
Powerful data transformations and the stability is good. Performance is good
Pros and Cons
- "The most valuable features are data transformations."
- "The stability of the Azure Data Factory is very good."
- "The speed and performance need to be improved."
What is our primary use case?
Our primary use case is data loading.
What is most valuable?
The most valuable features are data transformations.
What needs improvement?
The speed and performance can be further improved.
This solution should be able to connect with custom APIs.
For how long have I used the solution?
We have been using this solution for one or two months.
What do I think about the stability of the solution?
The stability of the Azure Data Factory is very good.
What do I think about the scalability of the solution?
The scalability is good. We have about five users for this solution and they are all developers.
How are customer service and technical support?
The technical support for this solution is good.
Which solution did I use previously and why did I switch?
We did not use another solution prior to this one.
How was the initial setup?
The initial setup of the Azure Data Factory was simple. It took us one week to deploy it.
What about the implementation team?
We deployed this solution with our in-house team.
What was our ROI?
Good
What's my experience with pricing, setup cost, and licensing?
Our licensing fees are approximately 15,000 ($150 USD) per month. There are no additional fees.
Which other solutions did I evaluate?
We evaluated a solution by Talend before selecting the Azure Data Factory.
What other advice do I have?
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 eight 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?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros
sharing their opinions.
Updated: October 2026
Popular Comparisons
Informatica Intelligent Data Management Cloud (IDMC)
Databricks
Teradata
Qlik Talend Cloud
Palantir Foundry
SAP Business Data Cloud
Informatica PowerCenter
Snowflake
Oracle Data Integrator (ODI)
SnapLogic
Fivetran
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which solution do you prefer: KNIME, Azure Synapse Analytics, or Azure Data Factory?
- How do Alteryx, Denod, and Azure Data Factory overlap (or complement) each other?
- Do you think Azure Data Factory’s price is fair?
- What kind of organizations use Azure Data Factory?
- Is Azure Data Factory a secure solution?
- How does Azure Data Factory compare with Informatica PowerCenter?
- How does Azure Data Factory compare with Informatica Cloud Data Integration?
- Which is better for Snowflake integration, Matillion ETL or Azure Data Factory (ADF) when hosted on Azure?
- What is the best suitable replacement for ODI on Azure?
- Which product do you prefer: Teradata Vantage or Azure Data Factory?

















