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
Number of Reviews
34
Ranking in other categories
No ranking in other categories
Oracle Exadata
Ranking in Data Warehouse
2nd
Average Rating
8.6
Number of Reviews
126
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of October 2024, in the Data Warehouse category, the mindshare of Microsoft Parallel Data Warehouse is 1.1%, 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
Sep 20, 2024
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
Mar 9, 2023
Offers a variety of valuable features
The solution is used in enterprise applications with large databases for database consolidation. It can be used in the banking, finance, insurance, and telecom domain where performance is of prime importance We like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA.…

Quotes from Members

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

Pros

"The initial setup was straightforward."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"The most valuable feature is the business intelligence (BI) part of it."
"​It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time.​"
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"The data transmissions between the data models is the most valuable feature."
"Complete management occurs from one single address instead of different servers."
"The product is flexible."
"Regarding features, there are so many that we can offer to customers. When we sell Exadata Cloud, there are many options to choose from, especially when it comes to enterprise database options. In my experience, the main features that are appreciated are various ones like GPS and the assortment of security options."
"We like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA."
"The technical support team are real professionals. I admire their technical skills and supports. Their supports are really admirable."
"The ease of setup is an eight out of ten."
"The key capability of Exadata, which is not found in any other solution or appliance, is its enhancement specifically for databases."
"Oracle is known to be the number one in their industry; the help and support, the features they are giving the clients comparing to other databases, the new technology, the provide a good solution."
 

Cons

"A major issue is with table statistics. Sometimes the statistics are not refreshed correctly, which causes issues for us."
"More tools to help designers should be included."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"It needs more compatibility with common BI tools."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"The product does not have all of the features that the native products have."
"It could offer more development across the solution."
"There is a feature for security, but it is not included in the first purchase of this solution. That means if you need to increase the security, you need to buy the security feature which doesn't come by default on these solutions."
"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."
"A room for improvement in Oracle Exadata is that it's not very easy to use in a microservices environment. It's not easy to split databases, and if this was easier to do in Oracle Exadata, it would make the solution better. What I'd like to see in the next release of Oracle Exadata is for it to become more modular, so you can use it in a context where the data layer is spread between many independent services."
"Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up."
"I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
"The cost of the solution is high and can be improved."
"It would be nice to have a single click button to, say, migrate my VMware VM into the Oracle VM, or vice-versa."
"Since the product is an appliance, it is very costly."
 

Pricing and Cost Advice

"Technical support is an additional fee and is expensive."
"The solution is cost-effective."
"The solution's pricing is fairly decent for organizations with huge data sizes."
"I think the program is well-priced compared to the other offerings that are out in the market."
"The tool could be expensive if we need to manage a lot of data."
"They offer an annual subscription. The pricing depends on the size of the environments."
"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."
"All the features that we use do not require any additional subscription or yearly fees."
"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."
"It is quite expensive."
"We pay for an annual license and it is expensive."
"I would rate the tool's pricing a nine out of ten."
"I'm giving Oracle Exadata five out of ten in terms of pricing. Its price could be lower."
"The solution is expensive."
"The Initial investment price could use improvement"
"Oracle Exadata is not a cheap solution. Pricing is a problem for Oracle, and every client, not just my company, would like the vendor to improve on the price, or lower the price. My company paid for several years' worth of Oracle Exadata licenses. You need to pay for the technical support and other features separately, on different contracts. In terms of affordability, my rating for Oracle Exadata is two out of five."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
813,418 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
27%
Financial Services Firm
18%
Insurance Company
8%
Government
6%
Financial Services Firm
29%
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?
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: October 2024.
813,418 professionals have used our research since 2012.