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."The performance is okay as long as the volume of queries is not too high."
"It will be MPP, so performance should improve."
"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"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."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"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."
"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 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."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"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."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"The biggest problem is the cost of cloud deployment."
"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."
"It should provide a GUI interface for data management and tuning."
"The integration of this solution with ODI could be improved."
"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."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Documentation has become much better, but can always use some improvement."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
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 Amazon Redshift, IBM Db2 Warehouse, 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.