Compare Microsoft Parallel Data Warehouse vs. Oracle Database Appliance

Microsoft Parallel Data Warehouse is ranked 7th in Data Warehouse with 9 reviews while Oracle Database Appliance is ranked 10th in Data Warehouse with 3 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Oracle Database Appliance is rated 8.4. The top reviewer of Microsoft Parallel Data Warehouse writes "Collects data through SSIS packages from different sources and puts them all in one data repository". On the other hand, the top reviewer of Oracle Database Appliance writes "Has drastically reduced the amount of processing time from seven days to one day". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure SQL Data Warehouse, Oracle Exadata, Snowflake, VMware Tanzu Greenplum and Teradata, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, SAP BW4HANA, IBM Integrated Analytics System and Apache Hadoop. 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 Oracle Database Appliance? Share your opinion.
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Database Appliance and other solutions. Updated: July 2020.
430,376 professionals have used our research since 2012.
Quotes From Members

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

Pros
Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity or ease of use when getting a resource and knowing everything about it.We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it.The most valuable feature is the business intelligence (BI) part of it.The data transmissions between the data models is the most valuable feature.The most valuable feature of this solution is performance.One of the most important features is the ease of using MS SQL.The most valuable feature for me is querying.The most valuable features are the performance and usability.

More Microsoft Parallel Data Warehouse Pros »

The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day.The solution is simple to use and easy to maintain.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.

More Oracle Database Appliance Pros »

Cons
I would like the tool to support different operating systems.If the database is large with a lot of columns then it is difficult to clean the data.This solution would be improved with an option for in-memory data analysis.The reporting for certain types of data needs to be improved.I think that the error messages need to be made more specific.I would like to see better visualization features.More tools to help designers should be included.In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating.

More Microsoft Parallel Data Warehouse Cons »

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.If we were able to use Oracle Database to create mobile apps, that would be great. I don't know multiple languages, like Java, etc. I need to learn a separate language, right now in order to do this.Technical support is not so great. It could be much better. The maintenance, for an enterprise system, isn't so great. It's also extremely expensive.

More Oracle Database Appliance Cons »

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.I think the program is well-priced compared to the other offerings that are out in the market.

More Microsoft Parallel Data Warehouse Pricing and Cost Advice »

Information Not Available
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
430,376 professionals have used our research since 2012.
Ranking
7th
out of 32 in Data Warehouse
Views
2,634
Comparisons
1,930
Reviews
9
Average Words per Review
463
Avg. Rating
7.7
10th
out of 32 in Data Warehouse
Views
4,305
Comparisons
2,802
Reviews
3
Average Words per Review
434
Avg. Rating
8.3
Popular Comparisons
Also Known As
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data WarehouseX5-2
Learn
Microsoft
Oracle
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
Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel EuropeLifeLock, Incarlopsa, Al Yusur Industrial Contracting
Top Industries
REVIEWERS
Computer Software Company30%
Comms Service Provider10%
Healthcare Company10%
Hospitality Company10%
VISITORS READING REVIEWS
Computer Software Company35%
Financial Services Firm8%
Comms Service Provider7%
Media Company7%
VISITORS READING REVIEWS
Computer Software Company58%
Comms Service Provider12%
Government5%
Media Company5%
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Database Appliance and other solutions. Updated: July 2020.
430,376 professionals have used our research since 2012.

See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.

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.