Geospatial
Owner at a tech vendor
We switched from our previous solution because SQL Server did not scale.
Pros and Cons
- "Customer Service: Excellent Technical Support: Very good"
- "Profiling, query optimize, management."
What is most valuable?
What needs improvement?
Profiling, query optimize, management.
For how long have I used the solution?
1 year
What was my experience with deployment of the solution?
Some bugs, they were rapidly fixed.
Buyer's Guide
OpenText Analytics Database (Vertica)
April 2026
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
893,244 professionals have used our research since 2012.
What do I think about the stability of the solution?
Minute
What do I think about the scalability of the solution?
Not yet
How are customer service and support?
Customer Service:
Excellent
Technical Support:Very good
Which solution did I use previously and why did I switch?
SQL Server did not scale.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Infrastructure, Data Center and PMO Coordinator at a comms service provider with 501-1,000 employees
We could use it to offer Analytics As A Service to our customers.
Pros and Cons
- "Customer Service: Excellent! Technical Support: Excellent!"
- "Yes, there is a functionality in Vertica "Broadcast" that high the process level of our Network Switch Core. I had a serious problem with this because I interrupted the network service in the company."
Valuable Features
Manage big data fast and easy.
Room for Improvement
The time that the mediation process takes and historical information that I can store.
Deployment Issues
Yes, there is a functionality in Vertica "Broadcast" that high the process level of our Network Switch Core. I had a serious problem with this because I interrupted the network service in the company. We have to change "Point to point".
Customer Service and Technical Support
Customer Service:
Excellent!
Technical Support:Excellent!
Other Solutions Considered
Other Advice
I would like HP to help me to do more uses cases with Vertica. We are very interested in becoming a Business Partner in order to offer Analytics As A Service to our customers.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
OpenText Analytics Database (Vertica)
April 2026
Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
893,244 professionals have used our research since 2012.
Data Scientist at a tech vendor with 201-500 employees
We were able to implement new algorithms without having to move data out of Vertica into a compute cluster.
Pros and Cons
- "We were able to implement new algorithms without having to move data out of Vertica into a compute cluster."
- "More Machine Learning algorithms--Random Forest for sure!"
Valuable Features
User Defined Extensions
Analytic Functions
Improvements to My Organization
We were able to implement new algorithms without having to move data out of Vertica into a compute cluster. This allowed us to offer Analytics for Cybersecurity to our customers.
Room for Improvement
More Machine Learning algorithms--Random Forest for sure!
Customer Service and Technical Support
Customer Service:
Very responsive
Technical Support:Excellent
Implementation Team
In-house
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Data Scientist at a tech services company with 501-1,000 employees
We're able to test more models and improve accuracy.
Pros and Cons
- "We could run group by queries thousand of times faster, we are able to test more models and improve accuracy."
Valuable Features
Group by performance
Analytic functions
Improvements to My Organization
We could run group by queries thousand of times faster, we are able to test more models and improve accuracy.
Room for Improvement
Debug custom functions in r.
Use of Solution
One year
Deployment Issues
None
Stability Issues
None
Scalability Issues
None
Customer Service and Technical Support
Customer Service:
Great! Email response is quickly and also within reported issues are resolved.
Technical Support:Ggreat, they really understand what they are talking about.
Initial Setup
Straightforward, very easy.
Implementation Team
In house
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Senior Database Administrator at a financial services firm with 51-200 employees
I like Recovery by table. I would like messages to Vertica startup commands improved.
Pros and Cons
- "After upgrading to latest version, VBR backup used to take more than one week to back up 70 TB of data and now it is taking about 48 hours."
- "Improve Vertica logging and messages to Vertica startup commands."
Valuable Features:
Recovery by table
Copy cluster
Improvements to My Organization:
VBR backup used to take more than one week to back up 70 TB of data. After upgrading to latest version, it is taking about 48 hours.
Room for Improvement:
Improve Vertica logging and messages to Vertica startup commands.
Use of Solution:
4 years
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Sr. Developer, Big Data at a comms service provider with 51-200 employees
The most valuable feature for me is the columnar data store.
Pros and Cons
- "Setup was very simple"
Valuable Features:
Columnar data store
Room for Improvement:
Add geospatial indexes (sounds like they have done it in version 8.0)
Deployment Issues:
No
Stability Issues:
No
Scalability Issues:
No
Customer Service:
Above average
Initial Setup:
Setup was very simple
Disclosure: My company has a business relationship with this vendor other than being a customer. We are partners with HPE
CIO at a tech vendor with 1,001-5,000 employees
Features valuable to me include: massive data ingestion performance and SQL standard query engine.
Pros and Cons
- "Massive data ingestion performance"
- "Massive data ingestion performance."
- "Machine learning implementations."
- "Machine learning implementations."
Valuable Features:
- Massive data ingestion performance
- Performance
- SQL standard query engine
Improvements to My Organization:
DWH core platform is based on it
Room for Improvement:
- Machine learning implementations
- Support for Cloud based environments like Google Compute Engine
Use of Solution:
3 years
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
We can quickly identify with the root cause analysis where trends are.
Pros and Cons
- "We're just now getting into Vertica, but it allows us to store and access big data very quickly."
- "If you're working in a small business, it will tend to overtake most of their budget from a cost perspective because you need so many servers, so much storage, to be able to handle all that stuff."
Valuable Features:
We're just now getting into Vertica, but it allows us to store and access big data very quickly. It comes down to being able to quickly identify where the root cause analysis is and where trends are, so you can actually try to almost predict where problems are before they really become a problem.
Improvements to My Organization:
The ability to access in-store, big data, and be able to create keywords for faster resolution and look up an individual, hey we did this problem before. It'll show you all the steps and everything, along with different products. Vertica is pretty much the database behind it. It really does the performance aspect of it.
Room for Improvement:
I guess really the only thing there is if you get a server big enough to handle Vertica, it does just fine. If you're working in a small business, it will tend to overtake most of their budget from a cost perspective because you need so many servers, so much storage, to be able to handle all that stuff.
Stability Issues:
It's very stable.
Initial Setup:
We had no issues deploying it.
Other Solutions Considered:
I did not really look at any competition. Basically, it's like I said, we're an HP shop and a lot of their applications are going to a Vertica database for its storage and processing of data. We were doing a lot of Oracle, but Oracle was actually moving towards Vertica in our environment.
Other Advice:
Make sure you understand how much data that you're going to be incorporating into the big data, so you can actually define the amount of storage and redundant storage appropriately.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Download our free OpenText Analytics Database (Vertica) Report and get advice and tips from experienced pros
sharing their opinions.
Updated: April 2026
Popular Comparisons
Azure Data Factory
VMware Tanzu Data Solutions
Oracle Exadata
Amazon Redshift
Microsoft Azure Synapse Analytics
IBM Netezza Performance Server
Oracle Autonomous Data Warehouse
Buyer's Guide
Download our free OpenText Analytics Database (Vertica) Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which is the best RDMBS solution for big data?
- What is the biggest difference between Amazon Redshift and Vertica
- Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
- When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
- At what point does a business typically invest in building a data warehouse?
- Is a data warehouse the best option to consolidate data into one location?
- What are the main differences between Data Lake and Data Warehouse?
- Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
- What is the best data warehouse tool?
- Which Data Strategy solution have you used?













