No more typing reviews! Try our Samantha, our new voice AI agent.

IBM Db2 Database vs OpenText Analytics Database (Vertica) comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

ROI

Sentiment score
5.8
IBM Db2 Database provides substantial ROI, enhancing efficiency and financial benefits for organizations through seamless project implementation and strong performance.
Sentiment score
6.2
Organizations achieved financial and operational gains with Vertica, reducing costs and processing time while enhancing analytics and performance.
I saved a lot of money because the storage was on a cheaper alternative and was not directly on OpenText Analytics Database (Vertica), but on S3.
Senior Software Engineer at a tech vendor with 5,001-10,000 employees
The time we used to take with our earlier databases has reduced to one-tenth of what was there earlier, which is a positive outcome that can be converted to financial metrics in terms of return on investment.
Data Engineering Associate Manager at a tech vendor with 10,001+ employees
 

Customer Service

Sentiment score
6.4
IBM Db2 Database support is praised for expertise but faces mixed reviews due to regional disparities and documentation issues.
Sentiment score
7.1
OpenText Analytics Database's customer service is generally valued for expertise but has occasional response time and escalation issues.
We normally receive substantial discounts on the price.
Associate Director, Data Architecture at a financial services firm with 10,001+ employees
The reason for limitations in customer service is that the technical skills available in the market for IBM Db2 Database are limited compared to those of Oracle.
Founder, Director at perfTech Solutions Pvt Ltd
Throughout this process, customer support was outstanding, and we had a person actively supporting us from the OpenText Analytics Database (Vertica) team for our use case.
Senior Software Engineer at a tech vendor with 5,001-10,000 employees
Overall, our experience with OpenText Analytics Database (Vertica) customer support has been good and reliable.
consultant at tcs
 

Scalability Issues

Sentiment score
7.2
IBM Db2 is recognized for robust scalability, handling large users and transactions, but cost and Oracle's scalability are considerations.
Sentiment score
7.2
OpenText Vertica offers scalable, efficient data handling with robust performance, though pricing and node addition may challenge some users.
It can be scaled vertically or horizontally so that data insertions and data access are much faster and more secure compared to how Oracle or other databases work.
Founder, Director at perfTech Solutions Pvt Ltd
We have experienced easy horizontal scaling, consistent query performance as data grew, and the ability to handle large analytic workloads.
consultant at tcs
OpenText Analytics Database (Vertica) has very good scalability.
Data Engineering Associate Manager at a tech vendor with 10,001+ employees
OpenText Analytics Database (Vertica) can scale to a great extent.
Analytics Manager at a wholesaler/distributor with 10,001+ employees
 

Stability Issues

Sentiment score
7.8
IBM Db2 Database is highly reliable and stable, especially in banking, with minimal issues even after installation or data growth.
Sentiment score
7.2
OpenText Analytics Database offers high stability and performance, with successful migrations and minimal clustering issues ensuring user satisfaction.
OpenText Analytics Database (Vertica) is very stable.
Senior Software Engineer at a tech vendor with 5,001-10,000 employees
 

Room For Improvement

IBM Db2 requires improved interfaces, integration, and performance, with focus on scalability, usability, security, and cost-effective solutions.
OpenText Analytics Database needs improvements in community, cloud features, SQL, integration, cost efficiency, machine learning, and developer tools.
Understanding the basic structure of the database, how logs or log shipping happens, how clustering works, how logs are written, where all information is stored, and how it needs to be taken care of are all critical pieces of information.
Founder, Director at perfTech Solutions Pvt Ltd
It might be slightly slower than other database vendors, but it works well since banks typically do not move quickly with leading-edge technology.
Associate Director, Data Architecture at a financial services firm with 10,001+ employees
Smarter automatic projection management is needed with more intelligence, auto projection creation, automatic optimization, and reduced manual testing with better workload management.
consultant at tcs
Projections could be made more dynamic, and if they could find a faster way to update, insert, and delete data, that would also be helpful.
Senior Software Engineer at a tech vendor with 5,001-10,000 employees
OpenText Analytics Database (Vertica) does not have a cloud-based UI that Snowflake has, which features a very good comprehensive GUI for querying and analyzing data.
Data Engineering Associate Manager at a tech vendor with 10,001+ employees
 

Setup Cost

IBM Db2 pricing is seen as costly and complex, but offers value when bundled with other IBM products.
OpenText Analytics Database offers flexible pricing, often cost-effective for its advanced features, despite being pricey vs. open-source solutions.
The pricing for OpenText Analytics Database (Vertica) is somewhat on the higher side for the license.
Senior Software Engineer at a tech vendor with 5,001-10,000 employees
 

Valuable Features

IBM Db2 Database offers powerful SQL, robust security, high performance, scalability, user-friendly interface, and compatibility with IBM products.
OpenText Analytics Database excels in fast query responses, scalability, and real-time insights, enhancing decision-making and operational efficiency.
All compliance-related aspects have been taken care of from the database point of view, including database encryption and security-related features.
Founder, Director at perfTech Solutions Pvt Ltd
IBM Db2 Database, because of enterprise performance and support, is why banks still maintain their relationship with it.
Associate Director, Data Architecture at a financial services firm with 10,001+ employees
The IBM Db2 Database is trusted, and IT effort is less than any other product.
Network Administrator at GAEB
I can use it in Eon Mode in which I can store the data in cheaper storage such as Amazon S3 and have different compute nodes.
Senior Software Engineer at a tech vendor with 5,001-10,000 employees
Projection and columnar storage are the most valuable features because they dramatically improve query performance and reduce the need for index management.
consultant at tcs
The best features that OpenText Analytics Database (Vertica) offers are mainly the parallel processing, ETL capabilities, and the multi-cloud features which are very handy to use.
Data Engineering Associate Manager at a tech vendor with 10,001+ employees
 

Categories and Ranking

IBM Db2 Database
Average Rating
8.2
Reviews Sentiment
6.6
Number of Reviews
76
Ranking in other categories
Relational Databases Tools (7th)
OpenText Analytics Database...
Average Rating
8.2
Reviews Sentiment
6.9
Number of Reviews
90
Ranking in other categories
Data Warehouse (5th), Cloud Data Warehouse (11th)
 

Mindshare comparison

IBM Db2 Database and OpenText Analytics Database (Vertica) aren’t in the same category and serve different purposes. IBM Db2 Database is designed for Relational Databases Tools and holds a mindshare of 6.6%, down 7.1% compared to last year.
OpenText Analytics Database (Vertica), on the other hand, focuses on Data Warehouse, holds 5.8% mindshare, down 7.8% since last year.
Relational Databases Tools Mindshare Distribution
ProductMindshare (%)
IBM Db2 Database6.6%
SQL Server10.6%
Oracle Database10.5%
Other72.3%
Relational Databases Tools
Data Warehouse Mindshare Distribution
ProductMindshare (%)
OpenText Analytics Database (Vertica)5.8%
Snowflake9.3%
Teradata8.7%
Other76.2%
Data Warehouse
 

Featured Reviews

Sathyan K - PeerSpot reviewer
Founder, Director at perfTech Solutions Pvt Ltd
Database has secured high-volume transactions and supports fast, compliant workflow processing
Sterling B2B Integrator is a highly transactional-oriented application, which can be described as an OLTP application. Any data that flows through the application is stored in the database for each step that it performs. IBM Db2 Database helps the application work much faster from an OLTP perspective. IBM Db2 Database is SSL enabled, which means that from the security point of view, any access to the database is through SSL. Additionally, all compliance-related aspects have been taken care of from the database point of view, including database encryption and security-related features. It is highly scalable, and its performance related to database pruning is very good. It can be scaled vertically or horizontally so that data insertions and data access are much faster and more secure compared to how Oracle or other databases work.
JN
consultant at tcs
Data warehousing has transformed reporting performance and now delivers near real-time insights
OpenText Analytics Database (Vertica) is a very powerful analytic database, but like any platform, there are areas where it can improve to make daily work even smoother. Better cloud-native experience is one area for improvement. OpenText Analytics Database (Vertica) was originally designed as an on-premises analytic database and later moved to cloud. Improvement opportunities include more seamless cloud-native features such as auto-scaling, serverless options, and easier cluster management. Competitors such as Snowflake and BigQuery provide more fully managed experiences. Easier UI is another area for improvement. Most administration is currently done by SQL and command line tools. An improvement opportunity would be a more modern web UI for monitoring, workload management, and troubleshooting. Faster ecosystem and community growth is needed. In short, OpenText Analytics Database (Vertica) could improve in areas such as cloud-native capability, modern UI for administration, stronger real-time streaming integration, and growing its ecosystem and community. These enhancements would make it easier to manage and adopt compared to newer cloud-first analytic platforms. From a day-to-day operational perspective, there are a few areas where OpenText Analytics Database (Vertica) could improve to make our work smoother. Smarter automatic projection management is needed with more intelligence, auto projection creation, automatic optimization, and reduced manual testing with better workload management. Right now, monitoring queries often requires system tables and manual analysis. Troubleshooting slow queries takes time. A modern real-time dashboard showing query bottlenecks and resource users would enable quick detection. The impact could be faster issue resolution and less time spent debugging performance. Storage native interaction with modern data tools is also important. In short, from a day-to-day perspective, improvements in automatic projection optimization, better workload monitoring dashboard, easier schema evolution, and stronger modern tool integration would significantly reduce manual tuning effort and improve developer productivity. While OpenText Analytics Database (Vertica) is very powerful, these enhancements would make it more efficient for the analytics team.
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
900,196 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
9%
Government
8%
Construction Company
6%
Financial Services Firm
17%
Computer Software Company
10%
Manufacturing Company
9%
Comms Service Provider
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business21
Midsize Enterprise13
Large Enterprise48
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise43
 

Questions from the Community

What is your experience regarding pricing and costs for IBM Db2 Database?
IBM Db2 is an expensive solution. While I am not heavily involved with pricing, additional companies provide capabilities or products like those from BMC, which many installations might also purchase.
What needs improvement with IBM Db2 Database?
A potential area of improvement is better documentation. From an educational perspective, it is difficult for people to understand IBM Db2 Database much faster compared to databases such as Oracle ...
What is your primary use case for IBM Db2 Database?
We use IBM Db2 Database for B2B Integrator, specifically Sterling B2B Integrator, which requires a database to store all configuration details. Any workflow that is created, any configuration messa...
What is your experience regarding pricing and costs for Vertica?
My experience with pricing, setup cost, and licensing is limited because the organization handled the licensing and pricing as well as the cost setup.
What needs improvement with Vertica?
OpenText Analytics Database (Vertica) is already doing great. There could be a community which could have been much more advanced and more people can be engaged so that any kind of questions, queri...
What is your primary use case for Vertica?
The main use case for OpenText Analytics Database (Vertica) is that we have the Hive and a Hadoop layer for data availability, and Vertica serves as a big data solution. Within a Hive table, OpenTe...
 

Also Known As

DB2
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of Toronto
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: May 2026.
900,196 professionals have used our research since 2012.