TechValidate Research on Vertica


Case Study: Foundation

Introduction

This case study of a foundation is based on a March 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled organization asked to have their name blinded to protect their confidentiality.

“New features added frequently. Hotfixes and improvements delivered in a timely manner.”

“HPE is the platform for the EDW, analytics, and reporting.”

“We would recommend HPE Vertica because it is constantly improving and the ability to horizontal scale makes it a great platform to work on.”

“HPE Vertica has allowed us to centralized data for reporting purposes.”

Challenges

  • Is using HPE Vertica for the following:
    • Financial tracking
    • Customer analytics
    • Compliance testing
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with HPE Vertica:
    • MSFT
    • MySQL
    • Oracle

Use Case

  • Currently manages 6TB or less of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with HPE Vertica:
    • BI: Cognos 8/10/11
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tools in their environment with HPE Vertica:
    • Replication: Oracle GoldenGate
    • Advanced Analytics: Alteryx

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Concurrency for hundreds or thousands of users
    • Superior compression
    • Database designer and administration tools
    • High availability without hardware redundancy
    • Semi structured and structured data analytics in one environment
  • Improved query performance by 501 – 1,000% with HPE Vertica.




About This Data

This data was sourced directly from verified users of Vertica by TechValidate.

TechValidate verifies the identity and organizational affiliation of all participants that contribute to published research data. When research participants so desire, we also guarantee their anonymity so that they may share information honestly and freely.


More Research on Vertica