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."It is a very stable database."
"It handles high volumes of data very well."
"We have complete control over our data."
"Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity or ease of use when getting a resource and knowing everything about it."
"One of the most important features is the ease of using MS SQL."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"It is not a pricey product compared to other data warehouse solutions."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"Compression is a great feature, where one can really save a lot of storage."
"The ease of setup is an eight out of ten."
"The business intelligence is very good."
"We have used this solution for a long period of time so it has become easy for us to query any kind of data from Oracle Exadata which has been valuable."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"Oracle Exadata's performance is one of its best features. We very satisfied with it."
"Oracle has reliable solutions and this one is no different."
"Complete management occurs from one single address instead of different servers."
"It is a solid database a lot of different tools to move data."
"The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"It's very mature from a technology perspective."
"It is a stable program."
"The performance is great, we are able to query our data in one operation."
"The initial setup was straightforward."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced."
"More tools to help designers should be included."
"We find the cost of the solution to be a little high."
"If the database is large with a lot of columns then it is difficult to clean the data."
"It could offer more development across the solution."
"This solution would be improved with an option for in-memory data analysis."
"They need to incorporate a machine learning engine."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"I liked Spark, but it was discontinued when Exadata L6 came back. I loved it, and I wish they would bring back Spark integration."
"We need a monitoring tool which can in one place, where we can manage, monitor the entire Exadata components."
"The setup is a little bit complex. We would like to see the installation part get easier."
"One small area for improvement in Oracle Exadata is integration, particularly at the consolidated application level."
"The management monitoring tools are quite important and an area that needs some improvement."
"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."
"It's too expensive per terabyte. It's complex."
"The technical support is in need of improvement."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"Needs compatibility with more Big Data platforms."
"Limited interest and success in some areas make us hesitate about upgrading."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"The scalability could be better. The on-premises solution is always more complicated to scale."
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