We just raised a $30M Series A: Read our story
Andres Felipe Naranjo
.NET Architect at a computer software company with 10,001+ employees
Real User
Top 20Leaderboard
A cloud-based data integration service that's easy to understand and use

Pros and Cons

  • "I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."
  • "It would be better if it had machine learning capabilities."

What is our primary use case?

I use Azure Data Factory in my company because we are implementing a lot of different projects for a big company based in the USA. We're getting certain information from different sources—for example, some files in the Azure Blob Storage. We're migrating that information to other databases. We are validating and transforming the data. After that, we put that data in some databases in Azure Synapse and SQL databases.

What is most valuable?

I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot.

What needs improvement?

It would be better if it had machine learning capabilities. For example, at the moment, we're working with Databricks and Azure Data Factory. But Databricks is very complex to do the different data flows. It could be great to have more functionalities to do that in Azure Data Factory.

For how long have I used the solution?

I have been using Azure Data Factory for about one year.

What do I think about the stability of the solution?

Azure Data Factory is a stable solution.

What do I think about the scalability of the solution?

It's scalable. We're doing a lot of different integrations with a lot of data, and scalability is great.

How was the initial setup?

The initial setup is straightforward. I think that it's so easy to start a project using that technology.

What about the implementation team?

We have a team that's in charge of doing the deployments in Azure in different environments.

What other advice do I have?

I would tell potential users that there are many technologies to do this. For example, if you like to manage big data and do something with it, it would be better to use Databricks.

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

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
Flag as inappropriate
Balan Murugan
Azure Technical Architect at a computer software company with 10,001+ employees
Real User
Top 5Leaderboard
Easy to set up, has many built-in connectors for onboarding data, and offers good support

Pros and Cons

  • "It has built-in connectors for more than 100 sources and onboarding data from many different sources to the cloud environment."
  • "We have experienced some issues with the integration. This is an area that needs improvement."

What is our primary use case?

The primary use case of this solution is for data integration.

What is most valuable?

It has built-in connectors for more than 100 sources and onboarding data from many different sources to the cloud environment.

It has everything we needed.

Being able to post your feedback and queries is a very good feature that is offered by Azure Data Factory.

What needs improvement?

Understanding the pricing model for Data Factory is quite complex. It needs to be simplified, and easier to understand.

We have experienced some issues with the integration. This is an area that needs improvement.

For how long have I used the solution?

I have been using this solution for almost two years.

What do I think about the stability of the solution?

So far it's been stable. We have not experienced any issues.

What do I think about the scalability of the solution?

I haven't put much thought into scalability.

How are customer service and technical support?

I have contacted technical support.

If there are any queries, they have the provision to post them in the Data Factory GUI and we can contact the team directly. This is a very nice feature.

Any feedback or improvements that we post is acknowledged and taken care of.

How was the initial setup?

The initial setup was straightforward. It was not complex.

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

Pricing is quite complex.

I have had feedback from many people and many of my team members, and they say that it is difficult to understand. 

Understanding the pricing of Data Factory is quite complex. 

It is not presented in a straightforward way.

What other advice do I have?

I would definitely recommend this solution to anyone who is interested in using it.

I would rate Azure Data Factory 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
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
542,823 professionals have used our research since 2012.
DawidDetko
Principal Data Architect at Predica
MSP
Very stable, a friendly user interface and easy to set up

Pros and Cons

  • "The user interface is very good. It makes me feel very comfortable when I am using the tool."
  • "The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way."

What is most valuable?

The user interface is very good. It makes me feel very comfortable when I am using the tool.

What needs improvement?

The solution could use some merge statements.

The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way. 

For how long have I used the solution?

I've been using the solution for three years.

What do I think about the scalability of the solution?

The solution is scalable.

How are customer service and technical support?

We've been satisfied with the level of technical support we've received.

How was the initial setup?

The initial setup is very straightforward. The only thing which we had to consider at the beginning was the gateway for the on-premises environment. Otherwise, it's very easy.

What other advice do I have?

We use both the on-premises and cloud deployment models. We typically work with enterprise-level companies.

Azure Data Factory is pretty good but should be considered as an orchestrator, not as an integrated tool. We can use some building components in that tool to orchestrate the entire workflow but if we are thinking about more details, processing, or data modification during the flow, we'd have to consider Azure Databricks or Data Flow for making those calculations or changes. Users will need Azure Data Factory plus third party tools to reach that level of functionally.

I would recommend using Data Factory. I don't have a lot of experience with integration or with integration services, for example, SQL server integration services. However, there are points that should be considered if you are already using SQL server integration services already. You can implement the packages already prepared in Azure Data Factory. It's something that needs to be considered when deciding which technology you are going to use.

I'd rate the solution eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner.
Suraj Kshirsagar
Azure Architect\Informatica ETL Developer at Relativity
Real User
Top 20
A helpful and responsive GUI, but there are a lot of tasks for which you need to write code

Pros and Cons

  • "The most valuable feature is the ease in which you can create an ETL pipeline."
  • "The support and the documentation can be improved."

What is our primary use case?

I use this primarily for ETL tasks.

What is most valuable?

The most valuable feature is the ease in which you can create an ETL pipeline.

The GUI is very helpful when it comes to creating pipelines. The user interface is also very fast.

The connection to Snowflake is easy. I can store data and transform it during the ETL process before sending it to Snowflake.

What needs improvement?

Azure Data Factory is a bit complicated compared to Informatica. There are a lot of connectors that are missing and there are a lot of instances where I need to create a server and install Integration Runtime.

The support and the documentation can be improved.

There are a lot of tasks that you need to write code for.

For how long have I used the solution?

I have been using Azure Data Factory for about six months.

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

I have experience with Informatica and I find it easier to use. For example, there are a lot of connectors that are directly available. Also, Informatica is able to take incremental copies, but with Azure, you have to write code to do that.

I have also worked with Matillion and Fivetran, and I feel that there are a lot of things that Azure can learn from these products. For example, with Fivetran there are very good connectors for copying data between other solutions. This is unlike Azure, where a lot of the time, I have to build my own logic.

How was the initial setup?

The initial setup is complex.

What other advice do I have?

I would rate this solution a 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
Soumyojit Sen
Director of Product Management at EIM solutions
Real User
Top 20Leaderboard
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.
Flag as inappropriate
AT
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: I am a real user, and this review is based on my own experience and opinions.
LS
Enterprise Data Architect at a financial services firm with 201-500 employees
Real User
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."
  • "It can improve from the perspective of active logging. It can provide active logging information."

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: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
NT
Senior Systems Analyst at a non-profit with 201-500 employees
Real User
Top 10Leaderboard
Good stability and scalability with a valuable data copy template

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…

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: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate