Try our new research platform with insights from 80,000+ expert users

OpenText Analytics Database (Vertica) vs Oracle Database Cloud Service comparison

 

Comparison Buyer's Guide

Executive Summary

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
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (7th), Cloud Data Warehouse (10th)
Oracle Database Cloud Service
Average Rating
8.4
Reviews Sentiment
7.8
Number of Reviews
13
Ranking in other categories
Relational Databases Tools (15th)
 

Mindshare comparison

OpenText Analytics Database (Vertica) and Oracle Database Cloud Service aren’t in the same category and serve different purposes. OpenText Analytics Database (Vertica) is designed for Data Warehouse and holds a mindshare of 7.8%, down 9.3% compared to last year.
Oracle Database Cloud Service, on the other hand, focuses on Relational Databases Tools, holds 0.7% mindshare, up 0.4% since last year.
Data Warehouse
Relational Databases Tools
 

Featured Reviews

T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…
Ajeet-Sachan - PeerSpot reviewer
Self-maintenance features reduce downtime and improve efficiency but enterprise edition limits can be restrictive
The availability of different editions within Oracle Database Cloud Service could be improved. The model divides their standard edition versus enterprise editions into two categories and limits the standard edition on a particular configuration set. This limitation, such as the thirty-two vCPU limit, should be removed. Another area for improvement is the affordability of the enterprise version.

Quotes from Members

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

Pros

"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"Initiate on one node, and the RPM propagates automatically to all other nodes. ​"
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. ​"
"Eighty percent of the ETL operations have improved since implementing this solution."
"It has improved my organization's functionality and performance."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"I am impressed with the product's partitioning and advanced data card."
"What I like best about Oracle Database Cloud Service is its nice performance. My company doesn't have any problems with the service. The technical support for it is also good. My company is satisfied with Oracle Database Cloud Service. I also like the availability of the service. It's a trustworthy service. I didn't experience any downtime from it. My company also has additional features included in the contract, such as WAP, which makes operations easier. My team can implement all the architecture with the features and services that Oracle Database Cloud Service offers. Technically, this is a very, very, good product or database, whether on-premises or on the cloud."
"The most valuable feature of Oracle Database Cloud Service is its cloud capabilities."
"Some advantages of Oracle Database Cloud Service are its availability, performance, and affordability."
"It is a very stable program."
"The product’s most valuable feature is affordable pricing compared to other providers."
"Data storage is the most valuable feature of Oracle Database Cloud Service."
"Oracle DCS's most valuable features are its high availability and scalability."
 

Cons

"Limitations in group by projections is where I would like to see an improvement."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"I believe the installation process could be streamlined."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"The integration with AI has room for improvement."
"Oracle Database Cloud Service has room for improvement in handling large-scale applications."
"In my opinion, the price of Oracle Database Cloud Service should be more affordable. Additionally, the interface of the application could be more user-friendly."
"Oracle should work on the solution's compatibility issues with the operating system."
"Oracle Database Cloud Service could improve by adding some cross-region replication features."
"The pricing must be improved."
"We encountered connection failures for some of our sites."
"The availability of different editions within Oracle Database Cloud Service could be improved."
"Oracle Database Cloud Service is a good engine and at the moment, there isn't any new feature I can think of that I'd like added to the service. The only problem I see in Oracle Database Cloud Service is it's more commercial, so it has a relation to how it deals with customers. I don't feel secure in a deal with Oracle because that team changes the conditions each year, and there's no representative from the team that talks to my company about new needs. Oracle needs to improve its relationship with customers and partners in general."
 

Pricing and Cost Advice

"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."
"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
"It's an expensive product"
"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."
"The tool is not cheap."
"Every year we are increasing the price of the solution. There is hardware licensing available. We pay approximately $20,000 monthly to use the solution."
"Price is always higher for all Oracle products."
"The product has reasonable pricing. I rate its pricing a nine out of ten."
"Pricing for Oracle Database Cloud Service could be more competitive. Lately, pricing for it has been increasing, so my company may have to review different options to find a solution with competitive pricing. From what I know, there's no additional cost apart from the standard licensing fees for Oracle Database Cloud Service."
"I think the program is rather expensive, so I would like to see it becoming more affordable."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
865,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
16%
Manufacturing Company
9%
Comms Service Provider
5%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
What do you like most about Oracle Database Cloud Service?
Security is the most valuable feature provided by the product.
What needs improvement with Oracle Database Cloud Service?
In my opinion, the price of Oracle Database Cloud Service should be more affordable. Additionally, the interface of the application could be more user-friendly.
What is your primary use case for Oracle Database Cloud Service?
I primarily use Oracle Database Cloud Service in HR services, collaborating with other teams on projects. It is used for database management for clients, especially in HR solutions.
 

Also Known As

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
No data available
 

Overview

 

Sample Customers

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Kagool, iPoint-Systems
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: July 2025.
865,649 professionals have used our research since 2012.