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:
 

Categories and Ranking

Microsoft Parallel Data War...
Ranking in Data Warehouse
10th
Average Rating
7.8
Reviews Sentiment
6.8
Number of Reviews
35
Ranking in other categories
No ranking in other categories
Oracle Database Appliance
Ranking in Data Warehouse
7th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
43
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2025, in the Data Warehouse category, the mindshare of Microsoft Parallel Data Warehouse is 0.8%, down from 1.2% compared to the previous year. The mindshare of Oracle Database Appliance is 5.5%, down from 6.3% 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.

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 most valuable feature is the business intelligence (BI) part of it."
"Data collection and reporting are valuable features of the solution."
"I am very satisfied with the customer service/technical support."
"The solution's integration is good."
"It handles high volumes of data very well."
"Tools like the BI and SAS are excellent."
"The most valuable features are the performance and usability."
"The initial setup was straightforward and quick - I was able to configure everything within an hour."
"The database is solid."
"The solution is simple to use and easy to maintain."
"The solution is pretty automated, which takes out the possibility of human error."
"The product is good value for money. It is a secure solution."
"We value the appliance architecture with its “everything-in-a-box” highly standardized setup."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks."
 

Cons

"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"I would like the tool to support different operating systems."
"It needs more compatibility with common BI tools."
"A major issue is with table statistics. Sometimes the statistics are not refreshed correctly, which causes issues for us."
"When there are many users or many expensive queries, it can be very slow."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"The product must provide more frequent updates."
"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."
"They could incorporate a more secure and internet-centric management system for the platform."
"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."
"I would rate the scalability a seven out of ten. It has some problems. Databases are huge. This leads to needing more and more RAM and capacity resources, making it hard to scale. Because of this, we use Exadata. That's definitely a point for improvement."
"In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."
"The setup is a bit complex."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
"The solution's initial setup is not easy."
 

Pricing and Cost Advice

"They offer an annual subscription. The pricing depends on the size of the environments."
"Technical support is an additional fee and is expensive."
"The tool could be expensive if we need to manage a lot of data."
"All the features that we use do not require any additional subscription or yearly fees."
"The solution is cost-effective."
"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."
"I think the program is well-priced compared to the other offerings that are out in the market."
"The solution's pricing is fairly decent for organizations with huge data sizes."
"The solution may be expensive, but when we consider the problems it solves, the stability it provides, and the fact that we don't have to buy separate parts and assemble them into a system, it becomes more affordable."
"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing seven and a half or eight out of ten."
"Oracle’s pricing is ridiculously high."
"I would rate the pricing a four on a scale of one (high price) to ten (low cost)."
"You must pay for the license."
"The product is costly."
"The price of the solution should be less expensive. However, they will increase the price more."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
838,640 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
29%
Financial Services Firm
18%
Insurance Company
9%
Government
7%
Financial Services Firm
29%
Computer Software Company
11%
Government
9%
Manufacturing Company
9%
 

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?
When there are many users or many expensive queries, it can be very slow.
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?
I have heard from colleagues that Oracle is very costly compared to open databases like PostgreSQL. I cannot personally comment on it.
What needs improvement with Oracle Database Appliance?
The scalability part is missing. It isn't as popular as AWS, GCP, or Azure as it lacks scalability and cloud-native services like containerization. The Oracle cloud hasn't reached the level of offe...
 

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.
838,640 professionals have used our research since 2012.