Try our new research platform with insights from 80,000+ expert users
OpenText Analytics Database (Vertica) Logo

OpenText Analytics Database (Vertica) pros and cons

Vendor: OpenText
4.1 out of 5

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

OpenText Analytics Database (Vertica) significantly enhances organizational decision-making through its key insights and reporting efficiency.
It reduces storage costs and improves reporting performance by nearly 90%, making it a valuable asset for fintech companies.
Its columnar database structure allows queries to run at least 10x faster than other databases, aiding in real-time integrations and API performance.
OpenText Analytics Database (Vertica) compresses data efficiently, reducing storage by around 70% and optimizing cloud economics with features like Eon Mode.
The architecture efficiently handles large data aggregations, isolating workloads and offering high-speed performance without the need for special hardware.

CONS

OpenText Analytics Database (Vertica) lacks features like hard delete, stored procedures, packages, and triggers, commonly found in other RDBMs.
They have very bad support according to user reviews, with ratings as low as two out of 10.
The management of the metadata layer and installation process could benefit from improvements.
OpenText Analytics Database (Vertica) struggles with performance, particularly when reaching maximum storage capacity and with large data volumes.
The cloud deployment of OpenText Analytics Database (Vertica) is costly, and the integration of the software with multiple clouds requires enhancement.
 

OpenText Analytics Database (Vertica) Pros review quotes

it_user4518 - PeerSpot reviewer
Head of Databases at a retailer with 501-1,000 employees
Feb 25, 2013
We are using Vertica because it is a fast and reliable data warehousing tool and provides us a very good data compression ratio.
it_user110262 - PeerSpot reviewer
Architect with 501-1,000 employees
Mar 31, 2016
It provides very fast query performance after good designs of projections.
it_user411165 - PeerSpot reviewer
Big Data, Analytics and Hadoop Expert, Vertica DBA (Technical Leader), Architecture Group at a tech vendor with 5,001-10,000 employees
Apr 4, 2016
HP Vertica is an outstanding backend for Big Data-scale interactive dashboards/BI.
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
884,873 professionals have used our research since 2012.
it_user417525 - PeerSpot reviewer
Software Engineer at a marketing services firm with 51-200 employees
Mar 4, 2016
This product has enabled us to keep very large amounts of data at hand for fast querying.
it_user418314 - PeerSpot reviewer
Associate at a tech services company with 501-1,000 employees
Sep 14, 2016
The biggest, most valuable feature for us is the clustering aspect with a share-nothing mentality.
it_user427470 - PeerSpot reviewer
Technical Team Lead, Business Intelligence at a tech company with 501-1,000 employees
Apr 19, 2016
The most valuable feature is the merge function, which is essentially the upsert function, and it has become our ELT pattern because, unlike when we used the ETL tool to manage upserts, the load time is now pretty much flat relative to the volume of records processed.
it_user428343 - PeerSpot reviewer
Managing Partner at Thorium Data Science
Jul 20, 2017
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.
it_user431877 - PeerSpot reviewer
Consultant at a tech services company with 10,001+ employees
Apr 26, 2016
I like the projection feature, which increases query performance.
it_user102651 - PeerSpot reviewer
Lead Software Engineer - Theatrical Global at a marketing services firm with 1,001-5,000 employees
Jun 19, 2016
With the addition of Vertica to handle big data queries, these reports are now returned in under 15 seconds.
it_user464571 - PeerSpot reviewer
Senior Data Warehouse Architect at a media company
Jun 20, 2016
I would name HPE Vertica as the most mature columnar database with a best of class data storage and query engine.
 

OpenText Analytics Database (Vertica) Cons review quotes

it_user4518 - PeerSpot reviewer
Head of Databases at a retailer with 501-1,000 employees
Feb 25, 2013
We can’t use Vertica as a transactional database because it is unable to handle lot of transactions.
it_user110262 - PeerSpot reviewer
Architect with 501-1,000 employees
Mar 31, 2016
Stability is good, however the database crashed once because a query ran against a large XML data element.
it_user411165 - PeerSpot reviewer
Big Data, Analytics and Hadoop Expert, Vertica DBA (Technical Leader), Architecture Group at a tech vendor with 5,001-10,000 employees
Apr 4, 2016
I really would like to see Vertica able to use heterogeneous storage (RAM, SSD, HDD). Another issue I have seen is that the SQL optimizer fails to make optimizations that competing products are able to do.
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
884,873 professionals have used our research since 2012.
it_user417525 - PeerSpot reviewer
Software Engineer at a marketing services firm with 51-200 employees
Mar 4, 2016
We have found multiple issues with deployment. Deployment was by far the hardest step in the process.
it_user418314 - PeerSpot reviewer
Associate at a tech services company with 501-1,000 employees
Sep 14, 2016
Like everything else HP has support for, the support is very poor.
it_user427470 - PeerSpot reviewer
Technical Team Lead, Business Intelligence at a tech company with 501-1,000 employees
Apr 19, 2016
I'd rate technical support as low to average. The tech support provides the usual canned response.
it_user428343 - PeerSpot reviewer
Managing Partner at Thorium Data Science
Jul 20, 2017
I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support.
it_user431877 - PeerSpot reviewer
Consultant at a tech services company with 10,001+ employees
Apr 26, 2016
Limitations in group by projections is where I would like to see an improvement.
it_user102651 - PeerSpot reviewer
Lead Software Engineer - Theatrical Global at a marketing services firm with 1,001-5,000 employees
Jun 19, 2016
Stability, scalability (3 node Community Edition) and backup/restore all need to be worked on.
it_user464571 - PeerSpot reviewer
Senior Data Warehouse Architect at a media company
Jun 20, 2016
I would love to see direct connections to other DMSs.