Buyer's Guide
Data Integration Tools
November 2022
Get our free report covering Software AG, Microsoft, Altair, and other competitors of ETL Solutions Transformation Manager. Updated: November 2022.
655,711 professionals have used our research since 2012.

Read reviews of ETL Solutions Transformation Manager alternatives and competitors

User with 5,001-10,000 employees
Real User
Easy to set up, and reasonably priced, but the user experience could be improved
Pros and Cons
  • "Microsoft supported us when we planned to provision Azure Data Factory over a private link. As a result, we received excellent support from Microsoft."
  • "User-friendliness and user effectiveness are unquestionably important, and it may be a good option here to improve the user experience. However, I believe that more and more sophisticated monitoring would be beneficial."

What is most valuable?

Essentially, Azure Data Factory is more aligned to ETL, but I wanted to provide a solution for a full data lake solution where I could leverage functionality, whether it is ETL, data ingestion, data warehousing, or data lake.

What needs improvement?

I was planning to switch to Synapse and was just looking into Synapse options.

I wanted to plug things in and then put them into Power BI. Basically, I'm planning to shift some data, leveraging the skills I wanted to use Synapse for performance.

I am not a frequent user, and I am not an Azure Data Factory engineer or data engineer. I work as an enterprise architect. Data Factory, in essence, becomes a component of my solution. I see the fitment and plan on using it. It could be Azure Data Factory or Data Lake, but I'm not sure what enhancements it would require.

User-friendliness and user effectiveness are unquestionably important, and it may be a good option here to improve the user experience. However, I believe that more and more sophisticated monitoring would be beneficial.

For how long have I used the solution?

I work as an enterprise architect, and I have been using Azure Data Factory for more than a year.

I am working with the latest version.

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?

Azure Data Factory is a scalable product.

In my current company, I have a team of five people, but in my previous organization, there were 20.

How are customer service and support?

Technical support is good. We encountered no technical difficulties. Microsoft supported us when we planned to provision Azure Data Factory over a private link. As a result, we received excellent support from Microsoft.

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

Products such as Azure Data Factory and Informatica Enterprise Data Catalog were evaluated. This is something I'm working on. I work as an enterprise architect, so these are the tools that I frequently use.

Previously, I worked with SSIS. We did not change. Because we were building a cloud-based ETF solution Azure Data Factory was an option, but when it came to on-premises solutions, the SQL server integrating the SSIS tool was one option.

How was the initial setup?

The initial setup is easy.

It took three to four weeks to get up to speed and get comfortable using it.

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

Pricing appears to be reasonable in my opinion.

What other advice do I have?

My only advice is that Azure Data Factory, particularly for data ingestion, is a good choice. But if you want to go further and build an entire data lake solution, I believe Synapse, is preferred. In fact, Microsoft is developing and designing it in such a way that, it's an entirely clubbing of data ingestion, and data lake, for all things. They must make a decision: is the solution dedicated to only doing that type of data ingestion, in which case I believe Data Factory is the best option.

I would have preferred, but I'm not a frequent user there right now. I need to think beyond Data Factory as an open-source project to include machines and everything else. As a result, as previously stated, Data Factory becomes very small at the enterprise architect level. I was inundated with power automation, power ops, power virtualizations, and everything else in Microsoft that I had to think about.

I would rate Azure Data Factory a seven out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Buyer's Guide
Data Integration Tools
November 2022
Get our free report covering Software AG, Microsoft, Altair, and other competitors of ETL Solutions Transformation Manager. Updated: November 2022.
655,711 professionals have used our research since 2012.