Azure Data Factory vs Microsoft Analytics Platform System comparison

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 90 Azure Data Factory reviews

4,155 Views
3,276 Comparison Views

92% willing to recommend

Microsoft Analytics Platfor...

Read 9 Microsoft Analytics Platform System reviews

223 Views
134 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 in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.

To learn more, read our detailed Azure Data Factory vs. Microsoft Analytics Platform System Report (Updated: March 2025).

Buyer's Guide

Azure Data Factory vs. Microsoft Analytics Platform System

March 2025

Download the complete report

Helped 848,207 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.9

Number of Reviews

Ranking in other categories

Data Integration (1st), Cloud Data Warehouse (3rd)

Microsoft Analytics Platfor...

Average Rating

6.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Warehouse (17th)

Featured Reviews

Joy Maitra

Sr. Technical Architect at Hexaware Technologies Limited

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.

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

"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."

"The most valuable feature of this solution would be ease of use."

"I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."

"Data Factory allows you to pull data from multiple systems, transform it according to your business needs, and load it into a data warehouse or data lake."

"The most valuable features are data transformations."

"An excellent tool for pipeline orchestration."

"The data is more scalable."

"The two most valuable features of Azure Data Factory are that it's very scalable and that it's also highly reliable."

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

"Helps our customers to discover trends, which provides useful information based on their business."

"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."

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

"This is a well-integrated solution and that integration empowers results."

"I like that it's integrated with other Azure products."

Cons

"Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."

"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."

"The solution needs to integrate more with other providers and should have a closer integration with Oracle BI."

"The setup and configuration process could be simplified."

"Some of the optimization techniques are not scalable."

"In the next release, it's important that some sort of scheduler for running tasks is added."

"The thing we missed most was data update, but this is now available as of two weeks ago."

"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."

More Azure Data Factory cons

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

"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."

"Microsoft Analytics Platform System could have better support."

"Hybrid environments are complex to manage."

"We need better real-time analytics capabilities. It's a bit challenging for us."

"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."

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

"The pricing model needs to be improved."

More Microsoft Analytics Platform System cons

Pricing and Cost Advice

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

"ADF is cheaper compared to AWS."

"I don't see a cost; it appears to be included in general support."

"The pricing is pay-as-you-go or reserve instance. Of the two options, reserve instance is much cheaper."

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

"I rate the product price as six on a scale of one to ten, where one is low price and ten is high price."

"The licensing cost is included in the Synapse."

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

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

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

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

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

848,207 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

14%

Computer Software Company

12%

Manufacturing Company

Healthcare Company

No data available

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

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

What do you like most about Microsoft Analytics Platform System?

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

See all answers

What is your experience regarding pricing and costs for Microsoft Analytics Platform System?

It's not too confusing. It's based on features, and we don't have to buy additional licenses.

See all answers

What needs improvement with Microsoft Analytics Platform System?

We need better real-time analytics capabilities. It's a bit challenging for us. Moreover, there are some permission limitations.

See all answers

Comparisons

Informatica PowerCenter vs Azure Data Factory

Compared 11% of the time

Snowflake vs Azure Data Factory

Compared 9% of the time

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

Compared 7% of the time

Alteryx Designer vs Azure Data Factory

Compared 6% of the time

Oracle Data Integrator (ODI) vs Azure Data Factory

Compared 5% of the time

More Azure Data Factory Competitors

Teradata vs Microsoft Analytics Platform System

Compared 60% of the time

Microsoft Azure Synapse Analytics vs Microsoft Analytics Platform System

Compared 40% of the time

More Microsoft Analytics Platform System Competitors

Product Reports

Buyer's Guide

Azure Data Factory

April 2025

Download Azure Data Factory product report

Buyer's Guide

Microsoft Analytics Platform System

March 2025

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

The Microsoft Analytics Platform System can meet the demands of your evolving data warehouse environment with its scale-out, massively parallel processing integrated system supporting hybrid data warehouse scenarios. It provides the ability to query across relational and non-relational data by leveraging Microsoft PolyBase and industry-leading big data technologies. It offers the lowest price per terabyte for large data warehouse workloads.

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

Buyer's Guide

Azure Data Factory vs. Microsoft Analytics Platform System

March 2025

Free Report: Azure Data Factory vs. Microsoft Analytics Platform System

Find out what your peers are saying about Azure Data Factory vs. Microsoft Analytics Platform System and other solutions. Updated: March 2025.

DOWNLOAD NOW

848,207 professionals have used our research since 2012.

See our Azure Data Factory vs. Microsoft Analytics Platform System report.

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.