OpenText Analytics Database (Vertica) vs Oracle NoSQL comparison

OpenText Analytics Database (Vertica) vs. Oracle NoSQL

Download the complete report

Helped 894,738 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

OpenText Analytics Database...

Average Rating

8.2

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

Data Warehouse (5th), Cloud Data Warehouse (11th)

Oracle NoSQL

Average Rating

8.0

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

NoSQL Databases (13th)

Featured Reviews

Jitendrak Naik

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.

Read full review

Susantha Kumar

Support on banking at Aithent

Handles large data volumes effectively but connection issues require attention

The Oracle NoSQL solution is used primarily for storing data for our web applications. We work alongside the DBA team for this purpose, given that specific departments manage aspects of its use. We choose it specifically to handle large scales of data, such as in one of our bank customer's scenarios using more than nine hundred gigabytes of data.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"It's the fastest database I have ever tested. That's the most important feature of Vertica."

"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."

"Eighty percent of the ETL operations have improved since implementing this solution."

"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."

"Its projections and encoding are excellent tools for tuning large volumes."

"Initiate on one node, and the RPM propagates automatically to all other nodes. "

"I would name HPE Vertica as the most mature columnar database with a best of class data storage and query engine."

"Speed and resiliency are probably the best parts of this product."

More OpenText Analytics Database (Vertica) pros

"The product meets expectations when it comes to stability."

"We have a support agreement with Oracle, ensuring full support for the product. It is crucial for our public-facing features. Oracle NoSQL is easy to manage and has fast data retrieval. Its compatibility with Oracle Database is seamless, making integration between NoSQL and relational databases smooth and effortless. Oracle NoSQL and NoSQL data replication in our environment works efficiently. Oracle fully supports it, and we can easily configure and manage authentication for the NoSQL database."

"NoSQL has high availability. I think it's perfect from a technical perspective. It's quick to run and go."

"Oracle NoSQL is pretty scalable."

"The features I've found to be most valuable are the speed of reading and writing (read/write performance levels are really high), the transactions model (semantics for data manipulation), and just the overall simplicity of using it."

"The tool is easy to learn."

"Try it! You’ll be impressed."

"With Oracle NoSQL, our clients have a highly scalable, simple to set up database that performs very well when data is organized correctly from the beginning."

More Oracle NoSQL pros

Cons

"The geospatial functionality could be designed better."

"Very bad support, I would rate it two out of 10."

"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."

"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."

"I believe the installation process could be streamlined."

"Stability is good, however the database crashed once because a query ran against a large XML data element."

"The biggest problem is the cost of cloud deployment."

"Node recovery is very inconsistent and impacts performance."

More OpenText Analytics Database (Vertica) cons

"Handling big data in a user-friendly way is currently a bit of an issue. The dashboard for this needs some work."

"Oracle could improve how NoSQL works in containers. I don't think NoSQL needs any new features, but I want to see new features in the Oracle Cloud Infrastructure. I would like to see some improvements in OCI's building options."

"The main areas that need improvement with NoSQL are in the area of big data and user-friendly presentation."

"You will get high performance when you organize your data correctly at the beginning. Otherwise, there are instability issues."

"Oracle could improve how NoSQL works in containers. I don't think NoSQL needs any new features, but I want to see new features in the Oracle Cloud Infrastructure."

"Personally, I’d like to see some improvements in the monitoring UI for it."

"I would rate Oracle NoSQL six or 6.5 out of ten based on my experience."

"Focusing on making the administration easier compared to other solutions like MongoDB could be beneficial. Simplifying the administrative tasks could enhance the user experience."

More Oracle NoSQL cons

Pricing and Cost Advice

"From a cost perspective, the software is less than most of its competitors."

"The pricing and licensing depend on the size of your environment and the zone where you want to implement."

"Read the fine print carefully."

"The pricing could improve, it is a little expensive."

"The price could be cheaper and it is best to negotiate the price."

"It's an expensive product"

"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October)."

"The pricing for this solution is very reasonable compared to other vendors."

More OpenText Analytics Database (Vertica) pricing and cost advice

"The product is expensive and Oracle could work to lower the licensing cost."

See which vendors are best for you

Use our free recommendation engine to learn which NoSQL Databases solutions are best for your needs.

See recommendations

894,738 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

18%

Computer Software Company

11%

Manufacturing Company

Comms Service Provider

Financial Services Firm

15%

Outsourcing Company

Manufacturing Company

Comms Service Provider

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	29
Midsize Enterprise	23
Large Enterprise	43

By reviewers
Company Size	Count
Midsize Enterprise	3
Large Enterprise	5

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...

What is your experience regarding pricing and costs for Oracle NoSQL?

We use the enterprise edition of Oracle NoSQL.

What needs improvement with Oracle NoSQL?

Sometimes we face problems with the connection between our applications and the database. It may be due to network issues or performance issues on Oracle's side. Our DBA team requests validations f...

What is your primary use case for Oracle NoSQL?

We use Oracle NoSQL ( /products/oracle-nosql-reviews ) to store data for our web applications. It is being used for customer projects, and we handle one of our bank customers using more than nine h...

Snowflake vs OpenText Analytics Database (Vertica)

Comparisons

Compared 7% of the time

Teradata vs OpenText Analytics Database (Vertica)

Compared 7% of the time

Oracle Exadata vs OpenText Analytics Database (Vertica)

Compared 5% of the time

SAP IQ vs OpenText Analytics Database (Vertica)

Compared 4% of the time

BigQuery vs OpenText Analytics Database (Vertica)

Compared 4% of the time

More OpenText Analytics Database (Vertica) Competitors

MongoDB Enterprise Advanced vs Oracle NoSQL

Compared 17% of the time

Cassandra vs Oracle NoSQL

Compared 14% of the time

Cloudera Distribution for Hadoop vs Oracle NoSQL

Compared 11% of the time

Amazon QLDB vs Oracle NoSQL

Compared 10% of the time

CouchDB vs Oracle NoSQL

Compared 3% of the time

More Oracle NoSQL Competitors

Product Reports

OpenText Analytics Database (Vertica)

Download OpenText Analytics Database (Vertica) product report

OpenText Analytics Database (Vertica) report

NoSQL Databases

Download Oracle NoSQL product report

Also Known As

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand

No data available

Overview

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?

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

Oracle NoSQL is known for its distributed architecture, which ensures scalability and high availability, making it ideal for handling substantial data across diverse applications.

Oracle NoSQL leverages its distributed nature to offer automatic load balancing and powerful schema evolution tools. With features such as a Java table API and seamless integration with Oracle Database, it efficiently manages unstructured data and supports high read/write operations. Departments dealing with large-scale data benefit from fast data retrieval and effective data replication, with support agreements facilitating easy management.

What are Oracle NoSQL's key features?

Distributed Architecture: Ensures data availability and scalability.
Automatic Load Balancing: Distributes workloads evenly across servers.
Table API for Java: Facilitates integration with Java applications.
Powerful Schema Evolution: Allows changes without downtime.
Efficient Data Replication: Supports high availability and disaster recovery.

What benefits should users expect?

High Performance: Fast data retrieval for large datasets.
Seamless Integration: Compatibility with Oracle Database enhances usability.
Easy Data Management: Simplifies handling of unstructured data.
Scalability: Supports future data growth effortlessly.

In telecom solutions, Oracle NoSQL helps store structured data and logs, supporting relational databases. It plays a crucial role in banking by managing over 900 gigabytes of data, facilitating data fetching and updates efficiently. Its implementation across infrastructure and web applications highlights its robustness in varied use cases.

Oracle

Sample Customers

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

Airbus, Globacom, WebAction

OpenText Analytics Database (Vertica) vs. Oracle NoSQL