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

Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse.
To learn more, read our detailed Data Warehouse Report (Updated: March 2024).
763,955 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
"The most valuable feature for me is querying.""The most valuable features are the performance and usability.""Tools like the BI and SAS are excellent.""One of the most important features is the ease of using MS SQL.""​It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time.​""The UI is very simple and functional for my clients, most of the clients that use the solution are not experts.""It is a stable solution...It is a scalable solution.""It is a very stable database."

More Microsoft Parallel Data Warehouse Pros →

"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases.""Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard.""This is a comprehensive solution that is easy to deploy."

More Oracle Big Data Appliance Pros →

Cons
"I think that the error messages need to be made more specific.""I would like the tool to support different operating systems.""Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.""More tools to help designers should be included.""The product does not have all of the features that the native products have.""The query is slow if we don't optimize it.""The solution is expensive and has room for improvement.""The reporting for certain types of data needs to be improved."

More Microsoft Parallel Data Warehouse Cons →

"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera.""The product should be simplified for the average user.""It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."

More Oracle Big Data Appliance 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 →

  • "Oracle's prices are too high compared to others in the market."
  • More Oracle Big Data Appliance Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    763,955 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:Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard.
    Top Answer:From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera. Oracle could also improve Big Data… more »
    Top Answer:I use Big Data Appliance to have a single source of truth for my data and to keep all my data in one place.
    Ranking
    8th
    out of 33 in Data Warehouse
    Views
    638
    Comparisons
    516
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    12th
    out of 33 in Data Warehouse
    Views
    850
    Comparisons
    668
    Reviews
    1
    Average Words per Review
    235
    Rating
    8.0
    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 Big Data Appliance is a flexible, high-performance, secure platform for running diverse workloads on Hadoop and NoSQL systems. With Oracle Big Data SQL, Oracle Big Data Appliance extends Oracle’s industry-leading implementation of SQL to Hadoop and NoSQL systems. By combining the newest technologies from the Hadoop ecosystem and powerful Oracle SQL capabilities together on a single pre-configured platform, Oracle Big Data Appliance is uniquely able to support rapid development of new Big Data applications and tight integration with existing relational data.

    For more information on Oracle Big Data Appliance, visit Oracle.com

    Sample Customers
    Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
    Caixa Bank
    Top Industries
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Financial Services Firm18%
    Insurance Company7%
    University6%
    VISITORS READING REVIEWS
    Financial Services Firm22%
    University10%
    Computer Software Company8%
    Government6%
    Company Size
    REVIEWERS
    Small Business34%
    Midsize Enterprise14%
    Large Enterprise51%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise18%
    Large Enterprise66%
    REVIEWERS
    Small Business14%
    Midsize Enterprise14%
    Large Enterprise71%
    VISITORS READING REVIEWS
    Small Business19%
    Midsize Enterprise13%
    Large Enterprise67%
    Buyer's Guide
    Data Warehouse
    March 2024
    Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: March 2024.
    763,955 professionals have used our research since 2012.

    Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 12 reviews while Oracle Big Data Appliance is ranked 12th in Data Warehouse with 1 review. Microsoft Parallel Data Warehouse is rated 7.6, while Oracle Big Data Appliance is rated 8.0. The top reviewer of Microsoft Parallel Data Warehouse writes "User-friendly UI and good support". On the other hand, the top reviewer of Oracle Big Data Appliance writes "Provides clean, centralized data ". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum, whereas Oracle Big Data Appliance is most compared with Oracle Exadata, Apache Hadoop, Teradata and Microsoft Azure Synapse Analytics.

    See our list of best 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.