We performed a comparison between Microsoft Parallel Data Warehouse, TIBCO Live Datamart, 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."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 have complete control over our data."
"It is a stable solution...It is a scalable solution."
"I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets."
"It handles high volumes of data very well."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"The data transmissions between the data models is the most valuable feature."
"The solution has a powerful aggregating feature"
"You can create your own rules that include mathematic calculations."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"Allows us to take volumes and process them at a very high speed."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"It has improved my organization's functionality and performance."
"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 most valuable feature is Vertica's performance and the ease of using the database."
"If the database is large with a lot of columns then it is difficult to clean the data."
"The solution is expensive and has room for improvement."
"I think that the error messages need to be made more specific."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"More tools to help designers should be included."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"The product does not have all of the features that the native products have."
"The solution's setup could be quicker and easier."
"Improvements need to be made on the load balancing side."
"It would be great if this were a managed service in AWS."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"Very bad support, I would rate it two out of 10."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"We faced some challenges when trying to use the temporary tables feature."
"I believe the installation process could be streamlined."
"They could improve on customer service."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →