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: 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 Parallel Data Warehouse provides good firewall processing in terms of response time.""One of the most important features is the ease of using MS SQL.""It is a very stable database.""Tools like the BI and SAS are excellent.""It is not a pricey product compared to other data warehouse solutions.""Data collection and reporting are valuable features of the solution.""We have complete control over our data.""I am very satisfied with the customer service/technical support."

More Microsoft Parallel Data Warehouse Pros →

"The product’s valuable feature is its capability to pre-configure and pre-install the settings.""Oracle has good technical support.""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.""The most valuable feature of Oracle Database Appliance is the ease of management.""Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years.""The performance of the system is the solution's most valuable aspect. In combination with the database, it gives perfect results. It's a better system than using other kinds of integrated systems. In general, the ODA control is much simpler to use and offers up the best performance.""The solution is simple to use and easy to maintain.""Easy management (it saves a lot of installation and patching time)."

More Oracle Database Appliance Pros →

Cons
"It could offer more development across the solution.""SQL installation is pretty tricky. The scalability and customer support also should be improved.""The solution is expensive and has room for improvement.""Some compatibility issues occur during deployment, so we need to build the product from scratch for some features.""The feature updates on the on-premise solution come very slowly, and it would be great if they came faster.""The product must provide more frequent updates.""We'd like to see it be a bit more compatible with other solutions.""I would like the tool to support different operating systems."

More Microsoft Parallel Data Warehouse Cons →

"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability.""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.""The product is quite complex to set up, initially. It would be ideal if it was simpler.""The product's technical support services need improvement.""It would be beneficial to have dedicated RAM included in the Oracle Database Appliance.""In my opinion only one single command should be used for all ODA models, as it’s confusing.""The setup is a bit complex.""We would like the ability to add more storage without having to upgrade to Oracle Exadata."

More Oracle Database 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 →

  • "Get benefit from the capacity-on-demand features. License your cores according to your licenses."
  • "Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."
  • "In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
  • "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."
  • "Compared to Oracle Exadata, Oracle Database Appliance is affordable."
  • 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.
    768,740 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:The product is excellent. It is simple and reliable in terms of installation and maintenance.
    Top Answer:The product is costly. However, it is the price is justifiable for the excellent technology it offers.
    Top Answer:They could incorporate a more secure and internet-centric management system for the platform.
    Ranking
    8th
    out of 34 in Data Warehouse
    Views
    598
    Comparisons
    475
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    6th
    out of 34 in Data Warehouse
    Views
    3,045
    Comparisons
    2,195
    Reviews
    13
    Average Words per Review
    354
    Rating
    7.8
    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.

    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 Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company20%
    Financial Services Firm17%
    Insurance Company7%
    University6%
    REVIEWERS
    Financial Services Firm32%
    Comms Service Provider21%
    Retailer11%
    Transportation Company5%
    VISITORS READING REVIEWS
    Financial Services Firm29%
    Computer Software Company11%
    Government8%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business36%
    Midsize Enterprise14%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise18%
    Large Enterprise65%
    REVIEWERS
    Small Business42%
    Midsize Enterprise21%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise75%
    Buyer's Guide
    Microsoft Parallel Data Warehouse vs. Oracle Database Appliance
    March 2024
    Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Database Appliance and other solutions. Updated: March 2024.
    768,740 professionals have used our research since 2012.

    Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews while Oracle Database Appliance is ranked 6th in Data Warehouse with 39 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Oracle Database Appliance is rated 8.0. 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 Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, VMware Tanzu Greenplum and Snowflake, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Vertica. See our Microsoft Parallel Data Warehouse vs. Oracle Database Appliance report.

    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.