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

Vertica offers unparalleled speed and performance, functioning as a fast columnar database that provides quick data access and processing.
Users appreciate Vertica's ability to handle large data sets efficiently, enabling advanced analytics and near real-time ingestion.
The architecture of Vertica allows it to utilize commodity hardware, offering cost-effective infrastructure without compromising on performance.
Vertica's integration capabilities with tools like Tableau help streamline data visualization and reporting processes, opening new business opportunities.
Its flexibility in projections and encoding provides excellent tools for performance tuning, ensuring optimal use of resources for large-scale data processing.

CONS

OpenText Analytics Database (Vertica) faces limitations in group by projections and lacks support for Stored Procedure, packages, and triggers.
The installation process could be streamlined, and performance of the metadata layer management requires improvement.
There are challenges in scaling for multi-node clusters, especially when node failures occur, impacting system performance.
Documentation is an area with significant shortcomings and needs improvements for comprehensive understanding.
The cost of cloud deployment and native cloud support could be made more competitive and easier to manage.
 

OpenText Analytics Database (Vertica) Pros review quotes

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_user453681 - PeerSpot reviewer
BI Manager, Vertica ASE Certified DBA at a marketing services firm with 1,001-5,000 employees
Jun 21, 2016
The fast columnar store database structure allows our query times to be at least 10x faster than on any other database.
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,259 professionals have used our research since 2012.
it_user433491 - PeerSpot reviewer
Cloud Architect, Oracle ACE, Oracle DBA at Pythian
Apr 24, 2018
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.
it_user692295 - PeerSpot reviewer
Staff Dev Lead - Analytics Data Storage at a tech services company with 1,001-5,000 employees
Jun 27, 2017
The extensibility and efficiency provided by their C++ SDK.
it_user663669 - PeerSpot reviewer
Infrastructre Manager - Senior Maintenance Manager with 10,001+ employees
Dec 12, 2017
Partition and join back to node are easy and simple for DBAs.
it_user703536 - PeerSpot reviewer
Technical Leader / Business Intelligence Consultant with 11-50 employees
Dec 24, 2017
Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data.
JS
Sr. SW Engineer - Databases with 201-500 employees
Jan 10, 2018
Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance.
it_user806967 - PeerSpot reviewer
Architect at OpenSCG
Jan 23, 2018
Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics.
AG
Director at Decision Science
Sep 8, 2023
Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.
 

OpenText Analytics Database (Vertica) Cons review quotes

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_user453681 - PeerSpot reviewer
BI Manager, Vertica ASE Certified DBA at a marketing services firm with 1,001-5,000 employees
Jun 21, 2016
Documentation has become much better, but can always use some improvement.
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,259 professionals have used our research since 2012.
it_user433491 - PeerSpot reviewer
Cloud Architect, Oracle ACE, Oracle DBA at Pythian
Apr 24, 2018
One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility.
it_user692295 - PeerSpot reviewer
Staff Dev Lead - Analytics Data Storage at a tech services company with 1,001-5,000 employees
Jun 27, 2017
Whatever's out, the core is not always as great as the engine, especially their first version.
it_user663669 - PeerSpot reviewer
Infrastructre Manager - Senior Maintenance Manager with 10,001+ employees
Dec 12, 2017
There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs.
it_user703536 - PeerSpot reviewer
Technical Leader / Business Intelligence Consultant with 11-50 employees
Dec 24, 2017
I believe the installation process could be streamlined.
JS
Sr. SW Engineer - Databases with 201-500 employees
Jan 10, 2018
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.
it_user806967 - PeerSpot reviewer
Architect at OpenSCG
Jan 23, 2018
It should provide a GUI interface for data management and tuning.
AG
Director at Decision Science
Sep 8, 2023
Support is an area where it could get better.