Microsoft Parallel Data Warehouse vs. Oracle Database Appliance

Microsoft Parallel Data Warehouse is ranked 11th in Data Warehouse with 3 reviews vs Oracle Database Appliance which is ranked 6th in Data Warehouse with 14 reviews. The top reviewer of Microsoft Parallel Data Warehouse writes "Gives us the ability to distribute large data sets across nodes". The top reviewer of Oracle Database Appliance writes "Puts our storage, server, and database all in one box; it's more cost effective for us". Microsoft Parallel Data Warehouse is most compared with Oracle Exadata, Teradata and Netezza. Oracle Database Appliance is most compared with Oracle Exadata, Vertica and Pivotal Greenplum. See our Microsoft Parallel Data Warehouse vs. Oracle Database Appliance report.
Cancel
You must select at least 2 products to compare!
Most Helpful Review
Use Null Product? Share your opinion.
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Database Appliance and others in Data Warehouse.
301,063 professionals have used our research since 2012.

Quotes From Members Comparing Microsoft Parallel Data Warehouse vs. Oracle Database Appliance

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pros
It handles high volumes of data very well.​It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time.​

Read more »

The performance due to the all-flash of ODA is very nice.We primarily use it for OLTP, which has improved our costs.I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes.We value the appliance architecture with its “everything-in-a-box” highly standardized setup.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.Easy management (it saves a lot of installation and patching time).

Read more »

Read more »

Cons
It needs more compatibility with common BI tools.​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.

Read more »

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.Oracle Database Appliance patching comes out two to three months after the regular patching cycle.In my opinion only one single command should be used for all ODA models, as it’s confusing.Virtualization features could also be improved. A web-based GUI would be a good start.I would be happy to see the Oracle Auto Service Request (ASR) pre-installed in it instead of installing it in a separate machine.

Read more »

Read more »

Pricing and Cost Advice
Information Not Available
In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution.Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE.Get benefit from the capacity-on-demand features. License your cores according to your licenses.

Read more »

Information Not Available
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
301,063 professionals have used our research since 2012.
Ranking
Views
5,743
Comparisons
2,879
Reviews
3
Followers
439
Avg. Rating
5.7
Views
3,732
Comparisons
1,952
Reviews
14
Followers
172
Avg. Rating
8.1
Views
0
Comparisons
0
Reviews
1
Followers
1
Avg. Rating
5.0
Top Comparisons
See more Microsoft Parallel Data Warehouse competitors »See more Oracle Database Appliance competitors »
Also Known As
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data WarehouseX5-2
Website/Video
Microsoft
Oracle
Null Vendor
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.

The Oracle Database Appliance saves time and money by simplifying deployment, maintenance, and support of database solutions for organizations of every size. Optimized for the world's most popular database--Oracle Database--it integrates software, compute, storage, and network resources to deliver database services for a wide range of custom and packaged online transaction processing (OLTP), in-memory database, and data warehousing applications. All hardware and software components are engineered and supported by Oracle, offering customers a reliable and secure system with built-in automation and best practices. In addition to accelerating the time to value when deploying database solutions, the Oracle Database Appliance offers flexible Oracle Database licensing options and reduces operational expenses associated with maintenance and support. 

Information Not Available
OFFER
Learn more about Microsoft Parallel Data Warehouse
Learn more about Oracle Database Appliance
Learn more about Null Product
Sample Customers
Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel EuropeLifeLock, Incarlopsa, Al Yusur Industrial Contracting
Information Not Available
Top Industries
VISITORS READING REVIEWS
Financial Services Firm
21%
Hospitality Company
10%
Comms Service Provider
9%
Insurance Company
8%
No Data Available
No Data Available
Company Size
REVIEWERS
Small Business
38%
Midsize Enterprise
13%
Large Enterprise
50%
VISITORS READING REVIEWS
Small Business
11%
Midsize Enterprise
19%
Large Enterprise
70%
REVIEWERS
Small Business
50%
Midsize Enterprise
17%
Large Enterprise
33%
No Data Available
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Database Appliance and others in Data Warehouse.
Download now
301,063 professionals have used our research since 2012.
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.

Sign Up with Email