No more typing reviews! Try our Samantha, our new voice AI agent.
reviewer2149473 - PeerSpot reviewer
Network Team Lead at a computer software company with 1,001-5,000 employees
Real User
Apr 14, 2023
A stable solution that helps to move data from on-premises to the cloud
Pros and Cons
  • "We use the solution to move data from on-premises to the cloud."
  • "The tool’s workflow is not user-friendly. It should also improve its orchestration monitoring."

What is our primary use case?

We use the solution to move data from on-premises to the cloud.

What needs improvement?

The tool’s workflow is not user-friendly. It should also improve its orchestration monitoring.

For how long have I used the solution?

I have been using the product since 2019.

What do I think about the stability of the solution?

The tool is a stable product.

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

What other advice do I have?

I would rate the solution a seven out of ten.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1112397 - PeerSpot reviewer
Principal Consultant at a tech services company with 11-50 employees
Real User
Dec 21, 2022
Helps us transfer and transform data from sources for analytical purposes
Pros and Cons
  • "I like the basic features like the data-based pipelines."
  • "There's space for improvement in the development process of the data pipelines."

What is our primary use case?

We use Data Factory in our projects, which we deliver to customers. We have almost five implementations in which we're using Data Factory.

It's cloud-based, but there's the integration runtime, which you can connect to on-premises sources. You can transfer data from on-premises to the cloud. We're integrating on-premise data sources to cloud data-based services, like rescue or finance and so on.

Azure Data Factory is very good for enterprise organizations like banks and international insurance companies.

It's cloud-based.

What is most valuable?

I like the basic features like the data-based pipelines.

What needs improvement?

We have had some issues, but it's critical to use Data Factory for what it was designed for. It's not very good for iteration processes for loop data activity because you must wait for the runtime. This is a downgrade, but we developed some workaround for it, and we're running the Azure function for these iteration processes.

There's space for improvement in the development process of the data pipelines.

What do I think about the stability of the solution?

I would rate the stability as nine out of ten, but there are some issues with the responsiveness of the interface.

What do I think about the scalability of the solution?

It's easy to scale.

How are customer service and support?

I would rate the technical support as four out of five.

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

I'm mostly working with cloud technology, and we use other vendors. On-premises, there is another team in my company that's working with Oracle tools. I'm focusing only on Azure technology, which means that I personally don't have hands-on experience with different tools.

How was the initial setup?

Setup is very straightforward and simple, but it depends on the customers. We have more than 15 data engineers who have data engineer certification from Microsoft. For them, it's a very easy process. 

Of course, there are some issues when configuring the on-premise integration runtime because you have to deal with the network settings on on-premise infrastructure. In terms of ADF as a product, there are very good guides and documentation that you can use to navigate how to solve certain issues.

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

The price is fair.

What other advice do I have?

I would rate this solution as nine out of ten.

For any customer who needs to transfer or transform the data from sources for analytical purposes, Azure Data Factory is a good product for that.

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. Integrator
PeerSpot user
Buyer's Guide
Azure Data Factory
May 2026
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
896,510 professionals have used our research since 2012.
reviewer2031234 - PeerSpot reviewer
Senior Consultant at a computer software company with 1,001-5,000 employees
Consultant
Dec 11, 2022
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?

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.

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.

How are customer service and support?

Technical support is excellent.

How would you rate customer service and support?

Positive

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
PeerSpot user
Head of Product at Tata Consultancy
Real User
Feb 22, 2022
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."
  • "When it comes to our business requirements, this solution has worked well for us."
  • "The one element of the solution that we have used and could be improved is the user interface."
  • "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
PeerSpot user
reviewer1709361 - PeerSpot reviewer
Senior Data Engineer at a real estate/law firm with 201-500 employees
Real User
Nov 7, 2021
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."
  • "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.
PeerSpot user
reviewer1621755 - PeerSpot reviewer
Enterprise Data Architect at a financial services firm with 201-500 employees
Real User
Aug 24, 2021
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."
  • "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."
  • "It can improve from the perspective of active logging."

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.
PeerSpot user
reviewer1524705 - PeerSpot reviewer
Senior Systems Analyst at a non-profit with 201-500 employees
Real User
Aug 23, 2021
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."
  • "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.
PeerSpot user
Soumyojit Sen - PeerSpot reviewer
Director of Product Management at EIM solutions
Real User
Jun 20, 2021
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."
  • "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.
PeerSpot user
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.
Updated: May 2026
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.