Microsoft Parallel Data Warehouse 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 Parallel Data Warehouse 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 Parallel Data Warehouse vs. Oracle Autonomous Data Warehouse Report (Updated: March 2024).
768,415 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
"It handles high volumes of data very well.""One of the most important features is the ease of using MS SQL.""The data transmissions between the data models is the most valuable feature.""I am very satisfied with the customer service/technical support.""Data collection and reporting are valuable features of the solution.""The most valuable feature of this solution is performance.""Tools like the BI and SAS are excellent.""It is not a pricey product compared to other data warehouse solutions."

More Microsoft Parallel Data Warehouse Pros →

"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system.""It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions.""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 reason we use it.""A very good integration feature that restricts access to unauthorized people.""One advantage is that if you already have an Oracle Database, it easily integrates with that.""The performance and scalability are awesome.""It is a stable and scalable solution.""Self-patching and runs machine-learning across its logs all the time"

More Oracle Autonomous Data Warehouse Pros →

Cons
"The solution is expensive and has room for improvement.""They need to incorporate a machine learning engine.""​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.""The product does not have all of the features that the native products have.""It could be made more user-friendly for business users which would increase the user base.""It could offer more development across the solution.""In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating.""The query is slow if we don't optimize it."

More Microsoft Parallel Data Warehouse Cons →

"The solution lacks visibility options.""The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora.""A lot of the tools that were previously there have now been taken away.""The installation process is complex. Oracle can make the installation process better.""It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment.""They should make the solution more user-friendly.""One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace.""The initial setup was pretty complex. It was not easy."

More Oracle Autonomous Data Warehouse Cons →

Pricing and Cost Advice
  • "I think the program is well-priced compared to the other offerings that are out in the market."
  • "Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information."
  • "All the features that we use do not require any additional subscription or yearly fees."
  • "Technical support is an additional fee and is expensive."
  • "The solution's pricing is fairly decent for organizations with huge data sizes."
  • "The tool could be expensive if we need to manage a lot of data."
  • "They offer an annual subscription. The pricing depends on the size of the environments."
  • More Microsoft Parallel Data Warehouse 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,415 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
    Top Answer:They offer an annual subscription. The pricing depends on the size of the environments.
    Top Answer:Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.
    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
    8th
    out of 34 in Data Warehouse
    Views
    598
    Comparisons
    475
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    10th
    Views
    3,427
    Comparisons
    2,255
    Reviews
    7
    Average Words per Review
    556
    Rating
    8.1
    Comparisons
    Also Known As
    Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
    Learn More
    Overview

    The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

    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
    Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
    Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
    Top Industries
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Financial Services Firm17%
    Insurance Company7%
    University6%
    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%
    Midsize Enterprise14%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise18%
    Large Enterprise65%
    REVIEWERS
    Small Business38%
    Midsize Enterprise6%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise47%
    Large Enterprise39%
    Buyer's Guide
    Microsoft Parallel Data Warehouse vs. Oracle Autonomous Data Warehouse
    March 2024
    Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Autonomous Data Warehouse and other solutions. Updated: March 2024.
    768,415 professionals have used our research since 2012.

    Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews while Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Oracle Autonomous Data Warehouse is rated 8.6. The top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". 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 Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, VMware Tanzu Greenplum 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 Parallel Data Warehouse 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.