We performed a comparison between Vertica and VMware Tanzu Data Services based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature is Vertica's performance and the ease of using the database."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"The performance is very good and the aggregate records are fast."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"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."
"Partition and join back to node are easy and simple for DBAs."
"Very sophisticated routing control and priority messaging capabilities"
"The security is great."
"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."
"RabbitMQ will help to remove a lot of the complexities and create a loosely coupled codebase."
"Pivotal Greenplum's shared-nothing architecture."
"The product has been stable and I have never faced any kind of problems with it."
"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."
"Large amounts of data can be moved pretty fast using the solution."
"The geospatial functionality could be designed better."
"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."
"The integration of this solution with ODI could be improved."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"Limitations in group by projections is where I would like to see an improvement."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"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."
"We would like to see Greenplum maintain a closer relationship with and parity to features implemented in PostgreSQL."
"It will be very useful if we could communicate with other database types from Greenplum (using a database link)."
"VMware RabbitMQ needs to create a new queue system."
"The solution needs improvement on performance."
"If you have a user consuming a huge load of resources, it takes down the entire system."
"If you're outside IP address range, the clustering no longer has all the features which is problematic."
"Initial setup is a little complex. It took around two weeks to deploy."
Vertica is ranked 4th in Data Warehouse with 83 reviews while VMware Tanzu Data Services is ranked 6th in Data Warehouse with 81 reviews. Vertica is rated 8.2, while VMware Tanzu Data Services is rated 8.0. The top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". On the other hand, the top reviewer of VMware Tanzu Data Services writes "Reliable queueing functionality and versatile tool that can be used with any programming languages ". Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and MySQL, whereas VMware Tanzu Data Services is most compared with IBM MQ, Anypoint MQ, Apache Kafka, Red Hat AMQ and Amazon MQ. See our VMware Tanzu Data Services vs. Vertica report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.