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

OpenText Analytics Database (Vertica) Reviews

Vendor: OpenText
4.1 out of 5
Leave a review

What is OpenText Analytics Database (Vertica)?

OpenText Analytics Database Vertica is known for its fast data loading and efficient query processing, providing scalability and user-friendliness with a low cost per TB. It supports large data volumes with OLAP, clustering, and parallel ingestion capabilities.

Get the OpenText Analytics Database (Vertica) Buyer's Guide and find out what your peers are saying about OpenText Analytics Database (Vertica), Databricks, Teradata and more!
OpenText Analytics Database (Vertica) is the #10 ranked solution in top Data Warehouse solutions and #12 ranked solution in top Cloud Data Warehouse solutions. PeerSpot users give OpenText Analytics Database (Vertica) an average rating of 8.2 out of 10. OpenText Analytics Database (Vertica) is most commonly compared to Databricks: OpenText Analytics Database (Vertica) vs Databricks. OpenText Analytics Database (Vertica) is popular among the large enterprise segment, accounting for 51% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 17% of all views.
Buyer's Guide
OpenText Analytics Database (Vertica)
February 2026
Get the report
Helped 883,011 peers since 2012

Featured OpenText Analytics Database (Vertica) reviews

Read more reviews

OpenText Analytics Database (Vertica) mindshare

Product category:
Data Warehouse
As of March 2026, the mindshare of OpenText Analytics Database (Vertica) in the Data Warehouse category stands at 5.3%, down from 8.6% compared to the previous year, according to calculations based on PeerSpot user engagement data.
Data Warehouse Market Share Distribution
ProductMarket Share (%)
OpenText Analytics Database (Vertica)5.3%
Snowflake10.1%
Teradata9.4%
Other75.2%
Data Warehouse

PeerResearch reports based on OpenText Analytics Database (Vertica) reviews

TypeTitleDate
CategoryData WarehouseMar 1, 2026Download
ProductReviews, tips, and advice from real usersMar 1, 2026Download
ComparisonOpenText Analytics Database (Vertica) vs SnowflakeMar 1, 2026Download
ComparisonOpenText Analytics Database (Vertica) vs Oracle ExadataMar 1, 2026Download
ComparisonOpenText Analytics Database (Vertica) vs TeradataMar 1, 2026Download
Suggested products
TitleRatingMindshareRecommending
Databricks4.1N/A96%93 interviewsAdd to research
Teradata4.19.4%88%83 interviewsAdd to research
 
 
Key learnings from peers
Last updated Feb 22, 2026

Valuable Features

OpenText Analytics Database (Vertica) provides Massively Parallel Processing, columnar storage, and Eon Mode for cost-efficient performance. Users appreciate scalability, fast query processing, excellent data compression, and ease of installation. It supports parallel processing, clustering, and OLAP. The database designer aids in query optimization. Many highlight its compatibility with traditional SQL, ad hoc analysis capabilities, low total cost of ownership, and ability to handle big data with agility and speed, with no need for specialized hardware.
  • "OpenText Analytics Database (Vertica) has improved our reporting performance by nearly 90 percent, reduced ETL processing time by more than half, and saved around 70 percent in storage through compression."
  • "OpenText Analytics Database (Vertica) has impacted our organization positively because earlier we used to use Teradata, and it was very slow, creating issues with processing as well, and OpenText Analytics Database (Vertica) has helped us a lot in terms of processing capabilities and the speed of querying."
  • "OpenText Analytics Database (Vertica) has positively impacted our organization by helping us reduce storage costs and improve reporting efficiency in our fintech company."

Room for Improvement

OpenText Analytics Database (Vertica) requires improvements in hard delete support and dynamic projections. Users report the need for a cloud-based UI, enhanced workload management, better SQL optimization, and improved documentation. They view the absence of native stored procedures, limited analytics functions, and difficulties with cloud deployment as areas needing attention. Additionally, issues with performance under large data volumes, resource management, and integration with other systems have been highlighted as areas for enhancement.
  • "OpenText Analytics Database (Vertica) was originally designed as an on-premises analytic database and later moved to cloud."
  • "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."
  • "OpenText Analytics Database (Vertica) does not support hard delete, and they perform soft delete, which is the case with all columnar databases."

ROI

Organizations experienced significant ROI from OpenText Analytics Database (Vertica), mainly by saving time and money. Users highlighted benefits from automated pipelines and reduced database operation time. Some noted financial gains from cheaper storage alternatives like S3. Vertica's performance surpassed previous databases such as SQL Server, enabling analytics and real-time reporting previously unavailable. Although some entities are early in implementation, those utilizing Vertica report positive outcomes in terms of data insights and democratization.

Pricing

OpenText Analytics Database (Vertica) offers flexible pricing, typically charged per terabyte of compressed data, and allows trial through a free community edition up to 1TB. The cost is often considered high but justified by its robust features and cost-effectiveness compared to competitors. Users highlight the simplicity of the license model, advocating for negotiation, especially at fiscal year-end, to secure better deals. Additional costs like hardware and network should be considered in the setup.
  • "The solution is relatively cost-effective."
  • "It's an expensive product"
  • "Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."

Popular Use Cases

OpenText Analytics Database (Vertica) is primarily used for reporting and analytics by organizations across various industries. Companies utilize it for storing, processing, and analyzing large volumes of data in a data warehouse environment. They execute tasks such as generating reports, creating projections, and performing advanced analytics. It also supports tasks like big data ingestion, real-time processing, machine learning, and integration with cloud platforms. Vertica facilitates fast data access and supports data analysts and business users.

Service and Support

Users generally report positive interactions with OpenText Analytics Database (Vertica) customer and technical support. Many describe the teams as responsive, knowledgeable, and quick to address inquiries. Some have had direct help in complex scenarios, while others note improvement areas in response times and initial contacts. Occasionally, users find forums more helpful than official support. High ratings reflect satisfaction, though feedback varies based on individual experiences and specific encounters with support staff.

Deployment

Users found OpenText Analytics Database (Vertica)'s initial setup to be straightforward, especially with Linux expertise. Documentation is well-structured, providing step-by-step guidance. Some required consultants for optimal configuration. Earlier versions had library issues, but recent updates improved ease. Certain users found the setup slightly complex without Linux background. Performance was enhanced by consulting on configurations, and installation was efficient. Most managed successful setup quickly by following instructions closely and appreciated Vertica's ease of administration.

Scalability

OpenText Analytics Database (Vertica) demonstrates strong scalability and is praised for easy configuration when scaling. While some users faced challenges with schema modification and resource rebalancing, most have found it capable of handling large data and user loads effectively. Issues may arise if processes are not correctly followed during cluster resizing. Suggestions include starting with the right sizing and utilizing enterprise editions for optimal performance. Some users note cost concerns relative to scaling.

Stability

OpenText Analytics Database (Vertica) is highly stable. Many users report no stability issues, experiencing consistent performance even during migrations and upgrades. Some incidents involved cluster crashes due to improper queries or network glitches, requiring reconnection efforts. Sensitivity to hardware and software configurations is noted, which occasionally affects stability. Despite rare complications with clustering, it remains dependable, providing high availability and steady production performance. Stability concerns primarily arise from external configurations rather than Vertica itself.
These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.
Download our OpenText Analytics Database (Vertica) Buyer's Guide for additional reliable information.

Review data by company size

By reviewers
Company SizeCount
Small Business24
Midsize Enterprise20
Large Enterprise29
By reviewers
By visitors reading reviews
Company SizeCount
Small Business171
Midsize Enterprise78
Large Enterprise261
By visitors reading reviews

Top industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
14%
Manufacturing Company
8%
Comms Service Provider
5%
Marketing Services Firm
5%
Educational Organization
4%
Performing Arts
4%
Insurance Company
4%
Legal Firm
4%
Healthcare Company
3%
Retailer
3%
Outsourcing Company
3%
Transportation Company
3%
University
3%
Wholesaler/Distributor
2%
Real Estate/Law Firm
2%
Renewables & Environment Company
2%
Hospitality Company
2%
Media Company
2%
Logistics Company
2%
Non Profit
2%
Construction Company
1%
Recreational Facilities/Services Company
1%
Energy/Utilities Company
1%
Pharma/Biotech Company
1%
Government
1%

Compare OpenText Analytics Database (Vertica) with alternative products

Go!

Learn more about OpenText Analytics Database (Vertica)

OpenText Analytics Database Vertica is designed to handle substantial data volumes with a focus on speed and efficient storage through its columnar architecture. It offers advanced performance features like workload isolation and compression, ensuring flexibility and high availability. The database is optimized for scalable data management, supporting data scientists and analysts with real-time reporting and analytics. Its architecture is built to facilitate hybrid deployments on-premises or within cloud environments, integrating seamlessly with business intelligence tools like Tableau. However, challenges such as improved transactional capabilities, optimized delete processes, and better real-time loading need addressing.

What features define OpenText Analytics Database Vertica?
  • Fast Data Loading: Quickly ingests large data volumes.
  • Columnar Storage: Optimizes storage efficiency and speed.
  • OLAP Support: Provides robust analytics capabilities.
  • Advanced Compression: Enhances storage efficiency and performance.
  • Parallel Data Ingestion: Enables faster data processing.
  • Fault Tolerance: Ensures high availability and reliability.
What benefits should users expect?
  • Cost Efficiency: Low cost per TB is advantageous.
  • Scalability: Accommodates growing data needs seamlessly.
  • Integration Flexibility: Works well with BI tools like Tableau.
  • Real-Time Reporting: Delivers immediate insights for decision-making.

OpenText Analytics Database Vertica's implementation spans industries such as finance, healthcare, and telecommunications. It serves as a central data warehouse offering scalable management, high-speed processing, and geospatial functions. Companies benefit from its capacity to integrate machine learning and operational reporting, enhancing analytical capabilities.

OpenText Analytics Database (Vertica) was previously known as Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand.

OpenText Analytics Database (Vertica) customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.

Related questions

  • 59
Which is the best RDMBS solution for big data?
  • 10
What is the biggest difference between Amazon Redshift and Vertica
  • 60
Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
  • 31
When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
  • 15
At what point does a business typically invest in building a data warehouse?
  • 21
Is a data warehouse the best option to consolidate data into one location?
  • 166
What are the main differences between Data Lake and Data Warehouse?
  • 17
Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
  • 25
What is the best data warehouse tool?
  • 22
Which Data Strategy solution have you used?

Product Categories

Product Categories
Data Warehouse
Cloud Data Warehouse

Popular Comparisons

Popular Comparisons
Databricks vs OpenText Analytics Database (Vertica) Logo
Databricks vs OpenText Analytics Database (Vertica)
Teradata vs OpenText Analytics Database (Vertica) Logo
Teradata vs OpenText Analytics Database (Vertica)
Azure Data Factory vs OpenText Analytics Database (Vertica) Logo
Azure Data Factory vs OpenText Analytics Database (Vertica)
Snowflake vs OpenText Analytics Database (Vertica) Logo
Snowflake vs OpenText Analytics Database (Vertica)
Oracle Exadata vs OpenText Analytics Database (Vertica) Logo
Oracle Exadata vs OpenText Analytics Database (Vertica)
Dremio vs OpenText Analytics Database (Vertica) Logo
Dremio vs OpenText Analytics Database (Vertica)
VMware Tanzu Data Solutions vs OpenText Analytics Database (Vertica) Logo
VMware Tanzu Data Solutions vs OpenText Analytics Database (Vertica)
Microsoft Azure Synapse Analytics vs OpenText Analytics Database (Vertica) Logo
Microsoft Azure Synapse Analytics vs OpenText Analytics Database (Vertica)
BigQuery vs OpenText Analytics Database (Vertica) Logo
BigQuery vs OpenText Analytics Database (Vertica)
Amazon Redshift vs OpenText Analytics Database (Vertica) Logo
Amazon Redshift vs OpenText Analytics Database (Vertica)
IBM Netezza Performance Server vs OpenText Analytics Database (Vertica) Logo
IBM Netezza Performance Server vs OpenText Analytics Database (Vertica)
Oracle Autonomous Data Warehouse vs OpenText Analytics Database (Vertica) Logo
Oracle Autonomous Data Warehouse vs OpenText Analytics Database (Vertica)
Apache Hadoop vs OpenText Analytics Database (Vertica) Logo
Apache Hadoop vs OpenText Analytics Database (Vertica)
Amazon EMR vs OpenText Analytics Database (Vertica) Logo
Amazon EMR vs OpenText Analytics Database (Vertica)
SAP BW4HANA vs OpenText Analytics Database (Vertica) Logo
SAP BW4HANA vs OpenText Analytics Database (Vertica)
See all alternatives
 
OpenText Analytics Database (Vertica) Reviews Summary
Author infoRatingReview Summary
consultant at tcs4.0I use OpenText Analytics Database (Vertica) on‑prem for warehousing data from Oracle and Salesforce for Tableau/Power BI, gaining much faster reporting and ETL, strong compression and scalability, and less index maintenance. I want better cloud-native features, UI, and automation/monitoring; support is generally reliable.
Senior Software Engineer at a tech vendor with 5,001-10,000 employees3.5I used Vertica on AWS for fintech reporting; its MPP columnar design, Eon Mode with S3, compression, and fast reads cut costs and improved report speed. It’s stable and well supported, but weak for inserts/updates/deletes and hard deletes.
Data Engineering Associate Manager at a tech vendor with 10,001+ employees5.0I use Vertica for telecom data sourcing and analysis, valuing its parallel processing, ETL, multi-cloud access, speed, stability, and easy scaling, delivering strong time-savings ROI versus Teradata. I’d like a better cloud UI and more analytics features.
Deputy Manager at ICICIBANK Ltd3.5I use Vertica for various tasks like preparing data marts and analyzing transactions, appreciating its fast data retrieval speed compared to Sybase. However, it could improve by supporting more data types and enhancing competitive features.
Senior Data Engineer at a retailer with 10,001+ employees4.0Our company uses Vertica for analytics and data manipulation, benefiting from its columnar storage for quick execution. While it's fast with data copying, it lacks transactional features that I expected from systems like MySQL and Redshift. We deploy it on AWS.
Delivery director at Poslovna Inteligencija3.5We use Vertica for business analytics like IPTV and viewership analytics due to its ease of use, high performance, stability, and scalability. Improvement is needed in cloud support and installation. Previous alternatives include Netezza, Oracle, and cloud-native tools.
Support Specialis at Orion Innovation Romania3.5In my company, we use Vertica for database performance tasks like select, insert, update, and delete. Although the tool excels in performance and KPI management, its documentation needs improvement. Vertica was chosen over other options, though the specific reason is unclear.
Team Lead Solutions Architect at IMEXPERTS DO BRASIL4.5We use Vertica for our warehouse and implement machine-learning solutions like clustering or classification models. It efficiently compresses raw data using advanced Azure technologies, saving space. However, pricing could be more competitive. We haven't considered other solutions or providers.