Microsoft Parallel Data Warehouse vs Oracle Database Appliance

Microsoft Parallel Data Warehouse is ranked 10th in Data Warehouse with 3 reviews vs Oracle Database Appliance which is ranked 7th in Data Warehouse with 12 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 Netezza. See our Microsoft Parallel Data Warehouse vs Oracle Database Appliance report.
Cancel
You must select at least 2 products to compare!
+Add products to compare
Most Helpful Review
Microsoft parallel data warehouse vs. oracle database appliance report from it central station 2018 05 04 thumbnail
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs Oracle Database Appliance and others in Data Warehouse.
270,274 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 »

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 »

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 »

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 »

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 »

Microsoft parallel data warehouse vs. oracle database appliance report from it central station 2018 05 04 thumbnail
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs Oracle Database Appliance and others in Data Warehouse.
270,274 professionals have used our research since 2012.
Ranking
RANKING
Views
5,022
Comparisons
3,551
Reviews
3
Followers
851
Avg. Rating
5.7
Views
2,645
Comparisons
1,405
Reviews
13
Followers
405
Avg. Rating
8.0
Top Comparisons
Top ComparisonsSee more Microsoft Parallel Data Warehouse competitors »See more Oracle Database Appliance competitors »
Also Known As
Also Known AsMicrosoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data WarehouseX5-2
Website/Video
Website/VideoMicrosoft
  • Vendor 7622 screenshot 1524943927
Oracle
  • Vendor 7751 screenshot 1524945170
OverviewQuestionmark icon
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. 

OFFER
Learn more about Microsoft Parallel Data Warehouse
Learn more about Oracle Database Appliance
Sample Customers
Sample CustomersAuckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel EuropeLifeLock, Incarlopsa, Al Yusur Industrial Contracting
Top IndustriesQuestionmark icon
Top Industries
VISITORS READING REVIEWS
Financial Services Firm
21%
Hospitality Company
10%
Comms Service Provider
9%
Healthcare Company
8%
No Data Available
Company SizeQuestionmark icon
Company Size
REVIEWERS
Small Business
25%
Midsize Enterprise
13%
Large Enterprise
63%
VISITORS READING REVIEWS
Small Business
11%
Midsize Enterprise
19%
Large Enterprise
70%
REVIEWERS
Small Business
55%
Midsize Enterprise
18%
Large Enterprise
27%
Microsoft parallel data warehouse vs. oracle database appliance report from it central station 2018 05 04 thumbnail
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs Oracle Database Appliance and others in Data Warehouse.
Download now
270,274 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