We performed a comparison between Microsoft Parallel Data Warehouse and Oracle Exadata based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature for me is querying."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"I am very satisfied with the customer service/technical support."
"It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."
"It handles high volumes of data very well."
"Tools like the BI and SAS are excellent."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"The solution's integration is good."
"We like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA."
"Oracle Exadata is stable."
"Compression is a great feature, where one can really save a lot of storage."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"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."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"It offers a significant advantage for accommodating a large number of users."
"We can use virtualization on Exadata."
"The reporting for certain types of data needs to be improved."
"They need to incorporate a machine learning engine."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"The query is slow if we don't optimize it."
"If the database is large with a lot of columns then it is difficult to clean the data."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"This solution would be improved with an option for in-memory data analysis."
"Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time."
"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."
"There's room for improvement in terms of deployment, as it could be made faster and more user-friendly."
"The customization can sometimes be difficult to achieve."
"The solution's pricing is very high."
"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 initial setup process is very difficult and extremely complex."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Microsoft Parallel Data Warehouse is ranked 9th in Data Warehouse with 32 reviews while Oracle Exadata is ranked 2nd in Data Warehouse with 125 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Oracle Exadata is rated 8.4. The top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". On the other hand, the top reviewer of Oracle Exadata writes "Offers a variety of valuable features". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, SAP BW4HANA and Snowflake, whereas Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse and Snowflake. See our Microsoft Parallel Data Warehouse vs. Oracle Exadata report.
See our list of best 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.
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.
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