Microsoft Parallel Data Warehouse vs Oracle Database Appliance 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 Database Appliance based on real PeerSpot user reviews.

Find out in this report how the two 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 Database Appliance Report (Updated: November 2022).
655,711 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
"We have complete control over our data.""The solution has been reliable.""I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."

More Microsoft Parallel Data Warehouse Pros →

"The initial setup was straightforward and quick - I was able to configure everything within an hour.""If the database goes down on one of the servers, the load is automatically shifted to another server. You can troubleshoot the one that is down without affecting uptime.""Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years.""Oracle has good technical support.""The most valuable feature of Oracle Database Appliance is the ease of management.""The product is very light."

More Oracle Database Appliance Pros →

Cons
"I would like the ability to do more real-time type updates instead of batch-oriented updates.""The query is slow if we don't optimize it.""We'd like to see it be a bit more compatible with other solutions."

More Microsoft Parallel Data Warehouse Cons →

"Even though the solution can handle a lot of data, it's just too expensive currently.""I would like it if the scalability could be increased without having to change versions.""The license cost could be cheaper, especially for long-term contracts.""Oracle Database Appliance could improve by having better integration.""Virtualization needs improvement. It's not easy to back up the virtual machines in the Oracle VM architecture. I would also like to see native support for Veeam Backup Software.""Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else."

More Oracle Database Appliance Cons →

Pricing and Cost Advice
Information Not Available
  • "The price should be lower."
  • "You must pay for the license."
  • "The price of the solution should be less expensive. However, they will increase the price more."
  • "I don’t know ODA and alternative system prices. But Oracle the database license is quite expensive and a lot of my customers plan to migrate to open source databases like PostgreSQL."
  • More Oracle Database Appliance Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    655,711 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:I would like the ability to do more real-time type updates instead of batch-oriented updates.
    Top Answer:I rate Microsoft Parallel Data Warehouse eight out of 10. I would recommend it.
    Top Answer:The most valuable feature of Oracle Database Appliance is the ease of management.
    Top Answer:I don’t know ODA and alternative system prices. But Oracle the database license is quite expensive and a lot of my customers plan to migrate to open source databases like PostgreSQL. I rate the price… more »
    Top Answer:Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are… more »
    Ranking
    14th
    out of 32 in Data Warehouse
    Views
    2,024
    Comparisons
    1,614
    Reviews
    3
    Average Words per Review
    334
    Rating
    7.3
    7th
    out of 32 in Data Warehouse
    Views
    3,429
    Comparisons
    2,474
    Reviews
    6
    Average Words per Review
    380
    Rating
    7.5
    Comparisons
    Also Known As
    Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
    X5-2
    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 Database Appliance is the easiest and most affordable way for small or medium-size organizations to run Oracle databases and applications and is an ideal platform for remote and edge computing environments. Customers reduce Oracle Database deployment times and management workloads using a prebuilt integrated system with management automation. As demonstrated in IDC’s business value study (PDF), Oracle Database Appliance lets customers grow revenue and control costs, delivering up to a 498% return on investment (ROI) over five years.

    Offer
    Learn more about Microsoft Parallel Data Warehouse
    Learn more about Oracle Database Appliance
    Sample Customers
    Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
    LifeLock, Incarlopsa, Al Yusur Industrial Contracting
    Top Industries
    REVIEWERS
    Computer Software Company21%
    Pharma/Biotech Company14%
    Hospitality Company14%
    Comms Service Provider7%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Financial Services Firm12%
    Comms Service Provider11%
    Insurance Company10%
    REVIEWERS
    Comms Service Provider33%
    Financial Services Firm25%
    Transportation Company8%
    Marketing Services Firm8%
    VISITORS READING REVIEWS
    Computer Software Company25%
    Financial Services Firm20%
    Comms Service Provider7%
    Government6%
    Company Size
    REVIEWERS
    Small Business31%
    Midsize Enterprise12%
    Large Enterprise58%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise15%
    Large Enterprise67%
    REVIEWERS
    Small Business40%
    Midsize Enterprise28%
    Large Enterprise32%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise10%
    Large Enterprise75%
    Buyer's Guide
    Microsoft Parallel Data Warehouse vs. Oracle Database Appliance
    November 2022
    Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Database Appliance and other solutions. Updated: November 2022.
    655,711 professionals have used our research since 2012.

    Microsoft Parallel Data Warehouse is ranked 14th in Data Warehouse with 3 reviews while Oracle Database Appliance is ranked 7th in Data Warehouse with 6 reviews. Microsoft Parallel Data Warehouse is rated 7.4, while Oracle Database Appliance is rated 7.6. The top reviewer of Microsoft Parallel Data Warehouse writes "The admission tools, BI tools, and data warehousing tools are great". On the other hand, the top reviewer of Oracle Database Appliance writes "Easy to implement and handles a lot of data but is too expensive". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake, SAP BW4HANA and Teradata, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Actian Ingres, IBM Netezza Performance Server and IBM Integrated Analytics System. See our Microsoft Parallel Data Warehouse vs. Oracle Database Appliance report.

    See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.

    We monitor all 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.