Name: OpenText Analytics Database (Vertica)
Brand: OpenText
Rating: 4.1 (90 reviews)

it_user505371

Sr. Software Engineer (Database) at a tech services company with 1,001-5,000 employees

Sep 2, 2016

Download

I like the Query Performance.

Pros and Cons

"Query Performance."

"We had confronted couple of issues during Vertica upgrades for which we do align with your support group."

What is most valuable?

Query Performance.

What needs improvement?

More analytical functions. Optimization around DML operations such that we be able to use it more. I understand that Vertica is not meant for that, but I would really love it if it has capability to support procedural processing.

Optimization around DML refers to fast DELETE and UPDATE statement such that we can leverage Vertica around those operations. I do understand that Vertica is not meant as an OLTP system, neither I'm asking to have it similar but if DML operations can be optimized, that would be admirable.

Regarding, my comment on the capability to support procedural processing - Vertica as of now is mainly used via SQL only. If we have to use any procedure based operation, we do it via User Defined Functions. If within Vertica itself, we have the capability to create & execute procedure similar to that for functions, it would be a plus. Again, I do understand that this may be against the architecture of Vertica but if there is anything that can be revised to get these supported, that would be preferred.

For how long have I used the solution?

3+ years

What was my experience with deployment of the solution?

Initially yes, but now we're used to it. Challenges do come up but it's all well understood.

Buyer's Guide

OpenText Analytics Database (Vertica)

March 2026

Free Report: OpenText Analytics Database (Vertica) Reviews and More

Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.

DOWNLOAD NOW

884,873 professionals have used our research since 2012.

What do I think about the stability of the solution?

We had confronted couple of issues during Vertica upgrades for which we do align with your support group.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user505416

Database Admin at a tech services company with 1,001-5,000 employees

Sep 1, 2016

Download

Replication is the main feature for my use.

Pros and Cons

"Replication and Node recovery in 8.0."

"vbr.py needs to be improve to support diff no of nodes source to target."

Valuable Features

Replication

Improvements to My Organization

Replication and Node recovery in 8.0.

Room for Improvement

vbr.py needs to be improve to support diff no of nodes source to target.

Use of Solution

5 years

Deployment Issues

Stability Issues

Yes

Scalability Issues

Customer Service and Technical Support

Customer Service:

Technical Support:

8/10

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

Buyer's Guide

OpenText Analytics Database (Vertica)

March 2026

Free Report: OpenText Analytics Database (Vertica) Reviews and More

Learn what your peers think about OpenText Analytics Database (Vertica). Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.

DOWNLOAD NOW

884,873 professionals have used our research since 2012.

it_user505386

Senior Database Administrator; HP Vertica, MySQL, MSSQL, Cloud Ops at a tech vendor with 501-1,000 employees

Sep 1, 2016

Download

For me the most valuable aspect is the speed of columnar data.

Pros and Cons

"Speed of columnar data."

"Node recovery is very inconsistent and impacts performance."

What is most valuable?

Speed of columnar data.

What needs improvement?

Performance tuning; user community is needed.

For how long have I used the solution?

1 year

What do I think about the stability of the solution?

Node recovery is very inconsistent and impacts performance.

What do I think about the scalability of the solution?

Concurrency

How are customer service and technical support?

Customer Service:

Terrible

Technical Support:

Terrible

Which solution did I use previously and why did I switch?

SQL Server and Oracle.

How was the initial setup?

Simple

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user505317

DW Admin at a hospitality company with 1,001-5,000 employees

Sep 1, 2016

Download

It is the foundation of our new Data Warehouse platform because of the scalability and query speed.

Pros and Cons

"It is the foundation of our new Data Warehouse platform."

"There have been some issues with deleting and updating data from tables."

What is most valuable?

Scalability, query speed.

How has it helped my organization?

It is the foundation of our new Data Warehouse platform.

What needs improvement?

Data velocity and manageability.

For how long have I used the solution?

The utilization/launching project has lasted for a bit more than a year now.

What was my experience with deployment of the solution?

There have been some issues with deleting and updating data from tables.

What do I think about the stability of the solution?

What do I think about the scalability of the solution?

How are customer service and technical support?

Customer Service:

I have not been in contact with their customer service.

Technical Support:

I have not been in contact with their tech support.

Which solution did I use previously and why did I switch?

We used Oracle but it did not scale well enough

How was the initial setup?

It was straightforward.

What about the implementation team?

I was not involved with the implementation.

What was our ROI?

Don't know.

What's my experience with pricing, setup cost, and licensing?

The pricing is very flexible

Which other solutions did I evaluate?

There was a proof of concept for a number of technologies but I wasn't involved in those.

What other advice do I have?

It looks promising.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user505263

Principal Data Architect (BI) at a media company with 1,001-5,000 employees

Sep 1, 2016

Download

I like the fast analytical functions and ability to extend functionality.

Pros and Cons

"Customer Service: Great Technical Support: Great"

"Sometimes users write bad queries that has brought down the cluster."

What is most valuable?

Bulk loading data using copy

Fast analytical functions

Ability to extend functionality

How has it helped my organization?

Great reporting.

What needs improvement?

Faster deletes!

For how long have I used the solution?

4 years

What was my experience with deployment of the solution?

None

What do I think about the stability of the solution?

Sometimes users write bad queries that has brought down the cluster. Need a way to better manage resources.

What do I think about the scalability of the solution?

None

How are customer service and technical support?

Customer Service:

Great

Technical Support:

Great

Which solution did I use previously and why did I switch?

What about the implementation team?

In house implementation.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user505260

Senior Data Architect at a media company with 1,001-5,000 employees

Sep 1, 2016

Download

Having the ability invoke analytic functions without having write self join SQL statements is beneficial.

Pros and Cons

"We are trying to data mine customer event data, and having the ability to invoke analytic functions without having to write self-join SQL statements is just brilliant."

"Ability to use analytic functions in where clauses, being able to use aliases in the where and order by clauses will make query writing/reading a lot easier."

Valuable Features:

Analytic functions.

Improvements to My Organization:

We are trying to data mine customer event data. Having the ability invoke analytic functions without having write self join SQL statements ... just brilliant.

Room for Improvement:

Ability to use analytic functions in where clauses, being able to use aliases in the where and order by clauses will make query writing/reading a lot easier.

Use of Solution:

2 years.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.

it_user505137

Owner at a tech vendor

Sep 1, 2016

Download

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?

Geospatial

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.

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

it_user505218

Infrastructure, Data Center and PMO Coordinator at a comms service provider with 501-1,000 employees

Sep 1, 2016

Download

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