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

15,713 Views
2,671 Comparison Views

92% willing to recommend

Microsoft Analytics Platfor...

Read 9 Microsoft Analytics Platform System reviews

377 Views
215 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: July 2025).

Buyer's Guide

Azure Data Factory vs. Microsoft Analytics Platform System

July 2025

Download the complete report

Helped 865,384 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

7.0

Number of Reviews

Ranking in other categories

Data Integration (1st), Cloud Data Warehouse (2nd)

Microsoft Analytics Platfor...

Average Rating

6.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Warehouse (18th)

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 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 valuable feature of Azure Data Factory is its integration capability, as it goes well with other components of Microsoft Azure."

"I like the basic features like the data-based pipelines."

"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."

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

"Azure Data Factory is a low code, no code platform, which is helpful."

"The data copy template is a valuable feature."

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

More Azure Data Factory pros

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

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

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

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

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

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

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

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

Cons

"Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."

"Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations."

"There is room for improvement primarily in its streaming capabilities. For structured streaming and machine learning model implementation within an ETL process, it lags behind tools like Informatica."

"The product could provide more ways to import and export data."

"Data Factory's monitorability could be better."

"Data Factory could be improved in terms of data transformations by adding more metadata extractions."

"This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations."

"The inability to connect local VMs and local servers into the data flow is a limitation that prevents giving Azure Data Factory a perfect score."

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

"Microsoft Analytics Platform System could have better support."

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

"Hybrid environments are complex to manage."

"The pricing model needs to be improved."

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

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

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

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

"The solution's pricing is competitive."

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

"Azure products generally offer competitive pricing, suitable for diverse budget considerations."

"Azure Data Factory gives better value for the price than other solutions such as Informatica."

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

"Our licensing fees are approximately 15,000 ($150 USD) per month."

"It seems very low initially, but as the data grows, the solution’s bills grow exponentially."

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

865,384 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

14%

Computer Software Company

12%

Manufacturing Company

Government

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

Snowflake vs Azure Data Factory

Compared 9% of the time

Informatica PowerCenter vs Azure Data Factory

Compared 7% of the time

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

Compared 5% of the time

Alteryx Designer vs Azure Data Factory

Compared 5% of the time

Palantir Foundry vs Azure Data Factory

Compared 5% of the time

More Azure Data Factory Competitors

Microsoft Azure Synapse Analytics vs Microsoft Analytics Platform System

Compared 38% of the time

Teradata vs Microsoft Analytics Platform System

Compared 26% of the time

IBM Netezza Performance Server vs Microsoft Analytics Platform System

Compared 19% of the time

Treasure Data vs Microsoft Analytics Platform System

Compared 16% of the time

More Microsoft Analytics Platform System Competitors

Product Reports

Buyer's Guide

Azure Data Factory

August 2025

Download Azure Data Factory product report

Buyer's Guide

Microsoft Analytics Platform System

August 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

July 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: July 2025.

DOWNLOAD NOW

865,384 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.