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."The most valuable feature is the business intelligence (BI) part of it."
"The most valuable feature for me is querying."
"The solution's integration is good."
"It is not a pricey product compared to other data warehouse solutions."
"I am very satisfied with the customer service/technical support."
"One of the most important features is the ease of using MS SQL."
"The data transmissions between the data models is the most valuable feature."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"The solution has a powerful aggregating feature"
"You can create your own rules that include mathematic calculations."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"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. "
"It has improved my organization's functionality and performance."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"I enjoy the cybersecurity and backup features."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The product does not have all of the features that the native products have."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"I would like the tool to support different operating systems."
"It could be made more user-friendly for business users which would increase the user base."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"The reporting for certain types of data needs to be improved."
"SQL installation is pretty tricky. The scalability and customer support also should be improved."
"I would like to see better visualization features."
"Improvements need to be made on the load balancing side."
"The solution's setup could be quicker and easier."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Support is an area where it could get better."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"The biggest problem is the cost of cloud deployment."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →