Try our new research platform with insights from 80,000+ expert users

Microsoft Parallel Data Warehouse vs Oracle Database Appliance comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
6.9
Microsoft Parallel Data Warehouse offers significant ROI by efficiently managing large data volumes and integrating with existing tools.
Sentiment score
7.1
Oracle Database Appliance offers long-term value with efficient support and quality, ensuring positive ROI despite variable setup complexity.
 

Customer Service

Sentiment score
6.8
Microsoft Parallel Data Warehouse support receives mixed reviews, praised for expertise but needing faster responses and improved Azure-related assistance.
Sentiment score
6.2
Oracle Database Appliance customer service is generally solid but faces criticism for costs, response times, and mixed hardware service experiences.
 

Scalability Issues

Sentiment score
7.2
Microsoft Parallel Data Warehouse scales well but requires SQL expertise; performance varies compared to alternatives like Snowflake.
Sentiment score
6.6
Oracle Database Appliance offers scalable CPU and storage options but faces limitations in on-premises scalability and storage scalability.
I give the scalability an eight out of ten, indicating it scales well for our needs.
All enterprise-grade analytics tools allow rapid scaling, making our business more competitive.
 

Stability Issues

Sentiment score
7.9
Microsoft Parallel Data Warehouse is praised for stability and reliability, handling large data volumes with minor concerns about processing speed.
Sentiment score
7.5
Oracle Database Appliance is praised for stability and performance, with minor issues resolved by support and high satisfaction ratings.
Microsoft Parallel Data Warehouse is stable for us because it is built on SQL Server.
 

Room For Improvement

Microsoft Parallel Data Warehouse needs enhancements in speed, scalability, compatibility, cost efficiency, and error messaging for better performance.
Oracle Database Appliance requires improved scalability, flexibility, integration, and pricing, along with AI features and better support.
When there are many users or many expensive queries, it can be very slow.
Microsoft Parallel Data Warehouse is excellent but very expensive.
The ETL designing process could be optimized for better efficiency.
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift.
 

Setup Cost

Microsoft Parallel Data Warehouse is cost-effective for large enterprises, but costs vary by data size, performance, and support.
Oracle Database Appliance is cost-effective for its value, but licensing and support can be expensive compared to alternatives.
Microsoft Parallel Data Warehouse is very expensive.
Oracle is on the higher end of the pricing spectrum, along with SAP.
 

Valuable Features

Microsoft Parallel Data Warehouse offers accelerated performance, seamless integration, and scalability, excelling in data management and business intelligence.
Oracle Database Appliance offers easy deployment, scalability, high performance, and seamless integration, popular for data processing and application hosting.
The columnstore index enhances data query performance by using less space and achieving faster performance than general indexing.
Microsoft Parallel Data Warehouse is used in the logistics area for optimizing SQL queries related to the loading and unloading of trucks.
The interface is very user-friendly.
The most valuable feature is the ease of dashboarding and ease of reporting.
 

Categories and Ranking

Microsoft Parallel Data War...
Ranking in Data Warehouse
10th
Average Rating
7.8
Reviews Sentiment
6.8
Number of Reviews
37
Ranking in other categories
No ranking in other categories
Oracle Database Appliance
Ranking in Data Warehouse
6th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
44
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of April 2025, in the Data Warehouse category, the mindshare of Microsoft Parallel Data Warehouse is 0.8%, down from 1.1% compared to the previous year. The mindshare of Oracle Database Appliance is 5.2%, down from 6.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

StevenLai - PeerSpot reviewer
Strong scalable solution with streamlined metadata warehousing
We use it to build our data warehouse and databases, and everything in the back end It helps streamline our metadata warehousing process. As it is our only type of data warehouse and database, it serves as our source, destination, and staging area. This product has many features which are useful…
Charu Mazumdar - PeerSpot reviewer
Simplifies database management tasks and provides high availability and disaster recovery
Oracle Database Appliance has simplified our database management tasks. Our clients are using the solution for high availability and disaster recovery. Our overall experience with the solution was good, especially the DR. Oracle Database Appliance's integrated storage solutions have enhanced our data management. Oracle Database Appliance's integration with other solutions was straightforward. We faced compatibility issues while moving from another device to this one, and the integration was not seamless. I would recommend the solution to other users. Overall, I rate the solution an 8 out of 10.
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
844,944 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
30%
Financial Services Firm
16%
Insurance Company
9%
Retailer
6%
Financial Services Firm
29%
Computer Software Company
12%
Manufacturing Company
9%
Government
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Microsoft Parallel Data Warehouse?
Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
What needs improvement with Microsoft Parallel Data Warehouse?
Microsoft Parallel Data Warehouse is excellent but very expensive. Working on the pricing could make it a better solution.
What do you like most about Oracle Database Appliance?
Oracle Database Appliance provides high stability.
What is your experience regarding pricing and costs for Oracle Database Appliance?
While I'm somewhat familiar with standard licensing, pricing isn't really my area of expertise. However, Oracle is on the higher end of the pricing spectrum, along with SAP.
What needs improvement with Oracle Database Appliance?
There is room for improvement in better integration with third-party tools, such as Power BI or Redshift. When dealing with federated data sources, this integration can be a challenge.
 

Also Known As

Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
X5-2
 

Overview

 

Sample Customers

Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
LifeLock, Incarlopsa, Al Yusur Industrial Contracting
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Database Appliance and other solutions. Updated: February 2025.
844,944 professionals have used our research since 2012.