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."One of the most important features is the ease of using MS SQL."
"We have complete control over our data."
"The solution has been reliable."
"The data transmissions between the data models is the most valuable feature."
"The most valuable feature of this solution is performance."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"It performs very well overall."
"We can use virtualization on Exadata."
"We like the tool’s features like Smart Scan, Hybrid Columnar Compression, and the TFA."
"Oracle Exadata is stable."
"Exadata with the In-Memory option is several levels about SAP HANA."
"This product can noticeably enhance performance of contextual Oracle databases."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"The new Exadata x9m has an even higher speed of 100GBps connectivity."
"It is the best solution for OLTP and data warehousing."
"It could offer more development across the solution."
"This solution would be improved with an option for in-memory data analysis."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"If the database is large with a lot of columns then it is difficult to clean the data."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"The product must provide more frequent updates."
"The query is slow if we don't optimize it."
"We find the cost of the solution to be a little high."
"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."
"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 improvement could be made on the hardware level as the habit in the industry is to go better and faster and larger with every iteration."
"It would be nice to have a single click button to, say, migrate my VMware VM into the Oracle VM, or vice-versa."
"The setup is a little bit complex. We would like to see the installation part get easier."
"The cost of the solution is high and can be improved."
"The handling of temp space has room for improvement."
"I liked Spark, but it was discontinued when Exadata L6 came back. I loved it, and I wish they would bring back Spark integration."
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