Azure Data Factory Review

Great data pipeline and the orchestration functionality with a good user interface

What is our primary use case?

The solution is primarily used for data integration. We are using it for the data pipelines to get data out of the legacy systems and provide it to the Azure SQL Database. We are using the SQL data source providers mainly.

What is most valuable?

The data pipeline and the orchestration functionality are the most valuable aspects of the solution.

The interface is very good. It seeks to be very responsive and intuitive.

The initial setup is very quick and easy.

What needs improvement?

I'm more of a general manager. I don't have any insights in terms of missing features or items of that nature.

Integration of data lineage would be a nice feature in terms of DevOps integration. It would make implementation for a company much easier. I'm not sure if that's already available or not. However, that would be a great feature to add if it isn't already there.

For how long have I used the solution?

We've used the solution for the last 12 months or so.

What do I think about the stability of the solution?

From what I have witnessed, the solution is quite stable. It doesn't crash or freeze. There are no bugs or glitches. It's reliable.

What do I think about the scalability of the solution?

We work with medium to enterprise-level organizations. Customers have anywhere from 300 employees up to 160,000 employees.

How are customer service and technical support?

Microsoft offers a great community. There's a lot of support available. We're quite satisfied with the level of assistance on offer.

How was the initial setup?

Since the solution is a service, it's basically just a click and run setup. It's very simple. There's very little implementation necessary. A company should be able to easily arrange it. The deployment doesn't take very long at all.

What about the implementation team?

We do provide the implementation for our clients. We're able to provide templates as well. We have predefined implementation space in Data Factory and provide it to the customer.

Which other solutions did I evaluate?

While clients might individually evaluate other options, however, we're not aware of that information. I can't say what other solution clients might consider before ultimately choosing Microsoft. I would say that it is likely Talend and maybe SQL Server Integration Services.

What other advice do I have?

We are like an integrator. We are a data warehouse NPI consulting company and we use Data Factory to pull data from different legacy systems and do all these transformations that are necessary in order to provide analytical models.

In our normal scenario is that we are providing Azure SQL Databases together with Azure Data Factory and Power BI. 80% of our customers have recognized such a scenario.

On a scale from one to ten, I'd rate the solution at an eight. We've been largely happy with the capabilities of the product.

Which version of this solution are you currently using?

**Disclosure: My company has a business relationship with this vendor other than being a customer: Implementator
More Azure Data Factory reviews from users
...who work at a Computer Software Company
...who compared it with SSIS
Learn what your peers think about Azure Data Factory. Get advice and tips from experienced pros sharing their opinions. Updated: June 2021.
512,711 professionals have used our research since 2012.
Add a Comment
ITCS user