Try our new research platform with insights from 80,000+ expert users
reviewer1286736 - PeerSpot reviewer
IT Analyst at a tech vendor with 10,001+ employees
Real User
Improved data resilience, in the way that we move data from on-prem to the cloud and vice versa
Pros and Cons
  • "The most important feature is that it can help you do the multi-threading concepts."
  • "There should be a way that it can do switches, so if at any point in time I want to do some hybrid mode of making any data collections or ingestions, I can just click on a button."

What is our primary use case?

It's a PaaS service. It's a hybrid solution. The cloud provider is Microsoft.

We are not using Azure Data Factory as for users. Rather, we're using it as a process base. We're just using it for orchestration, not for any kind of ETL stuff.

We have plans to increase usage. It's going to take a major role in any kind of traditional data warehousing. It has big potential, especially as a PaaS offering.

How has it helped my organization?

There has been improvement in data resilience, in the way that we're moving the data from on-prem to cloud and vice versa.

What is most valuable?

The most important feature is that it can help you do the multi-threading concepts. It's in Informatica, but the resourcing is quite robust. You can scale up and scale down as per your needs.

What needs improvement?

There should be a way that it can do switches, so if at any point in time I want to do some hybrid mode of making any data collections or ingestions, I can just click on a button. I can change a switch and make sure a batch can be a streaming process.

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

For how long have I used the solution?

I've been using Azure Data Factory for more than two years.

What do I think about the stability of the solution?

The stability of Azure as a PaaS could be improved.

What do I think about the scalability of the solution?

It's scalable.

How are customer service and support?

I would rate their technical support 3 out of 5. It's not great, but it isn't bad.

How was the initial setup?

The setup is complex. It has nothing to do with the technology but with the design. We were wondering how to leverage the orchestration layer where we are having the Azure Data Factory and how to integrate with the Databricks. That's where we had some challenges in terms of choosing the right product.

What about the implementation team?

You can do deployment in-house. 

What other advice do I have?

I would rate this solution 8 out of 10.

For someone who is looking to use this solution, my advice is to do proper due diligence of your current application, know where your application is fitting, and look for the requirements. It all depends upon the current use case that you have currently in your system.

Which deployment model are you using for this solution?

Hybrid 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
Sunil Singh - PeerSpot reviewer
Lead Engineering at GlobalLogic
Real User
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
Azure Data Factory
December 2024
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: December 2024.
824,067 professionals have used our research since 2012.
PeerSpot user
Enterprise Architect at TechnipEnergies
Real User
Feature-rich, scales well, and it provides good extract, transform, and load functionality
Pros and Cons
  • "The best part of this product is the extraction, transformation, and load."
  • "The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others."

What is our primary use case?

We are not using this product specifically as a data factory. We have taken Synapse Analytics as the entire component for the data warehousing solution. Azure Data Factory is one of the components of that, and we are using it for ETL. 

How has it helped my organization?

Prior to this, we did not have a proper data warehousing solution. Instead, we had segregation between different tools like Oracle Data Warehouse, Exadata, and other products. Now, most of the tools that we have are from Microsoft, including Power BI, which has been rolled out throughout the organization. Synapse was the better choice for us to implement, as it has a lot of out-of-the-box connectors that we can utilize for data transformation and organization. 

What is most valuable?

The best part of this product is the extraction, transformation, and load. In fact, we have found that the three of them work quite well. We are implementing the cloud-based system right now.

We see a lot of improvement with the most recent version of this solution. Some of the new features are very important to us.

What needs improvement?

The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others.

For how long have I used the solution?

We have been working with Azure Data Factory for approximately six months. We are still implementing and it is not live, yet, but we expect it to be in 2021.

What do I think about the stability of the solution?

I have found it to be quite stable. Here and there, there could be some issues and problems but overall, I'm okay with the product.

What do I think about the scalability of the solution?

Scalability is one of the points that we were looking for because we are hosting approximately two terabytes of data and we expect that it will grow at least five times over the next two years. This is one of the reasons that we adopted this solution.

In perhaps a year, we will increase our usage.

How are customer service and technical support?

The technical support from Microsoft is quite good. if you get good resources and they can provide you with free consulting, then it is quite good. However, when you purchase paid consulting and dedicated support, it is quite costly compared to the market.

How was the initial setup?

I don't think that the initial setup was very complex. We have quite an advanced IT infrastructure team and the Microsoft FastTrack team also helped us a lot during the programming of the development and setup.

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

I would not say that this product is overly expensive. It is competing with the other providers, and they have almost the same pricing model.

What other advice do I have?

In general, I would recommend this product. However, it depends on the target IT ecosystem. If they are utilizing a lot of Microsoft products like Power BI, Office, Project, SharePoint, and so forth, it's better to implement Data Factory because it will reduce a lot of effort spent to consume data from other sources.

At this point, I can only rate based on my pre-implementation experience, so I would rate this solution 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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Pavan Yogender - PeerSpot reviewer
Founder and CEO at Zertain
Real User
Top 5
A stable solution that can be used to set up a data lake information repository
Pros and Cons
  • "Most of our customers are Microsoft shops and prefer Azure Data Factory because they have good licensing options and a trust factor with Microsoft."
  • "Azure Data Factory's pricing in terms of utilization could be improved."

What is our primary use case?

We use Azure Data Factory to set up a data lake information repository.

What is most valuable?

Most of our customers are Microsoft shops and prefer Azure Data Factory because they have good licensing options and a trust factor with Microsoft. Our core customers are traditional Microsoft shops who prefer to expand on Microsoft on-cloud.

What needs improvement?

Azure Data Factory's pricing in terms of utilization could be improved. Our customers complain that the solution's bills keep growing.

For how long have I used the solution?

I have worked with Azure Data Factory for more than five years as a consultant.

What do I think about the stability of the solution?

Azure Data Factory is a pretty stable solution. I rate Azure Data Factory a nine out of ten for stability.

What do I think about the scalability of the solution?

Azure Data Factory is a scalable solution. We have around 15 to 20 customers, of which about 8 to 10 use Azure Data Factory.

How was the initial setup?

Azure Data Factory's initial setup needs some amount of professional training and qualification.

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

It seems very low initially, but as the data grows, the solution’s bills grow exponentially.

What other advice do I have?

Azure Data Factory is deployed on-cloud for our clients.

Azure Data Factory is a pretty solid solution with all the factors and integration built in. It's as good as any product.

I recommend users compare with Snowflake before choosing Azure Data Factory. We've had customers who prefer Snowflake just for its ease of use. Since we're not a Microsoft official reseller, I give options to customers and then let them pick and choose some from Azure Data Factory, Snowflake, or anything on Amazon.

Overall, I rate Azure Data Factory an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Kevin McAllister - PeerSpot reviewer
Executive Manager at Hexagon AB
Real User
Top 5Leaderboard
Light, inexpensive way to ingest data
Pros and Cons
  • "Data Factory's best features are simplicity and flexibility."
  • "Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."

What is our primary use case?

I primarily use Data Factory to ingest data. For example, if we need to pull data into our data warehouse from somewhere like Azure Event Hub or salesforce.com.

How has it helped my organization?

We have telemetry that streams into an Azure Event Hub, and Data Factory allowed us to move that data from the Event Hub into our data lake and reduce the cost of that compared to the other tooling we were using.

What is most valuable?

Data Factory's best features are simplicity and flexibility. It's been very easy to set up connections to different types of data sources to pull data into our warehouse.

What needs improvement?

Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features.

For how long have I used the solution?

I've been using Data Factory for about three years.

What do I think about the stability of the solution?

I would rate Data Factory's stability eight out of ten.

What do I think about the scalability of the solution?

I would rate Data Factory's scalability eight out of ten.

How was the initial setup?

The initial setup was straightforward, and only one person was required for deployment.

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

I would rate Data Factory's pricing nine out of ten.

What other advice do I have?

I think Data Factory is a good fit when you need a light, inexpensive way to ingest data. I would rate it eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Vishnu Derkar - PeerSpot reviewer
Sr. Big Data Consultant at a tech services company with 11-50 employees
Real User
Easy to learn, simple to use, and has a nice user interface
Pros and Cons
  • "We haven't had any issues connecting it to other products."
  • "I have not found any real shortcomings within the product."

What is our primary use case?

We primarily use the solution in a data engineering context for bringing data from source to sink.

What is most valuable?

The solution is very comfortable to use. I'm happy with the user interface and dashboards. I'm pretty happy with everything about the solution. 

We haven't had any issues connecting it to other products.

It's a stable product. 

What needs improvement?

I have not found any real shortcomings within the product.

For how long have I used the solution?

I've been using the solution for the past year. 

What do I think about the stability of the solution?

The product has been very stable and reliable. I'd rate the stability nine out of ten. There are no bugs or glitches. It doesn't crash or freeze. 

What do I think about the scalability of the solution?

There is a team of 30 people working on the solution. 

How are customer service and support?

I've connected with technical support a few times. 

They sent a support engineer or a field engineer to us, and he helped us out. 

How would you rate customer service and support?

Positive

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

I'm not sure about the exact cost of the solution. 

What other advice do I have?

I'm a customer and end-user.

Our company chose to use this solution based on the fact that it is a Microsoft product. We're using a lot of solutions, including Outlook and Teams. We also use Power BI. We try to use Microsoft so that everything is under one umbrella. That way, there is no difficulty with connecting anything. 

It's a good solution to use. There are lots of videos available on YouTube, and it is very easy to learn. It's very easy to perform things on it as well, which is one thing that a product like ThoughtSpot lacks. There is no training needed like Power BI. 

I'd rate the solution 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?

Microsoft Azure
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Joaquin Marques - PeerSpot reviewer
CEO - Founder / Principal Data Scientist / Principal AI Architect at Kanayma LLC
Real User
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: I am a real user, and this review is based on my own experience and opinions.
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
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2024
Buyer's Guide
Download our free Azure Data Factory Report and get advice and tips from experienced pros sharing their opinions.