Try our new research platform with insights from 80,000+ expert users

Microsoft Parallel Data Warehouse vs Oracle Exadata 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 Exadata
Ranking in Data Warehouse
2nd
Average Rating
8.6
Reviews Sentiment
7.3
Number of Reviews
126
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 Exadata is 19.0%, up from 18.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Q&A Highlights

it_user104457 - PeerSpot reviewer
Apr 13, 2014
 

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…
Guruprasad Gonjare - PeerSpot reviewer
Offers a variety of valuable features
The deployment depends on the Exadata options. There are primarily three options which include, Exadata, Exadata Cloud@Customer, and Exadata Cloud Service. Out of these, Cloud Service requires the minimum effort. The deployment takes around two to three weeks to complete. For the deployment purpose, we need information on the user base where the access is going to happen. We would also require around four to five engineers and admins for the solution’s deployment and maintenance. This estimation is based on the workflow.

Quotes from Members

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

Pros

"It is not a pricey product compared to other data warehouse solutions."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"The most valuable feature of this solution is performance."
"I am very satisfied with the customer service/technical support."
"The data transmissions between the data models is the most valuable feature."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"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."
"The solution's integration is good."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"The most valuable feature is the time to solution."
"The most valuable feature of Oracle Exadata is the integration with other solutions, such as SAN storage and shared VLAN network."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"They just have a lot of products, and they work well together."
"The most valuable feature is that you have the same familiar environment of an Oracle database but with the additional performance you get from this architecture."
"Exadata's best features are its performance during redo logging and the elasticity of the database handling."
"On-premises Exadata is just as stable as the cloud version. It's a very stable platform."
 

Cons

"It could be made more user-friendly for business users which would increase the user base."
"The solution is expensive and has room for improvement."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"The product scalability needs improvement."
"We find the cost of the solution to be a little high."
"I would like the tool to support different operating systems."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"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."
"There is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."
"The customization can sometimes be difficult to achieve."
"The handling of temp space has room for improvement."
"We used the support from Oracle Exadata to complete the implementation."
"The scalability can be improved as it is not a parallel execution."
"Certification should also be improved. Today, Oracle doesn't certify applications with engineered systems."
"Oracle Exadata could improve by having faster data retrieval. We receive data at four or five seconds and want to reduce that number to one second."
"Exadata would be improved with single dashboard visibility."
 

Pricing and Cost Advice

"The solution is cost-effective."
"They offer an annual subscription. The pricing depends on the size of the environments."
"Technical support is an additional fee and is expensive."
"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."
"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."
"All the features that we use do not require any additional subscription or yearly fees."
"I think the program is well-priced compared to the other offerings that are out in the market."
"We pay for an annual license and it is expensive."
"I would rate the tool's pricing a nine out of ten."
"Exadata is an expensive tool, but, considering the ROI, it's worth going for the solution."
"It is quite expensive."
"You have to pay for the storage and the database in Oracle Exadata. It cost a lot, but it is worth it. It would be a benefit if we could reduce the price for the number of CPUs and extend the memory."
"The price of Oracle Exadata is competitive. There are some features that are outside of the initial purchase license, such as some monitoring packages."
"Oracle is always costly but it's fine."
"I'm giving Oracle Exadata five out of ten in terms of pricing. Its price could be lower."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
816,636 professionals have used our research since 2012.
 

Answers from the Community

it_user104457 - PeerSpot reviewer
Apr 13, 2014
Apr 13, 2014
I think hands down it's Exadata since for the front end apps it's just another Oracle database which means everything under the sun is compatible with it.
2 out of 3 answers
it_user89046 - PeerSpot reviewer
Apr 10, 2014
Given we partner with many or all of the above, or can get to them as we access all data, I have the following opinion - InfoBright is very new and probable to be sold long term. It is also an expensive subscription so presents highest risk to me. Exidata is Oracle - if you like Oracle and their style, it maybe ok, but then it is Oracle. Microsoft is Microsoft - tends to be cheap to acquire and expensive to implement and maintain. Teradata is pricey but of the group presents the least risk and the greatest number of front end partners. The product I represent is unique as it is designed for high complexity large numbers of users and data and runs inside Teradata taking better advantage of the architecture. Disclosure: I work for Information Builders
it_user3309 - PeerSpot reviewer
Apr 10, 2014
You are asking about front end tools but you do not mention which ones. What you have are "database backends" and each has different features. The utilization will depend on what kind of expertise you have available else you will end up trying to implement say, Teradata on Exadata which may not give you the best solution. What are your criteria for success? Based on these you will have to evaluate each solution -- I am sure each vendor will be happy to set up the environment and work with your set of sampl,e data to show you have they evaluate against your criteria.
 

Top Industries

By visitors reading reviews
Computer Software Company
28%
Financial Services Firm
19%
Insurance Company
7%
Government
6%
Financial Services Firm
30%
Computer Software Company
13%
Manufacturing Company
6%
Government
5%
 

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 Exadata?
It is the best solution for OLTP and data warehousing.
What is your experience regarding pricing and costs for Oracle Exadata?
The pricing of Exadata is high. It is more expensive than usual, making it suitable only for big enterprises or businesses that can afford it.
What needs improvement with Oracle Exadata?
I would like to add some features to run applications or microservices-based applications on Exadata.
 

Also Known As

Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
No data available
 

Learn More

 

Overview

 

Sample Customers

Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Oracle Exadata and other solutions. Updated: November 2024.
816,636 professionals have used our research since 2012.