

Teradata and OpenText Analytics Database (Vertica) compete in the data analytics platform category. Teradata seems to have the upper hand due to its feature-rich environment, enhancing performance and scalability effectively.
Features: Teradata offers an MPP platform, Teradata Optimizer, and QueryGrid for effective data migration, ensuring speedy query execution. OpenText Vertica is notable for its fast query responses, columnar storage, and projections, optimizing complex analytics.
Room for Improvement: Teradata faces challenges in cloud adoption and high pricing, with suggestions for enhanced transactional capabilities and cloud integration. OpenText Vertica requires improvements in transaction handling, workload management, and documentation.
Ease of Deployment and Customer Service: Teradata provides flexible deployment on-premises and in the cloud, though cloud environments can be complex. Customer service reviews are mixed. OpenText Vertica offers a straightforward license model, praised for hybrid and cloud-hosted deployments and satisfactory technical support.
Pricing and ROI: Teradata is considered pricey, yet offers a valuable ROI with its analytics capabilities. OpenText Vertica is appreciated for its cost-effectiveness, with pricing based on data size, offering substantial cost benefits for handling large-scale data analytics.
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.
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.
At least fifteen to twenty percent of our time has been saved using Teradata, which has positively affected team productivity and business outcomes.
Independent research showed that Teradata VantageCloud users achieved an average ROI of 427% across three years with payback under a year, demonstrating the platform's ability to deliver a strong financial return.
We have realized a return on investment, with a reduction of staff from 27 to eight, and our current return on investment is approximately 14%.
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.
The customer support for Teradata has been great.
They are responsive and knowledgeable, and the documentation is very helpful.
Customer support is very good, rated eight out of ten under our essential agreement.
OpenText Analytics Database (Vertica) has very good scalability.
The scalability of OpenText Analytics Database (Vertica) is very strong.
Whenever we need more resources, we can add that in Teradata, and when not needed, we can scale it down as well.
This flexibility allows organizations to scale according to their needs, balancing performance, cost, and compliance requirements.
This expansion can occur without incurring downtime or taking systems offline.
OpenText Analytics Database (Vertica) is very stable.
Its massively parallel process architecture allows the platform to distribute workload efficiently, enabling organizations to run heavy analytic queries without compromising speed or stability.
I find the stability to be almost a ten out of ten.
The workload management and software maturity provide a reliable system.
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.
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.
I want to highlight two features for improvement: first, storing data in various formats without requiring a tabular structure, accommodating unstructured data; and second, adding AI ML features to better integrate Gen AI, LLM concepts, and user-friendly experiences such as text-to-SQL capabilities.
Unlike SQL and Oracle, which have in-built replication capabilities, we don't have similar functionality with Teradata.
The most challenging aspect is finding Teradata resources, so we are focusing on internal training and looking for more Teradata experts.
The pricing for OpenText Analytics Database (Vertica) is somewhat on the higher side for the license.
Teradata is much more expensive than SQL, which is well-performed and cheaper.
Initially, it may seem expensive compared to similar cloud databases, however, it offers significant value in performance, stability, and overall output once in use.
Role-based access control (RBAC), strong audit and compliance features, high availability, fault tolerance, and encrypted data at rest and in-transit are key features.
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.
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.
Teradata's security helps our organization meet compliance requirements such as GDPR and IFRS, and it is particularly essential for revenue contracting or revenue recognition.
Its architecture allows information to be processed efficiently while maintaining stable performance, even in highly demanding environments.
It facilitates data integration, where we integrate and analyze data from various sources, making it a powerful and high-quality reliable solution for the company.
| Product | Market Share (%) |
|---|---|
| Teradata | 9.4% |
| OpenText Analytics Database (Vertica) | 5.3% |
| Other | 85.3% |

| Company Size | Count |
|---|---|
| Small Business | 29 |
| Midsize Enterprise | 23 |
| Large Enterprise | 41 |
| Company Size | Count |
|---|---|
| Small Business | 28 |
| Midsize Enterprise | 13 |
| Large Enterprise | 52 |
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.
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?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.
Teradata is a powerful tool for handling substantial data volumes with its parallel processing architecture, supporting both cloud and on-premise environments efficiently. It offers impressive capabilities for fast query processing, data integration, and real-time reporting, making it suitable for diverse industrial applications.
Known for its robust parallel processing capabilities, Teradata effectively manages large datasets and provides adaptable deployment across cloud and on-premise setups. It enhances performance and scalability with features like advanced query tuning, workload management, and strong security. Users appreciate its ease of use and automation features which support real-time data reporting. The optimizer and intelligent partitioning help improve query speed and efficiency, while multi-temperature data management optimizes data handling.
What are the key features of Teradata?
What benefits and ROI do users look for?
In the finance, retail, and government sectors, Teradata is employed for data warehousing, business intelligence, and analytical processing. It handles vast datasets for activities like customer behavior modeling and enterprise data integration. Supporting efficient reporting and analytics, Teradata enhances data storage and processing, whether deployed on-premise or on cloud platforms.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.