Try our new research platform with insights from 80,000+ expert users
Director at a tech services company with 1-10 employees
Real User
Comprehensive and user-friendly
Pros and Cons
  • "Azure Data Factory's most valuable features are the packages and the data transformation that it allows us to do, which is more drag and drop, or a visual interface. So, that eases the entire process."
  • "We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on."

What is our primary use case?

Azure Data Factory is for data transformation and data loading. It works from your transaction systems, and we are using it for our HRMS, Human Resource Capital Management System. It picks up all the transactional data pick and moves into the Azure Data Warehouse. From there, we would like to create reports in terms of our financial positions and our resource utilization project. These are the reports that we need to build onto the warehouse.

The purpose of Azure Data Factory is more about transformations, so it doesn't need to have a good dashboard. But, it has a feeding user interface for us to do our activities and debug actions. I think that's good enough.

What is most valuable?

Azure Data Factory's most valuable features are the packages and the data transformation that it allows us to do, which is more drag and drop, or a visual interface. So, that eases the entire process.

Azure Data Factory setup is quite user-friendly.

I am happy with the interface.

What needs improvement?

We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on.

We are still in the development phase, testing it on a very small set of data, maybe then the neatest four or bigger set of data. Then, you might get some pain points once we put it in place and run it. That's when it will be more effective for me to answer that.

For how long have I used the solution?

We are building Azure Data Factory right now internally to extract data from our transactional systems and put them into the warehouse so that the reporting engine can be built too.

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

What do I think about the scalability of the solution?

We have not tried it scaling up. But, Azure promises the stability and scalability should not be an issue.

From a development perspective, I think there were four developers who use Azure Data Factory. From a warehouse perspective, once we roll out the reports out, it should be used by at least 40 or 50 people minimum.

How are customer service and support?

Generally, the documentation is pretty decent. All the issues that come up are here in the documentation part. We've not really had to go to Microsoft as of now from a support perspective. The documentation and the support that we get over the internet is quite good.

How was the initial setup?

The initial setup was very straightforward.

The initial setup was quite quick, nothing much to do. Now, we are more developing the use cases. A use case with data generally takes around four or five days a use case because it will start right from identifying the right field, getting the data, transforming it, and finalizing the warehouse structure. That makes a bit of a thing, but it's pretty straightforward.

What about the implementation team?

We are a technical team so we implemented it in-house.

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

It's a pay-as-you-go module. I'm not very sure about cost because our usage currently is very low. But, I feel that if the usage extends beyond a certain threshold, it will start getting expensive.

It depends what the threshold is. I see we're not at that threshold right now, so it's pretty decent right now.

Which other solutions did I evaluate?

We were looking at certain other projects and products. For example, we were looking at Snowflake that has a data warehouse. But the project wasn't working. That's why we selected Azure. The primary reason is the skills are very easily available for Azure. The second is from our strategy perspective, because we were trying to be a Microsoft shop it fits into our strategy. That's all.

What other advice do I have?

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.

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
reviewer1435158 - PeerSpot reviewer
Business Unit Manager Data Migration and Integration at a tech services company with 201-500 employees
Real User
Offers good flexibility and has good support
Pros and Cons
  • "The flexibility that Azure Data Factory offers is great."
  • "The number of standard adaptors could be extended further."

What is our primary use case?

We use this solution for data integration. We use it to feed operational data into a data warehouse. We also use it for creating connections between applications.

Within our organization, there are a few thousand users of Azure Data Factory.

We believe that the number of customers and usage of this product will extend over the next few years. For this reason, we invest a lot of resources in building skills, and we make sure to hire consultants who know their way around Data Factory.

What is most valuable?

The flexibility that Azure Data Factory offers is great.

What needs improvement?

The number of standard adaptors could be extended further. What we find is that if we develop data integration solutions with Data Factory, there's still quite a bit of coding involved, whereas we'd like to move in a direction with less coding and more select-and-click.

For how long have I used the solution?

I have been using Azure Data Factory for one year.

What do I think about the scalability of the solution?

We don't have any complaints regarding scalability or stability.

How are customer service and technical support?

I think Microsofts' technical support does a pretty good job. There is a lot of information available on the internet to find out how to use their products. There's also quite an active community. If you really can't find a solution, you can always call Microsoft. Our organization is partnered with Microsoft, so we usually get answers directly from them.

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

We used SSIS. We're still using SSIS. SSIS is an old product. The development of SSIS has more or less stopped and the development is now focused on cloud services — it's the future. Azure Data Factory Is great because it's a cloud service; you do not have to take care of the installation and configuration yourself. The cost buildup is also quite different. I am not sure that's a huge financial advantage yet, but we do believe that it will be in the future.

How was the initial setup?

The initial setup was straightforward.

We didn't have to deploy Azure Data Factory. It's available as an Azure service, so Microsoft takes care of that.

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

It's a pay-per-use model. So if you run it, it's hardly licensing. The entire cost of Azure is per-use. The price you pay is determined by how much you use it.

What other advice do I have?

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.

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
Azure Data Factory
September 2025
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: September 2025.
868,759 professionals have used our research since 2012.
CTO at a construction company with 1,001-5,000 employees
Real User
Fully integrated with the Azure environment and includes support for many connectors
Pros and Cons
  • "The security of the agent that is installed on-premises is very good."
  • "The pricing scheme is very complex and difficult to understand."

What is our primary use case?

We are using this solution to gather information from SCADA systems, analyze it using AI and machine learning, and then sending the results to our users. They receive and view the data using the Power BI interface.

How has it helped my organization?

The integration with the whole environment is smooth and transparent.

What is most valuable?

The reason that we implemented this product is for the full integration with the whole Azure environment. It is very important because you don't have to deal with security, identity flow, or audit flow.

The security of the agent that is installed on-premises is very good. This is another important feature for us.

It comes with a lot of connectors out of the box, including support for SQL, Oracle, SAP, and ODBC.

What needs improvement?

The pricing scheme is very complex and difficult to understand. Analyzing it upfront is impossible, so we just decided to start using it and figure out the costs on a weekly or monthly basis.

For how long have I used the solution?

We have just begun using Azure Data Factory within the past two or three months and it is not fully rolled out yet.

How are customer service and technical support?

We have no issues with technical support. We are working closely with Microsoft partners. There were a couple of problems during the installation that were solved on the fly, and otherwise, we haven't had and trouble.

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

We started with iConduct and as we migrated to the Azure environment, we began the process of switching to the Microsoft Azure Data Factory.

How was the initial setup?

The initial setup was not very complex and the deployment was very quick. We were set up within a matter of days, or perhaps a week.

What about the implementation team?

We received help from one of the Microsoft partners, who handled the installation for us.

What other advice do I have?

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.

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
Sarath Boppudi - PeerSpot reviewer
Data Strategist, Cloud Solutions Architect at BiTQ
Real User
Top 5
An easy initial setup with a fast deployment and good technical support
Pros and Cons
  • "On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
  • "If the user interface was more user friendly and there was better error feedback, it would be helpful."

What is our primary use case?

I primarily use the solution for my small and medium-sized clients.

What is most valuable?

So far, I'm quite happy with the solution overall. It's got a lot of tools that I use in my work, and these are items I'm already recommending to my clients. I'm quite happy with it.

What needs improvement?

I'm not sure if I have any complaints about the solution at the moment. There are a few bits and pieces that we would like to see improved. These include improvements related to the solution's ease of use and some quality flash upgrades. However, these are minor complaints. 

If the user interface was more user friendly and there was better error feedback, it would be helpful.

For how long have I used the solution?

I've been working with the solution for three to four years now.

What do I think about the stability of the solution?

On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good.

What do I think about the scalability of the solution?

I haven't had the ability to scale any of my projects personally. I also wouldn't need to scale too high if I did. I'm not sure if I can speak to aspects of scalability as I've never dealt with it.

How are customer service and technical support?

I've contacted Microsoft technical support in the past. I have to say that I've had a good experience with them. I've been quite satisfied with their level of service.

How was the initial setup?

The initial setup was very straightforward. I wouldn't describe it as complex.

Deployment is fast. It only takes about half an hour at most.

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

I don't have any information about the pricing. I don't deal with that aspect of the solution.

What other advice do I have?

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.

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
reviewer982071 - PeerSpot reviewer
Delivery Manager at a tech services company with 1,001-5,000 employees
Real User
User friendly, cost-effective, and the performance is good
Pros and Cons
  • "It is easy to deploy workflows and schedule jobs."
  • "The setup and configuration process could be simplified."

What is our primary use case?

We are a tech services company and this is one of the tools that we use when implementing solutions for our clients. I am currently managing a team that is working with the Azure Data Factory.

Our clients that use this solution are migrating their data from on-premises to the cloud.

One of our clients is building an integrated data warehouse for all of their data, using this solution. It is used to extract all of the data from different servers and store it into one place.

What is most valuable?

Our clients find that this solution has a very good performance. They like the speed.

It is easy to deploy workflows and schedule jobs. You can just click on the desktop and it works.

What needs improvement?

The setup and configuration process could be simplified.

For how long have I used the solution?

We have been using Azure Data Factory for the past six months.

What do I think about the stability of the solution?

This is a stable product and we're expecting more updates from Microsoft. We have not used more than one terabyte of data so that remains untested, but for one terabyte it works fine.

Development is only done on an occasional basis, but the solution is used every day. If it is streaming data then the process is continuous, otherwise, it is initiated by the user on demand.

What do I think about the scalability of the solution?

This solution is 100% scalable.

We have two clients working with this solution.

How are customer service and technical support?

It is another team who is responsible for contacting technical support.

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

We have used other ETL solutions in the past, and Azure Data Factory is the best one. Compared to SSIS, for example, ADF is easier to use and the performance is better.

Our clients are migrating from on-premises SSIS solutions to the cloud because they want to take advantage of the latest technologies.

How was the initial setup?

The installation is very simple and it doesn't take much time. For us, the deployment took about two days, which does not seem unreasonable for something that is on the cloud. Most of the time is spent waiting for credentials.

Depending on the sources of the data, four people are required for deployment and maintenance. If the sources are SQL databases then it is straightforward and four people can cope with it. If the data is more difficult then we may need more people.

What about the implementation team?

The deployment is done in-house with a technical person with knowledge of the Azure cloud.

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

This is a cost-effective solution.

Which other solutions did I evaluate?

We have another team that is moving to AWS, but for now, we will continue working with Azure Data Factory. Once they have explored the AWS solution fully, we will compare the two.

What other advice do I have?

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.

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
reviewer1248231 - PeerSpot reviewer
Team Leader at a insurance company with 201-500 employees
Real User
Complete solution with good interface, workflow, and ease of use
Pros and Cons
  • "It is a complete ETL Solution."
  • "The Microsoft documentation is too complicated."

What is most valuable?

The features that I've found most valuable, in order: That it is a complete ETL Solution, the second one is interface, the third one workflow, and the fourth one ease of use.

What needs improvement?

The only thing that we're struggling with is increasing the competency of my team. So we think that the Microsoft documentation is too complicated.

I would like to see it more connected. I know they're working on the Snowflake data warehouse connector, but more connectors would be helpful.

For how long have I used the solution?

I've been using Azure Data Factory for a few months.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

Azure Data Factory is a scalable solution.

How are customer service and technical support?

In terms of support, we haven't used the direct support but the community support is very good.

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

We previously used the Oracle Warehouse Builder. The reasons we stopped using it were that Warehouse Builder is at the end of its life-cycle and its slow performance.

How was the initial setup?

The initial setup is complex.

What about the implementation team?

We first implemented it ourselves but we're using a partner now. We thought we could do it ourselves but we needed specialty help.

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

I would highly recommend Azure Data Factory as it has proof of concept.

What other advice do I have?

We have nine people using Azure Data Factory.

On a scale of one to ten, I give it an eight.

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
reviewer1007019 - PeerSpot reviewer
Head of IT at a logistics company with 10,001+ employees
Real User
Helps integrate complex data needs and is easy to use
Pros and Cons
  • "Powerful but easy-to-use and intuitive."
  • "The product could provide more ways to import and export data."

What is our primary use case?

The use cases are more related to logistics, our finance, and back-office activity.  

What is most valuable?

The most valuable part of this product is the ease of use. It is easy to use and rather intuitive. Because it is easy to use, you can do things with it easily. The more things make your work easy, the more valuable they are.  

What needs improvement?

Because I have not really done a really deep benchmark against competitors, I may not be familiar enough with the potential of competing products and capabilities to be able able to say what is missing or should be improved definitively.  

From my perspective, the pricing seems like it could be more user-friendly. Of course, nothing is ever as inexpensive as you want.  

Perhaps one good additional feature would be incorporating more ways to import and export data. It would be nice to have the product fit our service orchestration platform better to make the transfer more fluid.  

For how long have I used the solution?

We started using this product a year ago.  

What do I think about the stability of the solution?

The stability of the product is good.  

What do I think about the scalability of the solution?

The scalability seems okay. As we have only been using it for a short time, it is hard to say more. We are not currently planning to scale usage dramatically at this point but of course we would like to grow. On a scale from one to ten and from what I know, I would say scalability is an eight-out-of-ten. I can't be sure exactly how many people are using the system, but we have hundreds of thousands of users currently. Internally, I would say we use the product often.  

How are customer service and technical support?

I have not had a reason to be in touch with technical support, but I don't know whether others in the organization have been in touch with them. As far as I know, there has been no reason to be.  

How was the initial setup?

The initial setup was not simple and it was not complex. It was in the middle.  

I would say it took two months for the deployment.  

What about the implementation team?

We have a department of developers that implemented the product. The deployment happened before I joined the organization.  

What other advice do I have?

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.  

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 has a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1236675 - PeerSpot reviewer
Microsoft Consultant at a tech services company with 201-500 employees
Consultant
Good support for SAP services and databases, a simple initial setup and good scalability
Pros and Cons
  • "From what we have seen so far, the solution seems very stable."
  • "The solution needs to integrate more with other providers and should have a closer integration with Oracle BI."

What is most valuable?

The support for SAP services and databases, specifically SAP HANA, has been a game-changer for us.

What needs improvement?

It would be helpful if they could adjust the data capture feature so that when there are source-side changes ADF could automatically figure it out.  

The solution needs to integrate more with other providers and should have a closer integration with Oracle BI.

For how long have I used the solution?

I've been working with the solution for just over a year.

What do I think about the stability of the solution?

From what we have seen so far, the solution seems very stable.

What do I think about the scalability of the solution?

The solution is scalable. Right now, we have only three or four people on it. We may increase usage int eh future.

How are customer service and technical support?

We have direct technical support in Israel. In India, we haven't used it yet. However, for other services, the help provided is fine. 

How was the initial setup?

The initial setup was pretty fast and simple. I wouldn't say it was too complex. For deployment, it depends on your environment. In our POC, it didn't take more than two to three hours. In the production environment, however, it takes a bit more time for operations.

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

In general, we've been satisfied with the pricing. However, since it's a service based on usage, it's really hard to estimate the cost in advance for this product. This makes it hard to quote. It's not so easy to estimate the costs in advance when giving a quote. That makes it difficult to convince some customers because most would like to see a number in advance. 

What other advice do I have?

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.

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