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).
765,386 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 integrates beautifully with other Microsoft ecosystem products.""I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets.""Tools like the BI and SAS are excellent.""The most valuable feature is the business intelligence (BI) part of it.""We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it.""The UI is very simple and functional for my clients, most of the clients that use the solution are not experts.""I am very satisfied with the customer service/technical support.""One of the most important features is the ease of using MS SQL."

More Microsoft Parallel Data Warehouse Pros →

"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day.""Oracle is a stable database.""Oracle has good technical support.""The most valuable feature of the solution is the ability to combine all the data without the need for additional devices.""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 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.""We use the solution for our Java applications.""NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying."

More Oracle Database Appliance Pros →

Cons
"The reporting for certain types of data needs to be improved.""The query is slow if we don't optimize it.""I would like to see better visualization features.""SQL installation is pretty tricky. The scalability and customer support also should be improved.""It needs more compatibility with common BI tools.""More tools to help designers should be included.""We'd like to see it be a bit more compatible with other solutions.""The product does not have all of the features that the native products have."

More Microsoft Parallel Data Warehouse Cons →

"Oracle Database Appliance could improve by having better integration.""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.""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.""The tool's setup can be easier.""Oracle's product support is an area of concern where improvements are required.""Sometimes, we cannot upgrade or patch it easily. The performance needs to improve.""The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface.""The product's technical support services need improvement."

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.
    765,386 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 33 in Data Warehouse
    Views
    638
    Comparisons
    516
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    6th
    out of 33 in Data Warehouse
    Views
    3,114
    Comparisons
    2,273
    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 Company21%
    Financial Services Firm18%
    Insurance Company7%
    University6%
    REVIEWERS
    Financial Services Firm33%
    Comms Service Provider22%
    Retailer11%
    Transportation Company6%
    VISITORS READING REVIEWS
    Financial Services Firm29%
    Computer Software Company11%
    Government8%
    Manufacturing Company7%
    Company Size
    REVIEWERS
    Small Business34%
    Midsize Enterprise14%
    Large Enterprise51%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise18%
    Large Enterprise66%
    REVIEWERS
    Small Business44%
    Midsize Enterprise19%
    Large Enterprise36%
    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.
    765,386 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 38 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 "Stable solution with opportunities for performance enhancement". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum, 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.