We performed a comparison between IBM Db2 Warehouse on Cloud and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It will be MPP, so performance should improve."
"The performance is okay as long as the volume of queries is not too high."
"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"The most valuable feature of Vertica is the unmatchable database 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."
"Allows us to take volumes and process them at a very high speed."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Partition and join back to node are easy and simple for DBAs."
"Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"The integration of this solution with ODI could be improved."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Suboptimal projection design causes queries to not scale linearly."
"It needs integration with multiple clouds."
"Very bad support, I would rate it two out of 10."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. IBM Db2 Warehouse on Cloud is rated 7.6, while Vertica is rated 8.2. The top reviewer of IBM Db2 Warehouse on Cloud writes "The "prefetch" feature anticipates needed data and keeps it available. BLU acceleration determines what data is unqualified for analysis and skips it". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". IBM Db2 Warehouse on Cloud is most compared with IBM Db2 Warehouse, Amazon Redshift, IBM Netezza Performance Server, Microsoft Azure Synapse Analytics and Snowflake, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our IBM Db2 Warehouse on Cloud vs. Vertica report.
See our list of best Cloud Data Warehouse vendors and best Data Warehouse vendors.
We monitor all Cloud 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.