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
9th
Average Rating
7.6
Number of Reviews
33
Ranking in other categories
No ranking in other categories
Oracle Exadata
Ranking in Data Warehouse
2nd
Average Rating
8.4
Number of Reviews
125
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2024, in the Data Warehouse category, the mindshare of Microsoft Parallel Data Warehouse is 0.3%, down from 1.0% compared to the previous year. The mindshare of Oracle Exadata is 17.2%, down from 18.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
Unique Categories:
No other categories found
No other categories found
 

Q&A Highlights

it_user104457 - PeerSpot reviewer
Apr 13, 2014
 

Featured Reviews

DJ Kim - PeerSpot reviewer
Apr 9, 2024
Enhances data management process with efficient integration capabilities
Our customers use Microsoft Parallel Data Warehouse to manage large volumes of data and perform complex queries efficiently. Its performance is generally superior compared to other solutions, aiding in the efficient handling of large-scale data analytics projects The key features impacting our…
Javid Ur Rahaman - PeerSpot reviewer
Jun 2, 2023
Unified, integrated and scalable appliance with all components supported by one vendor
The solution is used for Extreme Bare metal and virtual compute performance for the business to scale up as per the heterogeneous database loads Exadata has greatly benefited our business cycle as operational efficiency has improved by 200%. Also, our business analytics platform performance has…

Quotes from Members

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

Pros

"The most valuable feature of this solution is performance."
"The solution has been reliable."
"The solution's integration is good."
"One of the most important features is the ease of using MS SQL."
"We can store the data in a data lake for a very low cost."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"Tools like the BI and SAS are excellent."
"The most valuable features are the performance and usability."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"Exadata is also a very stable environment. Their Smart Scan feature is great for every banking environment and financial institutions willing to implement it."
"It offers a significant advantage for accommodating a large number of users."
"It is a highly relevant option with extreme performance."
"Oracle has reliable solutions and this one is no different."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"Exadata with the In-Memory option is several levels about SAP HANA."
"The tool performs well with a large database."
 

Cons

"It could offer more development across the solution."
"The reporting for certain types of data needs to be improved."
"We'd like to see it be a bit more compatible with other solutions."
"If the database is large with a lot of columns then it is difficult to clean the data."
"I think that the error messages need to be made more specific."
"The product does not have all of the features that the native products have."
"I would like to see better visualization features."
"More tools to help designers should be included."
"Sometimes it takes too long time to get help with technical issues."
"Oracle Exadata compatibility with the analytics could be better and the OBIEE could improve. Oracle BI to Exadata needs to be improved. Even if the full analytics practice for Oracle should be improved and when compared with other solutions it is weak."
"The integration with third-party applications regarding access management security could be better."
"There is room for improvement with the handling of the Temp IO, which is often used for JOIN statements."
"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."
"Tech support sometimes takes some time to identify and rectify issues."
"One small area for improvement in Oracle Exadata is integration, particularly at the consolidated application level."
"The scalability can be improved as it is not a parallel execution."
 

Pricing and Cost Advice

"I think the program is well-priced compared to the other offerings that are out in the market."
"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."
"They offer an annual subscription. The pricing depends on the size of the environments."
"The tool could be expensive if we need to manage a lot of data."
"The solution's pricing is fairly decent for organizations with huge data sizes."
"The solution is cost-effective."
"All the features that we use do not require any additional subscription or yearly fees."
"The solution’s cost is a little bit more than the traditional databases."
"The price of Oracle Exadata is competitive. There are some features that are outside of the initial purchase license, such as some monitoring packages."
"The solution takes a lot of time to clone the environment. I would like to see some improvement in the cloning support or the time it takes on the storage side."
"Our customers are always looking to reduce the license's cost."
"It is an expensive product and you pay more for certain performance enhancements."
"The price of the solution has been expensive to implement."
"I would rate the tool's pricing a nine out of ten."
"In the sizing phase, you can also decide whether to license all cores, or reduce the number cores using capacity-on-demand features of Exadata, as well. This has a direct impact on licensing."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
792,694 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
25%
Financial Services Firm
17%
Insurance Company
7%
Educational Organization
6%
Financial Services Firm
28%
Computer Software Company
13%
Manufacturing Company
6%
Energy/Utilities Company
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 is your experience regarding pricing and costs for Microsoft Parallel Data Warehouse?
They offer an annual subscription. The pricing depends on the size of the environments.
What needs improvement with Microsoft Parallel Data Warehouse?
Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.
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?
I rate the tool’s pricing a three out of ten. The solution is expensive.
What needs improvement with Oracle Exadata?
The product must make more investments in object storage technologies. Six to seven years ago, the product had an SQL-based analytics feature that did not work well. The vendor must consider invest...
 

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: July 2024.
792,694 professionals have used our research since 2012.