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: May 2024).
772,679 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 is not a pricey product compared to other data warehouse solutions.""The data transmissions between the data models is the most valuable feature.""Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products.""Data collection and reporting are valuable features of the solution.""I am very satisfied with the customer service/technical support.""The most valuable features are the performance and usability.""The UI is very simple and functional for my clients, most of the clients that use the solution are not experts.""​It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time.​"

More Microsoft Parallel Data Warehouse Pros →

"The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers.""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.""I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes.""Easy management (it saves a lot of installation and patching time).""The most valuable feature of Oracle Database Appliance is the ease of management.""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 is a stable database.""The most valuable feature is the performance."

More Oracle Database Appliance Pros →

Cons
"We find the cost of the solution to be a little high.""If the database is large with a lot of columns then it is difficult to clean the data.""The only issue with the product is that the process is very slow when we have a huge amount of data.""I would like to see better visualization features.""The reporting for certain types of data needs to be improved.""​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.""I would like the tool to support different operating systems.""They need to incorporate a machine learning engine."

More Microsoft Parallel Data Warehouse Cons →

"Oracle could improve its capacity for built-in visualization.""Sometimes, we cannot upgrade or patch it easily. The performance needs to improve.""The tool's setup can be easier.""They could incorporate a more secure and internet-centric management system for the platform.""Technical support is not so great. It could be much better. The maintenance, for an enterprise system, isn't so great. It's also extremely expensive.""The product's technical support services need improvement.""The product's pricing is too high. We plan to migrate to another database in three to four years.""The main thing would be to make ODA more affordable, to make it a more economical machine. Also, I would like to see virtualization, so you could implement all of your functions on one machine. Finally, improvement in the speed and performance would be good."

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.
    772,679 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:Oracle Database Appliance provides high stability.
    Top Answer:On a scale from 1 to 10, where 1 is cheap and 10 is expensive, I rate the solution's pricing 7.5 or 8 out of 10.
    Top Answer:The solution’s pricing could be improved.
    Ranking
    9th
    out of 35 in Data Warehouse
    Views
    553
    Comparisons
    425
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    7th
    out of 35 in Data Warehouse
    Views
    2,847
    Comparisons
    2,029
    Reviews
    12
    Average Words per Review
    347
    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 Company26%
    Financial Services Firm17%
    Insurance Company8%
    Educational Organization6%
    REVIEWERS
    Financial Services Firm32%
    Comms Service Provider21%
    Retailer11%
    Transportation Company5%
    VISITORS READING REVIEWS
    Financial Services Firm29%
    Computer Software Company11%
    Government8%
    Manufacturing Company7%
    Company Size
    REVIEWERS
    Small Business36%
    Midsize Enterprise14%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business22%
    Midsize Enterprise18%
    Large Enterprise60%
    REVIEWERS
    Small Business42%
    Midsize Enterprise21%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    Buyer's Guide
    Microsoft Parallel Data Warehouse vs. Oracle Database Appliance
    May 2024
    Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Database Appliance and other solutions. Updated: May 2024.
    772,679 professionals have used our research since 2012.

    Microsoft Parallel Data Warehouse is ranked 9th in Data Warehouse with 32 reviews while Oracle Database Appliance is ranked 7th in Data Warehouse with 40 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 and Snowflake, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Data Services, 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.