Try our new research platform with insights from 80,000+ expert users
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.

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

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 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: I am a real user, and this review is based on my own experience and opinions.
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
Buyer's Guide
Azure Data Factory
February 2025
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
832,138 professionals have used our research since 2012.
CarlosAraque - PeerSpot reviewer
Data Warehouse Analyst at ACSO Australia
Real User
Good connectivity but monitorability could be better
Pros and Cons
  • "Data Factory's best features are connectivity with different tools and focusing data ingestion using pipeline copy data."
  • "Data Factory's monitorability could be better."

What is our primary use case?

I primarily use Data Factory for data ingestion and B2B transformation.

What is most valuable?

Data Factory's best features are connectivity with different tools and focusing data ingestion using pipeline copy data.

What needs improvement?

Data Factory's monitorability could be better. In the next release, Data Factory should include integrations with open-source tools like Air Flow.

For how long have I used the solution?

I've been working with Data Factory for about a year.

What do I think about the stability of the solution?

Data Factory is stable.

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 good, so long as your company has a good relationship with them.

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

I previously worked with Talend, Matillion, and Fivetran.

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

Data Factory is expensive.

What other advice do I have?

I would rate Data Factory 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 has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Abdelmonem Metwally - PeerSpot reviewer
ETL/BI Senior Consultant at Qrious
Consultant
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
PeerSpot user
reviewer1404414 - PeerSpot reviewer
IT Functional Analyst at a energy/utilities company with 1,001-5,000 employees
Real User
Is easy to use and is highly scalable
Pros and Cons
  • "The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable."
  • "One area for improvement is documentation. At present, there isn't enough documentation on how to use Azure Data Factory in certain conditions. It would be good to have documentation on the various use cases."

What is our primary use case?

We are currently using it as an ETL (Extract, Transform, and Load) tool. We are using it to connect to various information providers or, in general, to various sources, to extract data, and then to insert it to our storage devices, databases, or data warehouses.

What is most valuable?

The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable.

What needs improvement?

One area for improvement is documentation. At present, there isn't enough documentation on how to use Azure Data Factory in certain conditions. It would be good to have documentation on the various use cases.

Sometimes, it's really difficult to find the answers to very technical questions regarding certain conditions.

For how long have I used the solution?

I've been using Azure Data Factory since 2019.

What do I think about the stability of the solution?

It has been stable so far.  

What do I think about the scalability of the solution?

Azure Data Factory is a very scalable solution. Including internal developers and external consultants working for us, we have about 10-15 people using this solution.

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

We had been using various ETL tools during the years before moving to the cloud. We picked Azure Data Factory because we were moving towards the Azure cloud.

How was the initial setup?

The initial setup is very easy.

What about the implementation team?

We used a consultant as it was a big project. We had five to six specialists, including both internal and external employees, working on it. It took about about three to six months to complete.

What other advice do I have?

Azure Data Factory is a very easy to use tool. If you want to extract, manipulate, and load data to any type of Azure repository, I recommend this solution. However, I would not recommend it if the manipulation of data is very deep and complicated.

I would rate this solution at eight on a scale from one to ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Director Technology at a computer software company with 10,001+ employees
Real User
Easy pipeline setup and good integration
Pros and Cons
  • "Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations."
  • "Data Factory could be improved in terms of data transformations by adding more metadata extractions."

What is our primary use case?

I primarily use Data Factory for creating pipelines on cloud in terms of integrating multiple cloud services.

What is most valuable?

Data Factory's best feature is the ease of setting up pipelines for data and cloud integrations. It also has good integration with other Azure services.

What needs improvement?

Data Factory could be improved in terms of data transformations by adding more metadata extractions.

For how long have I used the solution?

I've been using Data Factory for five years.

What do I think about the stability of the solution?

Data Factory's stability has improved following some initial issues.

What do I think about the scalability of the solution?

Data Factory's scalability is good.

How was the initial setup?

The initial setup was easy as it's a SaaS offering.

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

Data Factory is affordable.

What other advice do I have?

I would give Data Factory a rating of 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: Partners
PeerSpot user
Soumyojit Sen - PeerSpot reviewer
Director of Product Management at EIM solutions
Real User
Top 10
Powerful data transformations and the stability is good. Performance is good
Pros and Cons
  • "The most valuable features are data transformations."
  • "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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer2149473 - PeerSpot reviewer
Network Team Lead at a computer software company with 1,001-5,000 employees
Real User
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.

What other advice do I have?

I would rate the solution a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.
Updated: February 2025
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.