Try our new research platform with insights from 80,000+ expert users

Azure Data Factory vs ETL Solutions Transformation Manager comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Azure Data Factory
Ranking in Data Integration
1st
Average Rating
8.0
Reviews Sentiment
7.0
Number of Reviews
91
Ranking in other categories
Cloud Data Warehouse (2nd)
ETL Solutions Transformatio...
Ranking in Data Integration
34th
Average Rating
9.0
Reviews Sentiment
6.8
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2025, in the Data Integration category, the mindshare of Azure Data Factory is 7.9%, down from 12.2% compared to the previous year. The mindshare of ETL Solutions Transformation Manager is 0.3%, up from 0.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Joy Maitra - PeerSpot reviewer
Facilitates seamless data pipeline creation with good analytics and and thorough monitoring
Azure Data Factory is a low code, no code platform, which is helpful. It provides many prebuilt functionalities that assist in building data pipelines. Also, it facilitates easy transformation with all required functionalities for analytics. Furthermore, it connects to different sources out-of-the-box, making integration much easier. The monitoring is very thorough, though a more readable version would be appreciable.
Vijayraj Amin - PeerSpot reviewer
User-friendly and accessible for anyone with computer knowledge and logical thinking
There is room for improvement in the solution's visualization tool. Currently, it provides basic reports and the ability to create graphs and dashboards, but I'm looking forward to more robust analytics. The plan is to enhance this feature in 2024, around Q2 or Q3, which would save us from relying on external tools like Power BI for insights.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."
"The overall performance is quite good."
"The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components."
"The user interface is very good. It makes me feel very comfortable when I am using the tool."
"The flexibility that Azure Data Factory offers is great."
"The data copy template is a valuable feature."
"It's cloud-based, allowing multiple users to easily access the solution from the office or remote locations. I like that we can set up the security protocols for IP addresses, like allow lists. It's a pretty user-friendly product as well. The interface and build environment where you create pipelines are easy to use. It's straightforward to manage the digital transformation pipelines we build."
"We have been using drivers to connect to various data sets and consume data."
"It is a reliable solution."
"It is among the best, even if not widely known."
"Back in the day, we could only get reports and analyze what happened after the fact, but today now we can generate real-time insights. Transformation Manager feeds your data science projects. We generate models and then give them to the clients, so they can come up with real-time predictions and recommendations in addition to reporting."
 

Cons

"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"I do not have any notes for improvement."
"Data Factory's performance during heavy data processing isn't great."
"Data Factory could be improved by eliminating the need for a physical data area. We have to extract data using Data Factory, then create a staging database for it with Azure SQL, which is very, very expensive. Another improvement would be lowering the licensing cost."
"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."
"On the UI side, they could make it a little more intuitive in terms of how to add the radius components. Somebody who has been working with tools like Informatica or DataStage gets very used to how the UI looks and feels."
"There is no built-in pipeline exit activity when encountering an error."
"My only problem is the seamless connectivity with various other databases, for example, SAP."
"Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing."
"There is room for improvement in the solution's visualization tool."
"They should build a functional architecture based on queuing."
 

Pricing and Cost Advice

"The pricing is pay-as-you-go or reserve instance. Of the two options, reserve instance is much cheaper."
"Azure products generally offer competitive pricing, suitable for diverse budget considerations."
"Product is priced at the market standard."
"The solution is cheap."
"It seems very low initially, but as the data grows, the solution’s bills grow exponentially."
"Pricing appears to be reasonable in my opinion."
"The cost is based on the amount of data sets that we are ingesting."
"I don't see a cost; it appears to be included in general support."
"It is an expensive solution."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
862,624 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Computer Software Company
12%
Manufacturing Company
9%
Government
6%
Computer Software Company
30%
Financial Services Firm
11%
Healthcare Company
8%
Educational Organization
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

How do you select the right cloud ETL tool?
AWS Glue and Azure Data factory for ELT best performance cloud services.
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
What is your experience regarding pricing and costs for ETL Solutions Transformation Manager?
ETL Solutions Transformation Manager is much more affordable than other solutions like AWS, Blue, or Informatica. Even though some competitors may offer seemingly economical pricing, the resource c...
What needs improvement with ETL Solutions Transformation Manager?
There is room for improvement in the solution's visualization tool. Currently, it provides basic reports and the ability to create graphs and dashboards, but I'm looking forward to more robust anal...
 

Also Known As

No data available
Transformation Manager
 

Overview

 

Sample Customers

1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa
Honda, BNP Paribas, RBS, JPMorgan, Volkswagen, Thorn Lighting, OpenSpirit, Rolls-Royce, Ulster Bank
Find out what your peers are saying about Azure Data Factory vs. ETL Solutions Transformation Manager and other solutions. Updated: July 2025.
862,624 professionals have used our research since 2012.