Item: OpenText Vertica
Rating: 7
Author: Verified User

Overall Satisfaction with Vertica

Use Cases and Deployment Scope

Vertica forms the analytics database that takes in realtime streaming data (from Apache Kafka) and is used to provide customer insights in near real-time. It is used for the consumer-facing web portal and mobile applications.

Pros and Cons

Pros

It is able to intake real-time streaming data without much pre-processing and latency.
Easy to integrate with real-time streaming ingestion engine.

Cons

Vertica does not perform well when you have a lot of schemata.
The management console including GUI is lacking features and can be improved with features that are typical of a database.

Return on Investment

Positive impact on ROI by being able to get customer insights in real-time.
Positive ROI through reduced time to set-up and maintain Vertica instances.

Alternatives Considered

SAP HANA, MySQL, PostgreSQL, Oracle Data Warehouse, Snowflake, Google BigQuery and Cloudera Distribution Hadoop (CDH)

SAP HANA, Oracle, MySQL, and PostgreSQL are too heavyweight for achieving real-time latency requirements. Google BigQuery is limited to Cloud that makes hard to integrate with a large ingestion pipeline that may have both Cloud-based and on-prem components. Hadoop is much more complex to setup. Snowflake is again Cloud-based and is a new player so its reputation is not well known.

Support Rating

HP/Micro Focus Vertica support is in par with other bigger vendors. In addition to this, there is enough best practices documentation available for some of the most common ways you will use Vertica that makes it easy to get Vertica up and running.

Key Insights

Do you think OpenText Vertica delivers good value for the price?

Yes

Are you happy with OpenText Vertica's feature set?

Did OpenText Vertica live up to sales and marketing promises?

Yes

Did implementation of OpenText Vertica go as expected?

Yes

Would you buy OpenText Vertica again?

Yes

Other Software Used

Google BigQuery, Apple iCloud, iOS

Likelihood to Recommend

Vertica is well suited when latency from incoming data is key and you need Strickland timing guarantees to process the real-time streaming data. It is very well suited if you are using Confluent/Apache Kafka as the set-up and install is super easy and there best practice documentation available for it. It is less appropriate where you are looking at complex queries and schemas.

Comments

Please log in to join the conversation

Vertica Review