We performed a comparison between Microsoft Parallel Data Warehouse, Oracle Exadata, and Teradata based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The most valuable feature of this solution is performance."
"It is not a pricey product compared to other data warehouse solutions."
"The most valuable features are the performance and usability."
"The solution's integration is good."
"We have complete control over our data."
"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."
"It is a stable solution...It is a scalable solution."
"What I found most valuable in Oracle Exadata is its newer technology that gives better performance. It has more recent hardware and significant changes in the architecture, so it's better than older solutions."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"The business intelligence is very good."
"Exadata is a fantastic machine. Two features stand out. The first is the resource input/output management tool that allows you to manage the resources to the neck on the Exadata box."
"It is a highly relevant option with extreme performance."
"The most valuable feature is storage offloading."
"The performance of the data is the most important part."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good."
"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"Improved performance of ETL procedures, reporting."
"The product must provide more frequent updates."
"I would like the tool to support different operating systems."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"We find the cost of the solution to be a little high."
"The query is slow if we don't optimize it."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"The solution lacks a visualized console."
"Oracle Exadata has room for improvement in pricing, especially for smaller companies. The solution is okay for bigger companies, but for smaller companies, it isn't."
"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."
"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 could improve by having faster data retrieval. We receive data at four or five seconds and want to reduce that number to one second."
"The management monitoring tools are quite important and an area that needs some improvement."
"The performance could be improved."
"Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"Limited interest and success in some areas make us hesitate about upgrading."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"I would like to see more integration with many different types of data."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"Apart from Control-M, it would be nice if it could integrate with other tools."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
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