Most Helpful Review
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Database Appliance and other solutions. Updated: January 2019.
317,440 professionals have used our research since 2012.
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
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.
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).
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.
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.
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.
out of 30 in Data Warehouse
out of 30 in Data Warehouse
Compared 26% of the time.
Compared 15% of the time.
Compared 14% of the time.
Compared 79% of the time.
Compared 7% of the time.
Compared 4% of the time.
Also Known As
|Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse||X5-2|
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.
Learn more about Microsoft Parallel Data Warehouse
Learn more about Oracle Database Appliance
|Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe||LifeLock, Incarlopsa, Al Yusur Industrial Contracting|