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

OpenText Analytics Database (Vertica) vs Oracle Database 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
6.2
Organizations achieved financial and operational gains with Vertica, reducing costs and processing time while enhancing analytics and performance.
Sentiment score
5.7
Oracle Database is costly but offers long-term ROI, stability, and scalability, especially beneficial for financial institutions and large tasks.
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
It saved a lot of money and time because of the debugging peculiarities and also using Toad for Oracle software to optimize the coding and performance of data migration.
Qhse Manager at a outsourcing company with 10,001+ employees
 

Customer Service

Sentiment score
7.1
OpenText Analytics Database's customer service is generally valued for expertise but has occasional response time and escalation issues.
Sentiment score
6.1
Oracle Database users experience mixed reviews on support, praising responsiveness but criticizing delays, costs, and inconsistent service quality.
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
In some cases, they support me on a 24/7 basis, round the clock.
Senior Vice President IT Operations at ZTBL
Oracle support can improve both response time and quality, including not only response time but also the turnaround time for issue fixing, understanding the issue, routing it to the correct team, and debugging for resolution.
DB A Competency Manager at a computer software company with 201-500 employees
The customer support of Oracle Database is excellent and provides detailed assistance.
Qhse Manager at a outsourcing company with 10,001+ employees
 

Scalability Issues

Sentiment score
7.2
OpenText Vertica offers scalable, efficient data handling with robust performance, though pricing and node addition may challenge some users.
Sentiment score
7.4
Oracle Database offers scalable solutions for enterprises, supporting seamless growth with advanced features, though licensing costs may impact scalability.
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
The database regularly releases new versions with better performance and security features.
Chief Executive Officer at LeaseWeb
RAC is the feature where I can distribute the load among multiple nodes, and it has helped our enterprise applications.
Senior Vice President IT Operations at ZTBL
 

Stability Issues

Sentiment score
7.2
OpenText Analytics Database offers high stability and performance, with successful migrations and minimal clustering issues ensuring user satisfaction.
Sentiment score
8.0
Oracle Database is renowned for its exceptional stability and reliability, effectively handling extensive workloads with minimal issues.
OpenText Analytics Database (Vertica) is very stable.
Senior Software Engineer at a tech vendor with 5,001-10,000 employees
Oracle Database is very robust, and I rate its stability nine out of ten.
Chief Executive Officer at LeaseWeb
I would rate stability for Oracle Database as a 10.
DB A Competency Manager at a computer software company with 201-500 employees
Oracle is really one of the biggest database software companies in the world.
Qhse Manager at a outsourcing company with 10,001+ employees
 

Room For Improvement

OpenText Analytics Database needs improvements in community, cloud features, SQL, integration, cost efficiency, machine learning, and developer tools.
Oracle Database struggles with high costs, complex licensing, outdated interfaces, and inadequate support, demanding better cloud compatibility and security.
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
Having that visibility of all the software products and providing free training and documentation on how you can improve and which products are best suited for integration to your product from Oracle would go a long way to help organizations and professionals.
Qhse Manager at a outsourcing company with 10,001+ employees
Oracle Database needs improvement in data analytics capabilities, AI involvement, machine learning, and deep learning.
Chief Executive Officer at LeaseWeb
One existing feature that distinguishes Oracle Database from others is its ability to log errors in the database itself.
Business Analyst at Tata Consultancy
 

Setup Cost

OpenText Analytics Database offers flexible pricing, often cost-effective for its advanced features, despite being pricey vs. open-source solutions.
Oracle Database's high pricing and complex licensing deter SMBs, despite quality features and available budget-friendly options.
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
For medium businesses, Oracle and IBM DB2 pricing are quite similar.
Chief Executive Officer at LeaseWeb
Oracle Database is costly.
Senior Vice President IT Operations at ZTBL
 

Valuable Features

OpenText Analytics Database excels in fast query responses, scalability, and real-time insights, enhancing decision-making and operational efficiency.
Oracle Database is preferred for its reliability, robust security, scalability, high availability, and ability to efficiently manage large datasets.
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
Its data management capabilities include data quality, data integration, data architecture, modeling, and data security, which are very important for data-driven companies.
Chief Executive Officer at LeaseWeb
Regarding what I value about Oracle Database, as far as execution is concerned, I think it is one of the best databases I have come across.
Business Analyst at Tata Consultancy
The most valuable features in WebLogic Suite are its stability and security.
Senior Vice President IT Operations at ZTBL
 

Categories and Ranking

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)
Oracle Database
Average Rating
8.6
Reviews Sentiment
7.3
Number of Reviews
294
Ranking in other categories
Relational Databases Tools (2nd), Database Management Systems (DBMS) (2nd)
 

Mindshare comparison

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

Featured Reviews

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.
Philemon Olusegun - PeerSpot reviewer
Qhse Manager at a outsourcing company with 10,001+ employees
Reliable backups and high-capacity data management have transformed large-scale census projects
When it comes to how Oracle Database can be improved, for me it is all about training and development in terms of gamification, creating awareness, and spreading the word to aspiring database administrators and database developers. As I have used it in the past and in recent times, many people are trying to get into IT, so the opportunity exists. Oracle has the market opportunity to take this time to spread its offerings and ensure that many aspiring professionals are aware of its services and products. From my perspective, there is not much to add regarding the needed improvements for the interface and the documentation. I give it a nine because I think Oracle sometimes can make things complicated. You have many services, many products, and many tools for different use cases. So it is difficult for someone who is only used to a particular product, such as Oracle Database, to understand all the other products and services that it provides. Probably streamlining it and making it available with categorized use cases for specific job roles would help. If you are a database developer, these are the tools that you need to be familiar with in Oracle's suite of products, and if you are a database administrator, these are the tools. Categorizing them based on the job role or function of people who are accessing these products and providing training capabilities on how to use them and how these products interchange and talk to each other would be very important because that is one of the things I struggled with when I started my journey as an Oracle Database administrator. Having that visibility of all the software products and providing free training and documentation on how you can improve and which products are best suited for integration to your product from Oracle would go a long way to help organizations and professionals. Regarding Oracle Database's AI capabilities, I am very keen on its governance and security. I think more work needs to be done on the security and ensuring that the database for a large number of people is watertight. AI is here to stay; however, governance and more stress testing of the AI capabilities needs to be done to ensure there is no breach of data. I would rate it currently at 6 over 10 and there is room for improvement. As long as there are government policies and Oracle policies that can mitigate any breaches of data and serious security issues, releasing people's records over the internet, there is always room for improvement in that regard.
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
904,899 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
9%
Manufacturing Company
8%
Outsourcing Company
7%
Financial Services Firm
12%
Construction Company
12%
Outsourcing Company
10%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise43
By reviewers
Company SizeCount
Small Business87
Midsize Enterprise66
Large Enterprise180
 

Questions from the Community

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...
How do you run Oracle Database at your organization and why?
My company has been using Oracle Exadata Database Service for some years now, and we are happy with it. I will allow myself to answer your questions about why and what benefits it provides us with ...
Do you know of any disadvantages of Oracle Database?
Undoubtedly, Oracle Database is a top product in its category. But it does have its disadvantages, and for me and my organization, that has been the limitations of the product. When it comes to Ora...
What is the best use for Oracle Database?
Oracle Database is flexible and can be used for many things. My company's main use case for this product is for storing data. We benefit from its high level of security as well as from the fact tha...
 

Also Known As

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Oracle 12c, RDBMS
 

Overview

 

Sample Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Agncia Nacional de guas, Anbima, Aria Systems, Asiana Airlines, Astelit LLC, Australian Finance Group, Banco Occidental de Descuento, Bharat Petroleum Corporation Limited, BT, Caja de Seguros S.A., Casas GEO S.A.B. de C.V., Comic Relief UK, Corsair Components Inc., CSAM Health AS, CSOB Group, Datacraft Solutions, DenizBank A.S., Department of Treasury and Finance WA, Office of State Revenue, Deutsche B_rse AG, Deutsche Lufthansa AG, Deutsche Messe AG, Digicel Haiti, DPR COSEA, Essar Group, Essatto Software Pty Ltd, Farmšcia e Drogaria Nissei Ltda., Fomento Econ‹mico Mexicano S.A.B. de C.V. (FEMSA), FundaÊo Petrobras de Seguridade Social, Future Group, GFKL Financial Services AG, Grupo Posadas S.A.B. de C.V., Grupo Sinosserra, Guerra S.A. Implementos Rodovišrios, Hanatour International Service, Hays plc, Henan Mobile Co. Ltd, Hochschule Hof, Hong Kong and China Technology (Wuhan) Co. Ltd (Towngas Technology), Industries Corpa_al C.A., Infrastructure Development Finance Company Limited, Instituto Brasileiro de Geografia e Estatstica, Instituto Mexicano de la Propiedad Industrial, Kcell, LinkShare Corporation, MercadoLibre Inc., MetLife Inc., Nextgen Distribution, €BB-IKT GmbH, Octagon Research Solutions, Pacific Lutheran University, Paragon Data GmbH, Ping ltd., PJSC Trustbank, Prodaub _ Processamento de Dados de Uberl_ndia, Purdue University, Redknee Inc., Robi Axiata Limited, Shanghai Infoservice Technology Co. Ltd, Shanghai Sihua Technologies Co. Ltd, Sistema de Aguas de la Ciudad de M_xico, Solihull Metropolitan Borough Council, Suddenlink Communications, Suprajit Engineering Limited, Tallink Grupp, Terminales Ro de la Plata S.A., Therap Services LLC, Think Passenger Inc., Trafigura, Transmed S.A.L Lebanon, ValeShop, VelQuest Corporation, Vodafone Group plc, West Virginia Network, WIND Hellas Telecommunications S.A
Find out what your peers are saying about Snowflake Computing, Teradata, Oracle and others in Data Warehouse. Updated: July 2026.
904,899 professionals have used our research since 2012.