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 Summary
 

Categories and Ranking

Microsoft Parallel Data War...
Ranking in Data Warehouse
10th
Average Rating
7.8
Reviews Sentiment
7.4
Number of Reviews
34
Ranking in other categories
No ranking in other categories
Oracle Database Appliance
Ranking in Data Warehouse
8th
Average Rating
8.0
Reviews Sentiment
6.1
Number of Reviews
43
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Data Warehouse category, the mindshare of Microsoft Parallel Data Warehouse is 1.0%, down from 1.3% compared to the previous year. The mindshare of Oracle Database Appliance is 5.4%, 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…
AdnanNaseem - PeerSpot reviewer
Offers built-in utilities and tools that simplify management
Oracle often releases updated versions of Database Appliance with improvements. However, I think Oracle should focus on further automating database management and IT-related tasks, such as backups. They've made progress with daily database stat automation, which is a good feature. Moreover, every product benefits from new functionality over time. I would like to see a centralized terminal where we can easily manage the database and its components with drag-and-drop functionality instead of relying solely on commands. So, I would like to see a centralized dashboard. Other areas of improvement include customer service and support, and scalability.

Quotes from Members

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

Pros

"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"The solution has been reliable."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"We have complete control over our data."
"The most valuable feature is the business intelligence (BI) part of it."
"It is a stable solution...It is a scalable solution."
"I am very satisfied with the customer service/technical support."
"The solution is pretty automated, which takes out the possibility of human error."
"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."
"Oracle Database Appliances are specifically designed for Oracle databases. They have built-in utilities and tools that simplify management, making them the best option for Oracle database management systems."
"The most valuable feature is the performance."
"The product is good value for money. It is a secure solution."
"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 database is solid."
"The initial setup was straightforward and quick - I was able to configure everything within an hour."
 

Cons

"The product scalability needs improvement."
"The product does not have all of the features that the native products have."
"A major issue is with table statistics. Sometimes the statistics are not refreshed correctly, which causes issues for us."
"The solution is expensive and has room for improvement."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"The reporting for certain types of data needs to be improved."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"I would like the tool to support different operating systems."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"It isn't as popular as AWS, GCP, or Azure as it lacks scalability and cloud-native services like containerization."
"Oracle Database Appliance could improve by having better integration."
"Oracle's product support is an area of concern where improvements are required."
"Oracle could improve its capacity for built-in visualization."
"The license cost could be cheaper, especially for long-term contracts."
"The setup is a bit complex."
"The product's technical support services need improvement."
 

Pricing and Cost Advice

"I think the program is well-priced compared to the other offerings that are out in the market."
"The solution is cost-effective."
"They offer an annual subscription. The pricing depends on the size of the environments."
"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."
"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."
"Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."
"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."
"You must pay for the license."
"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 Database Application's support and maintenance are included in the contract."
"The solution's pricing is very high."
"Oracle’s pricing is ridiculously high."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
28%
Financial Services Firm
19%
Insurance Company
7%
Government
6%
Financial Services Firm
29%
Computer Software Company
11%
Government
8%
Manufacturing Company
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?
There are many areas for improvement. A major issue is with table statistics. Sometimes the statistics are not refreshed correctly, which causes issues for us. When we update a table, it should tri...
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?
Oracle solutions are a bit overpriced, especially for small or medium businesses. I would prefer a slightly lower price point.
What needs improvement with Oracle Database Appliance?
All improvements for ODA are already applied or enhanced in Exadata. ODA is mainly for small businesses or limited businesses and is used predominantly for database warehouses and not for OLTP data...
 

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: November 2024.
816,406 professionals have used our research since 2012.