We performed a comparison between Microsoft Parallel Data Warehouse, Vertica, and VMware Tanzu Greenplum based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"It is not a pricey product compared to other data warehouse solutions."
"It handles high volumes of data very well."
"The solution has been reliable."
"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."
"The solution's integration is good."
"The data transmissions between the data models is the most valuable feature."
"I am very satisfied with the customer service/technical support."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"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."
"Speed and resiliency are probably the best parts of this product."
"Its projections and encoding are excellent tools for tuning large volumes."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Helps us to achieve large-scale analytics."
"Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible."
"A very good, open-source platform."
"With VMware Tanzu Greenplum, one can make a huge database table and analyze the queries by adding in the SQL command. Some hint or command for the query goes over the multi-parallel execution."
"Tanzu Greenplum's most valuable features include the integration of modern data science approaches across an MPP platform."
"We chose Greenplum because of the architecture in terms of clustering databases and being able to have, or at least utilize the resources that are sitting on a database."
"The most valuable feature for us is horizontal scaling."
"It works very well with large database queries."
"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."
"The product does not have all of the features that the native products have."
"The query is slow if we don't optimize it."
"More tools to help designers should be included."
"This solution would be improved with an option for in-memory data analysis."
"They need to incorporate a machine learning engine."
"I would like the ability to do more real-time type updates instead of batch-oriented updates."
"The biggest problem is the cost of cloud deployment."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"The geospatial functionality could be designed better."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"The integration with AI has room for improvement."
"They should add more analytics. Their documentation could also be improved so that I don't have to bother my co-workers and tech support so often."
"Tanzu Greenplum's compression for GPText could be made more efficient."
"It will be very useful if we could communicate with other database types from Greenplum (using a database link)."
"The initial setup is somewhat complex and the out-of-the-box configuration requires optimization."
"One of the disadvantages, not a disadvantage with the product itself, but overall, is the expertise in the marketplace. It's not easy to find a Greenplum administrator in the market, compared to other products such as Oracle."
"VMware Tanzu Greenplum needs improvement in the memory area and improved methods for quick access to the disc. So, one of the quick goals of Greenplum must work on enhancing access to the disc by adding hints in the database."
"Implementation takes a long time."
"Extra filters would be helpful."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →