Try our new research platform with insights from 80,000+ expert users
reviewer2311983 - PeerSpot reviewer
Senior Software Developer at a insurance company with 10,001+ employees
Real User
Top 20
Mar 26, 2024
A cloud-based data integration service that allows you to create data-driven workflows in the cloud for orchestrating
Pros and Cons
  • "For me, it was that there are dedicated connectors for different targets or sources, different data sources. For example, there is direct connector to Salesforce, Oracle Service Cloud, etcetera, and that was really helpful."
  • "It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."

What is our primary use case?

I'm not sure how much information I can provide regarding to some kind of security of my company, but I can tell you that we were migrating integrations from from platform to the other, and the other platform was error data factory.

What is most valuable?

For me, it was that there are dedicated connectors for different targets or sources, different data sources. For example, there is direct connector to Salesforce, Oracle Service Cloud, etcetera, and that was really helpful.

What needs improvement?

It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory.

For how long have I used the solution?

I have been using Azure Data Factory for one year. 

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

What do I think about the stability of the solution?

The solution doesn't have stability issues. 

What do I think about the scalability of the solution?

It is easy to scale. 

How was the initial setup?

The initial setup is straightforward. Deployment is automatic and takes few minutes. 

What other advice do I have?

Overall, I would rate it an eight out of ten. 

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Zubair_Ahmed - PeerSpot reviewer
Senior Consultant at a tech services company with 51-200 employees
MSP
Nov 30, 2023
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
January 2026
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,036 professionals have used our research since 2012.
Director of Business Intelligence Analytics at a insurance company with 11-50 employees
Real User
Apr 6, 2023
Lots of features and easy data collection but needs more integrations
Pros and Cons
  • "It makes it easy to collect data from different sources."
  • "Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations."

What is our primary use case?

We primarily use the solution for data warehousing. I'm integrating data from multiple sources.

How has it helped my organization?

I have a team helping me out from India. It helps manage the data and collect everything from sources.

What is most valuable?

The product has a lot of features.

It makes it easy to collect data from different sources.

The solution offers good integration with pretty much any system.

I like that it is cloud-based. 

What needs improvement?

Sometimes when I run some jobs, I have issues with the log flow. I want to see where the data goes. I want to see the data stream.

I'd like more integrations with other APIs. Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations. 

For how long have I used the solution?

I've been using the solution for four or five years. 

What other advice do I have?

I'm using the solution as an end-user.

We are using the latest version of the solution. 

I'd rate the solution seven 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
Joaquin Marques - PeerSpot reviewer
CEO - Founder / Principal Data Scientist / Principal AI Architect at a tech company with 1-10 employees
Real User
Dec 19, 2022
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
Aurora Calderon - PeerSpot reviewer
Experienced Consultant at a computer software company with 201-500 employees
Consultant
Oct 12, 2022
You can create your own pipeline in your space and reuse those creations.
Pros and Cons
  • "I like how you can create your own pipeline in your space and reuse those creations. You can collaborate with other people who want to use your code."
  • "DataStage is easier to learn than Data Factory because it's more visual. Data Factory has some drag-and-drop options, but it's not as intuitive as DataStage. It would be better if they added more drag-and-drop features. You can start using DataStage without knowing the code. You don't need to learn how the code works before using the solution."

What is our primary use case?

My clients use Data Factory to exchange information between the on-premises environment and the cloud. Data Factory moves the data, and we use other solutions like Databricks to transform and clean up the data. My teams typically consist of three or four data engineers.

What is most valuable?

I like how you can create your own pipeline in your space and reuse those creations. You can collaborate with other people who want to use your code.

What needs improvement?

DataStage is easier to learn than Data Factory because it's more visual. Data Factory has some drag-and-drop options, but it's not as intuitive as DataStage. It would be better if they added more drag-and-drop features. You can start using DataStage without knowing the code. You don't need to learn how the code works before using the solution.

I think the communication about the ADA's would be interesting to see in the platform. How to interact with those kind of information and use it on your pipelines.

For how long have I used the solution?

I have used Data Factory for eight months.

What do I think about the stability of the solution?

I have never experienced downtime with Data Factory. 

What do I think about the scalability of the solution?

It isn't that expensive to scale Data Factory up. My client can ask for more resources on the tool, and paying more is never an issue. 

How are customer service and support?

I rate Azure support seven or eight out of 10. There is room for improvement. Sometimes, you don't know where the errors originate. You have to send a ticket to Azure, and they take two or three days to respond. The issue may resolve itself by then. The problem is fixed, but you don't know how to prevent it or what to do if it happens in the future. 

The data transfer has stopped a few times for unknown reasons. We don't know if the resources are insufficient or if there is a problem with the platform. By the time we hear back from Microsoft, the issue has been resolved.

How would you rate customer service and support?

Positive

How was the initial setup?

Data Factory is effortless to set up.

What other advice do I have?

I rate Azure Data Factory nine out of 10. When implementing Data Factory, you should document where you are building so you can pass that information. Sometimes you build something for a specific purpose, but you can use that information for other solutions. If you have a community where you are building things, you can reuse them on the platform, so don't need to build everything from scratch.

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. Partner
PeerSpot user
Anirban Bhattacharya - PeerSpot reviewer
Practice Head, Data & Analytics at a tech vendor with 10,001+ employees
Real User
Aug 22, 2022
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.

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
Gyanendu Rai - PeerSpot reviewer
Senior Tech Consultant at a financial services firm with 1,001-5,000 employees
Real User
Jun 28, 2022
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
Sunil Singh - PeerSpot reviewer
Lead Engineering at a computer software company with 10,001+ employees
Real User
Jun 6, 2022
A fully managed, monolithic serverless data integration service
Pros and Cons
  • "I like that it's a monolithic data platform. This is why we propose these solutions."
  • "The performance could be better. It would be better if Azure Data Factory could handle a higher load. I have heard that it can get overloaded, and it can't handle it."

What is our primary use case?

Depending on their pipeline, our customers use Azure Data Factory for their ELT or ETL transformation processes.

What is most valuable?

I like that it's a monolithic data platform. This is why we propose these solutions.

What needs improvement?

The performance could be better. It would be better if Azure Data Factory could handle a higher load. I have heard that it can get overloaded, and it can't handle it.

For how long have I used the solution?

We have been providing customers Azure Data Factory solutions for about five years. 

What do I think about the stability of the solution?

Azure Data Factory is a stable solution. The performance is good.

How are customer service and support?

Microsoft technical support is good. We are a Gold partner, and we have got good tech support from them.

How was the initial setup?

From a cloud perspective, the initial setup is straightforward. We have a data engineering team with about 15 professionals managing and maintaining this solution.

What about the implementation team?

We have an accelerated solution around it. We utilize our accelerated solutions to spin all these services into the cloud. So, for us, it does not take much time.

What other advice do I have?

I would recommend this solution depending on whether they want AWS, Azure, or GCP. We recommend all of them to our customers. We have about 50 to 80 people who are using this solution.

On a scale from one to ten, I would give Azure Data Factory a nine.

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
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.
Updated: January 2026
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.