We performed a comparison between Microsoft Parallel Data Warehouse, Teradata Cloud Data Warehouse, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."We have complete control over our data."
"It is a very stable database."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"One of the most important features is the ease of using MS SQL."
"It performs very well overall."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"It is a stable solution...It is a scalable solution."
"The most valuable feature is the ease of running queries."
"The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"The product is reliable."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"I have found the solution to be scalable."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating."
"It could be made more user-friendly for business users which would increase the user base."
"If the database is large with a lot of columns then it is difficult to clean the data."
"I think that the error messages need to be made more specific."
"The product must provide more frequent updates."
"It needs more compatibility with common BI tools."
"More tools to help designers should be included."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"It could be a bit more user-friendly."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
"The cost of Teradata Cloud Data Warehouse has room for improvement."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Suboptimal projection design causes queries to not scale linearly."
"It would be great if this were a managed service in AWS."
"I believe the installation process could be streamlined."
"I have found that coding support could be simplified."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"It needs integration with multiple clouds."
"Very bad support, I would rate it two out of 10."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
More Teradata Cloud Data Warehouse Pricing and Cost Advice →