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
32
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
 

Market share comparison

As of June 2024, in the Data Warehouse category, the market share of Microsoft Parallel Data Warehouse is 1.1% and it increased by 210.3% compared to the previous year. The market share of Oracle Exadata is 15.2% and it decreased by 28.5% 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

Albert Lacerda - PeerSpot reviewer
Mar 9, 2023
User-friendly UI and good support
The solution is expensive and has room for improvement. I believe the cost is the biggest issue. In Brazil, money is not easy to come by, and paying for this stuff is difficult. Most of my clients are moving to the cloud and purchasing some of the infrastructure there, but it is expensive and they don't always get the economic benefits the cloud can offer. They are creating the infrastructure from the cloud and paying a lot of money for it, and other costs are becoming problematic. Power BI is just one example. The process is the biggest barrier here, and sometimes lack of professional knowledge is also an issue. It is hard to find companies that really know what they are doing. The project I am involved in now is creating a data lake in the cloud for a big client. They hired another company, not mine, to create the project, but when we started the meetings I discovered that the big company they hired doesn't really know what they are doing and is still searching for professionals.
EP
Dec 29, 2022
Has newer technology and improved memory that gives it better performance
My company uses the latest version of Oracle Exadata. Maintaining Oracle Exadata requires one main DBA involved with the maintenance, and one backup, where the backup takes care of limited tasks involving storage, network, etc. My company also works with an on-call service as needed. It's not a continuous service or a service you use regularly. My company only calls when it's necessary. For example, if there's an event or incident in the production environment or a major maintenance task, such as an Oracle Exadata upgrade. My company also has some people involved when there's a change in the environment, or it needs help with the infrastructure. Internally, my company has around one thousand Oracle Exadata users, but externally, that number is more than one hundred thousand. There's no plan to increase its usage because the company has slow internal growth, but the growth rate is average externally. All people within my company use Oracle Exadata. My rating for Oracle Exadata is nine out of ten, though it would still depend on the customer. Some customers may not need the solution for their environment, but for me, I'd rate it a nine. My company is an Oracle Exadata customer.

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 for me is querying."
"It is not a pricey product compared to other data warehouse solutions."
"Tools like the BI and SAS are excellent."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"The most valuable features are the performance and usability."
"We have complete control over our data."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"It is a stable solution...It is a scalable solution."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"The data replication is very good."
"The performance on the databases is good."
"Exadata's best features are its performance during redo logging and the elasticity of the database handling."
"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."
"It has improved the performance, now we run with more performance cores with less CPU to attend all the database demands. Reducing Time to Market, increase our ability to face the competition with speed and low cost."
"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."
"The business intelligence is very good."
 

Cons

"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"I think that the error messages need to be made more specific."
"This solution would be improved with an option for in-memory data analysis."
"I would like to see better visualization features."
"The reporting for certain types of data needs to be improved."
"The query is slow if we don't optimize it."
"​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"I would like the tool to support different operating systems."
"It is difficult to evaluate return-on-investment because of the way billing is handled for the product. This should be improved by oracle."
"The technical support is in need of improvement."
"The handling of temp space has room for improvement."
"It would be good if Exadata made some new features available regarding data retrieval and speed capacity functions."
"License or upgrade management can be difficult and time consuming because it requires login to a separate console."
"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."
"In a future release, I would like to see some upgrade analysis advisors to help with a clear roadmap on steps that need to be taken and some of the automated processes."
"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."
 

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."
"Technical support is an additional fee and is expensive."
"I think the program is well-priced compared to the other offerings that are out in the market."
"All the features that we use do not require any additional subscription or yearly fees."
"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."
"The solution's pricing is fairly decent for organizations with huge data sizes."
"Oracle is always costly but it's fine."
"The majority of our customers are in government or big enterprises, and the projects that we sell come out to several million USD. With this amount of money on the table, it's always better to have an experienced team of consultants, who know Exadata very well, handle the implementation."
"I did note that Oracle does tend to internally oversize things especially if they want to fill up a budget, and hence third-party oversight is essential."
"I think it's free."
"The licensing can be a bit expensive because you need to have certain tools enabled that require them."
"The solution is expensive."
"Exadata is an expensive tool, but, considering the ROI, it's worth going for the solution."
"There is an annual license to use this solution. The solution is expensive."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
787,061 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
26%
Financial Services Firm
16%
Insurance Company
8%
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: May 2024.
787,061 professionals have used our research since 2012.