Azure Data Factory vs Microsoft Analytics Platform System comparison

Why PeerSpot?

Azure Data Factory and Microsoft Analytics Platform System are both solutions in the Cloud Data Warehouse category. Additionally, 92% of Azure Data Factory users are willing to recommend the solution, compared to 66% of Microsoft Analytics Platform System users who would recommend it.

Azure Data Factory

Read 97 Azure Data Factory reviews

15,321 Views
2,758 Comparison Views

92% willing to recommend

Microsoft Analytics Platfor...

Read 9 Microsoft Analytics Platform System reviews

2,063 Views
1,589 Comparison Views

66% willing to recommend

Azure Data Factory

Microsoft Analytics Platfor...

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between Azure Data Factory and Microsoft Analytics Platform System based on real PeerSpot user reviews.

Find out what your peers are saying about Snowflake Computing, Google, Databricks and others in Cloud Data Warehouse.

To learn more, read our detailed Cloud Data Warehouse Report (Updated: September 2026).

Buyer's Guide

Cloud Data Warehouse

September 2026

Download the complete report

Helped 915,341 peers since 2012

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

Ranking in other categories

Data Integration (6th), Cloud Data Warehouse (6th)

Microsoft Analytics Platfor...

Average Rating

6.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Warehouse (18th)

Featured Reviews

Kunal Das

Test Engineer at Happiest Minds Technologies

Drag-and-drop pipelines have saved days of work and now automate data movement and backfilling

If the AI features were more improved so that I don't have to provide each and every detail, Azure Data Factory could be improved in a much better way by improving the AI features. For example, if I want to fetch any data from a raw source, I need to provide each and every detail. But if I am just uploading my raw data and if AI will sync with that data, it can analyze that data and give me proper suggestions on how that should be done in a proper way. Automatic suggestions could improve in a much better way. As I have mentioned, the AI features as well as more drag-and-drop activities could be improved. If I am making a pipeline, it should give me suggestions, such as which activity should be used, so that I don't have to remember each activity. If I have used one activity, I shouldn't have to remember what activity should I use next. It should give auto-suggestions. That is why I have given a nine out of 10. Currently, I don't know about its governance and security, but in view of its improvement, I think Azure Data Factory should improve in these areas. As I already mentioned, the AI features should be improved. Also, the auto-suggestion features should also improve.

Read full review

MahmoudMohamed1

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.

Read full review

Quotes from Members

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

Pros

"Its integrability with the rest of the activities on Azure is most valuable."

"The data flows were beneficial, allowing us to perform multiple transformations."

"This solution has provided us with an easier, and more efficient way to carry out data migration tasks."

"The data pipeline and the orchestration functionality are the most valuable aspects of the solution, and the interface is very good, as it seeks to be very responsive and intuitive."

"I like Azure Data Factory, it works quite well."

"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."

"I find the most valuable feature in Azure Data Factory to be its ability to handle large datasets."

"Azure Data Factory is great because it's a cloud service; you do not have to take care of the installation and configuration yourself."

More Azure Data Factory pros

"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."

"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."

"I think Microsoft Stack offers the end-to-end solution I need."

"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 help customers in many ways from customized analysis for detection of anomalies in tax, operations, customer relationship, and marketing campaigns, and we also use mining and ML to help them discover trends, which provides useful information based on their business."

"By combining both Microsoft Parallel Data Warehouse (PDW) and unstructured Hadoop analytical capabilities in a single, easy-to-manage EDW appliance, Microsoft APS is well positioned to help organizations use information to enhance their competitive position."

"It is closely integrated with other products in the MS portfolio."

"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."

More Microsoft Analytics Platform System pros

Cons

"Additionally, the ability to handle the largest volumes of data is another concern; if I have to manage more than one terabyte of data every day, I am not comfortable dealing with Azure Data Factory and had to switch to Oracle Data Integrators (ODI) because it lacks performance features."

"There are performance issues, particularly with the underlying compute, which should be configurable."

"Data Factory's monitorability could be better."

"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."

"Real-time replication is required, and this is not a simple task."

"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."

"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."

"The solution can be improved by decreasing the warmup time which currently can take up to five minutes."

More Azure Data Factory cons

"Hybrid environments are complex to manage."

"Functionality needs to be more up-to-date with competing products."

"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."

"The trouble is Microsoft has changed their licensing. It's an extremely expensive product now."

"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."

"The pricing model needs to be improved."

"On a scale from one to ten where one is the worst and ten is the best, I would rate this product overall as a five. This is probably because there is still a lot of room for improvement, features that other products have that are missing, and a lot of open-source technology nowadays that are very good and people can use instead."

"In general, I am not really very satisfied with the tutorials that are out there."

More Microsoft Analytics Platform System cons

Pricing and Cost Advice

"There's no licensing for Azure Data Factory, they have a consumption payment model. How often you are running the service and how long that service takes to run. The price can be approximately $500 to $1,000 per month but depends on the scaling."

"For our use case, it is not expensive. We take into the picture everything: resources, learning curve, and maintenance."

"The pricing is a bit on the higher end."

"Product is priced at the market standard."

"Pricing is comparable, it's somewhere in the middle."

"The solution's fees are based on a pay-per-minute use plus the amount of data required to process."

"The licensing cost is included in the Synapse."

"The cost is based on the amount of data sets that we are ingesting."

More Azure Data Factory pricing and cost advice

"The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."

"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."

"I rate Microsoft Analytics Platform System a seven out of ten for pricing."

"Users have to pay extra for premium-level technical support."

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

915,341 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

11%

Manufacturing Company

Computer Software Company

Construction Company

No data available

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	31
Midsize Enterprise	21
Large Enterprise	64

By reviewers
Company Size	Count
Small Business	4
Large Enterprise	7

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.

See all answers

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...

See all answers

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...

See all answers

Ask a question

Earn 20 points

Comparisons

Snowflake vs Azure Data Factory

Compared 4% of the time

Databricks vs Azure Data Factory

Compared 4% of the time

Palantir Foundry vs Azure Data Factory

Compared 3% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs Azure Data Factory

Compared 3% of the time

SnapLogic vs Azure Data Factory

Compared 3% of the time

More Azure Data Factory Competitors

Oracle Exadata vs Microsoft Analytics Platform System

Compared 19% of the time

Teradata vs Microsoft Analytics Platform System

Compared 8% of the time

SAP IQ vs Microsoft Analytics Platform System

Compared 7% of the time

SAP BW4HANA vs Microsoft Analytics Platform System

Compared 5% of the time

Treasure Data vs Microsoft Analytics Platform System

Compared 4% of the time

More Microsoft Analytics Platform System Competitors

Product Reports

Buyer's Guide

Azure Data Factory

October 2026

Download Azure Data Factory product report

Buyer's Guide

Microsoft Analytics Platform System

September 2026

Microsoft Analytics Platform System report

Download Microsoft Analytics Platform System product report

Also Known As

No data available

Microsoft APS, MS Analytics Platform System

Overview

Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.

Microsoft

Microsoft Analytics Platform System integrates with Microsoft ecosystem, connecting databases and offering advanced Cube Solution for analytics. It provides cost-effective end-to-end capabilities with multiple features under one license.

Microsoft Analytics Platform System offers seamless integration with Azure products, and its tools enhance flexibility and compatibility across different services and scenarios. While it provides comprehensive BI charts and data warehousing capabilities, users have noted that support and documentation need improvements, especially in hybrid environments. The system's machine learning and AI could be more user-friendly, and real-time analytics require enhancements. Handling permissions and data ingestion are cost-intensive, posing challenges for non-technical teams.

What are the key features of Microsoft Analytics Platform System?

Seamless Microsoft Ecosystem Integration: Connects efficiently with Microsoft products.
Advanced Cube Solution: Facilitates multidimensional analytics.
Comprehensive End-to-End Capabilities: Covers all analytics needs with one license.
Rich BI Charts: Offers diverse visualization options for insights.
Azure Product Compatibility: Enhances cloud-based analytics and flexibility.

What benefits and ROI can users expect?

Cost-Effective Solution: Multiple features under one license reduce expenses.
Enhanced Productivity: Supports high-level decision-making and operational insights.
Versatility: Suitable for both cloud and on-premise deployments.
Improved Collaboration: Diverse tools aid project execution and teamwork.

In industries such as finance, telecom, and healthcare, Microsoft Analytics Platform System is used for multi-dimensional analysis and business intelligence. It supports predictive analytics, report generation, and server monitoring within Azure settings. Users leverage it for data integration and decision-making, allowing extensive project execution with its suite of tools.

Microsoft

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, Google, Databricks and others in Cloud Data Warehouse. Updated: September 2026.

DOWNLOAD NOW

915,341 professionals have used our research since 2012.

See our list of best Cloud Data Warehouse vendors.

We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.