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
6th
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 January 2025, in the Data Warehouse category, the mindshare of Microsoft Parallel Data Warehouse is 0.9%, down from 1.3% compared to the previous year. The mindshare of Oracle Database Appliance is 5.4%, down from 6.4% 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

"One of the most important features is the ease of using MS SQL."
"The interface is very user-friendly."
"It handles high volumes of data very well."
"It performs very well overall."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"It is very strong, scalable, and has tons of features."
"We can store the data in a data lake for a very low cost."
"The data transmissions between the data models is the most valuable feature."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"The tool is a specific and effective system. I am impressed with its usability."
"Oracle Database Appliance provides high stability."
"The most valuable feature of the solution is the ability to combine all the data without the need for additional devices."
"We use the solution for our Java applications."
"The solution is pretty automated, which takes out the possibility of human error."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"Oracle offers ETL with PL/SQL as a programming language for SQL programming, which is majorly used in data engineering."
 

Cons

"The query is slow if we don't optimize it."
"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."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"It could be made more user-friendly for business users which would increase the user base."
"I think that the error messages need to be made more specific."
"I would like the tool to support different operating systems."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"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."
"I would like it if the scalability could be increased without having to change versions."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"They could incorporate a more secure and internet-centric management system for the platform."
"Oracle Database Appliance could improve by having better integration."
"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 solution’s flexibility could be improved."
 

Pricing and Cost Advice

"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."
"The solution's pricing is fairly decent for organizations with huge data sizes."
"Technical support is an additional fee and is expensive."
"The tool could be expensive if we need to manage a lot of data."
"The solution is cost-effective."
"They offer an annual subscription. The pricing depends on the size of the environments."
"I think the program is well-priced compared to the other offerings that are out in the market."
"All the features that we use do not require any additional subscription or yearly fees."
"The product is costly."
"The solution's pricing is very high."
"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
"You must pay for the license."
"Oracle Database Application's support and maintenance are included in the contract."
"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."
"Compared to Oracle Exadata, Oracle Database Appliance is affordable."
"Oracle Database Appliance is a very expensive solution. If you have opted for the on-premises licenses from Oracle, then you have to pay yearly. If you have opted for the cloud subscriptions offered by Oracle, then you can pay either monthly or yearly."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
831,158 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
29%
Financial Services Firm
19%
Insurance Company
9%
Government
6%
Financial Services Firm
29%
Computer Software Company
12%
Manufacturing Company
8%
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?
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
 

Learn More

 

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: January 2025.
831,158 professionals have used our research since 2012.