No more typing reviews! Try our Samantha, our new voice AI agent.

Azure Data Factory vs Microsoft Analytics Platform System comparison

 

Comparison Buyer's Guide

Executive Summary

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
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
96
Ranking in other categories
Data Integration (5th), Cloud Data Warehouse (7th)
Microsoft Analytics Platfor...
Average Rating
6.6
Reviews Sentiment
6.8
Number of Reviews
9
Ranking in other categories
Data Warehouse (18th)
 

Featured Reviews

KandaswamyMuthukrishnan - PeerSpot reviewer
Director at a computer software company with 1,001-5,000 employees
Integrates diverse data sources and streamlines ETL processes effectively
Regarding potential areas of improvement for Azure Data Factory, there is a need for better data transformation, especially since many people are now depending on DataBricks more for connectivity and data integration. Azure Data Factory should consider how to enhance integration or filtering for more transformations, such as integrating with Spark clusters. I am satisfied with Azure Data Factory so far, but I suggest integrating some AI functionality to analyze data during the transition itself, providing insights such as null records, common records, and duplicates without running a separate pipeline or job. The monitoring tools in Azure Data Factory are helpful for optimizing data pipelines; while the current feature is adequate, they can improve by creating a live dashboard to see the online process, including how much percentage has been completed, which will be very helpful for people who are monitoring the pipeline.
MahmoudMohamed1 - PeerSpot reviewer
Senior Data Engineer at Tatweer Educational Technologies Company - TETCO
Offers smooth data integration between systems, but requires better real-time analytics capabilities
We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services. This lets us continue using private databases without paying additional licensing fees. Additionally, the license includes Analytics services and Power BI, which work on-premises, unlike most other technologies that require cloud solutions.

Quotes from Members

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

Pros

"It's a good tool, a good product that does what it's supposed to do well, which is ingesting data from a source to your target, to another cloud, to another source."
"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
"The most valuable feature I have found at Azure Data Factory is the data flow function."
"We have found the bulk load feature very valuable."
"The solution can scale very easily."
"It is a complete ETL Solution."
"The tool's most valuable features are its connectors. It has many out-of-the-box connectors. We use ADF for ETL processes. Our main use case involves integrating data from various databases, processing it, and loading it into the target database. ADF plays a crucial role in orchestrating these ETL workflows."
"The stability of the Azure Data Factory is very good."
"It is closely integrated with other products in the MS portfolio."
"I think Microsoft Stack offers the end-to-end solution I need."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"I like that it's integrated with other Azure products."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"The most valuable part of the product is that it is a system, with different tools for different services for different kinds of scenarios, making it a very rich, integrated, technology-rich platform whose total integration with the rest of Microsoft products creates flexibility and compatibility and makes the tool a very useful one."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
 

Cons

"Some of the optimization techniques are not scalable."
"To my mind, the solution needs to be more connectable to its own services."
"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."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others."
"When we initiated the cluster, it took some time to start the process."
"The Microsoft documentation is too complicated."
"There are limitations when processing more than one GD file."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"However, centralized EDW tends to be extremely expensive and very inflexible."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"In general, I am not really very satisfied with the tutorials that are out there."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"Functionality needs to be more up-to-date with competing products."
"The pricing model needs to be improved."
"​Hybrid environments are complex to manage."
 

Pricing and Cost Advice

"While I can't specify the actual cost, I believe it is reasonably priced and comparable to similar products."
"The solution's pricing is competitive."
"I would not say that this product is overly expensive."
"The price is fair."
"Understanding the pricing model for Data Factory is quite complex."
"The pricing is a bit on the higher end."
"Pricing appears to be reasonable in my opinion."
"My company is on a monthly subscription for Azure Data Factory, but it's more of a pay-as-you-go model where your monthly invoice depends on how many resources you use. On a scale of one to five, pricing for Azure Data Factory is a four. It's just the usage fees my company pays monthly."
"We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."
"Users have to pay extra for premium-level technical support."
"The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
"I rate Microsoft Analytics Platform System a seven out of ten for pricing."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
902,988 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
12%
Computer Software Company
9%
Manufacturing Company
9%
Construction Company
6%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business31
Midsize Enterprise21
Large Enterprise63
By reviewers
Company SizeCount
Small Business4
Large Enterprise7
 

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...
Ask a question
Earn 20 points
 

Also Known As

No data available
Microsoft APS, MS Analytics Platform System
 

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
Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
Find out what your peers are saying about Snowflake Computing, Teradata, Google and others in Cloud Data Warehouse. Updated: June 2026.
902,988 professionals have used our research since 2012.