Microsoft Analytics Platform System vs Oracle Autonomous Data Warehouse comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft Analytics Platform System and Oracle Autonomous Data Warehouse 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 Microsoft Analytics Platform System vs. Oracle Autonomous Data Warehouse Report (Updated: March 2024).
768,740 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""This solution will connect to any database, you can combine databases, and you can create a cube or tabular model.""The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics.""This is a well-integrated solution and that integration empowers results.""We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.""I like that it's integrated with other Azure products.""It is closely integrated with other products in the MS portfolio."

More Microsoft Analytics Platform System Pros →

"The solution integrates well with Power BI.""It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.""The product is easy to use.""The analytics have been very good. We've found them to be quite useful.""A very good integration feature that restricts access to unauthorized people.""Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets.""The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle.""I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."

More Oracle Autonomous Data Warehouse Pros →

Cons
"The pricing model needs to be improved.""Machine learning and artificial intelligence capabilities need to be more friendly for beginning users.""Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release.""Microsoft Analytics Platform System could have better support.""Functionality needs to be more up-to-date with competing products.""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.""​Hybrid environments are complex to manage."

More Microsoft Analytics Platform System Cons →

"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable.""The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora.""My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle.""An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud.""I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end.""It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects.""The initial setup was pretty complex. It was not easy.""I would like to see an on-premise solution in the future."

More Oracle Autonomous Data Warehouse Cons →

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."
  • "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."
  • "I rate Microsoft Analytics Platform System a seven out of ten for pricing."
  • More Microsoft Analytics Platform System Pricing and Cost Advice →

  • "The cost is perfect with Oracle Universal credit."
  • "ROI is high."
  • "You pay as you go, and you don't pay for services that you don't use."
  • "Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
  • "The solution's cost is reasonable."
  • "On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
  • "The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
  • "The price depends on the configuration we choose."
  • More Oracle Autonomous Data Warehouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    768,740 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services.
    Top Answer:It's not too confusing. It's based on features, and we don't have to buy additional licenses.
    Top Answer:We need better real-time analytics capabilities. It's a bit challenging for us. Moreover, there are some permission limitations.
    Top Answer:With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main… more »
    Top Answer:Cost-wise, it's a solid seven out of ten. A bit costly, but it is a good tool.
    Top Answer:My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on… more »
    Ranking
    17th
    out of 34 in Data Warehouse
    Views
    323
    Comparisons
    240
    Reviews
    2
    Average Words per Review
    439
    Rating
    7.5
    10th
    Views
    3,427
    Comparisons
    2,255
    Reviews
    7
    Average Words per Review
    556
    Rating
    8.1
    Comparisons
    Also Known As
    Microsoft APS, MS Analytics Platform System
    Learn More
    Overview
    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.

    Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and, according to an IDC report (PDF), lowers operational costs by an average of 63%.


    Autonomous Database provides the foundation for a data lakehouse—a modern, open architecture that enables you to store, analyze, and understand all your data. The data lakehouse combines the power and richness of data warehouses with the breadth, flexibility, and low cost of popular open source data lake technologies. Access your data lakehouse through Autonomous Database using the world's most powerful and open SQL processing engine.

    Sample Customers
    Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
    Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm12%
    Computer Software Company11%
    University11%
    Energy/Utilities Company9%
    REVIEWERS
    Computer Software Company27%
    Manufacturing Company18%
    Financial Services Firm18%
    Individual & Family Service9%
    VISITORS READING REVIEWS
    Educational Organization43%
    Financial Services Firm9%
    Computer Software Company8%
    Manufacturing Company4%
    Company Size
    REVIEWERS
    Small Business36%
    Large Enterprise64%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise5%
    Large Enterprise73%
    REVIEWERS
    Small Business38%
    Midsize Enterprise6%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise47%
    Large Enterprise39%
    Buyer's Guide
    Microsoft Analytics Platform System vs. Oracle Autonomous Data Warehouse
    March 2024
    Find out what your peers are saying about Microsoft Analytics Platform System vs. Oracle Autonomous Data Warehouse and other solutions. Updated: March 2024.
    768,740 professionals have used our research since 2012.

    Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews while Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews. Microsoft Analytics Platform System is rated 6.6, while Oracle Autonomous Data Warehouse is rated 8.6. The top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". On the other hand, the top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake, whereas Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Amazon Redshift. See our Microsoft Analytics Platform System vs. Oracle Autonomous Data Warehouse 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.