MicroFocus Vertica - Collection of Mini Case Studies

Check out what users are saying about MicroFocus Vertica.



Case Study: Symphony Advanced Media

Introduction

This case study of Symphony Advanced Media is based on a February 2016 survey of Vertica customers by TechValidate, a 3rd-party research service.

“We have 3 node cluster for high availability and load balancing. We predominantly use this DB for Data analytics to judge users behavior. It’s a is single-source data collection – understanding the behavior of consumers across multimedia with a representative panel of consumers, providing advertisers, media companies and market research firms, the opportunity for insights into this behavior.”

“I would personally recommend Vertica for the application which has a fixed set of report generation which rarely changes because the projections we design is query specific and having multiple projections for the same table can prove expensive in terms of storage and data loading.”

“We’ve done POC with Amazon Redshift and Oracle’s In-Memory DB but both proved to be expensive for our kind of requirement. Our DB is busy round the clock as expected because we record panelists usage via smartphones, the web, and TV. The majority of times the tables would be getting loaded while the reports are generated.”

Challenges

  • Using Vertica for the following:
    • Machine/sensor data analysis (Internet of Things)
    • Behavior analytics
    • Customer analytics
    • Loyalty analytics
    • Predictive analytics
    • Campaign management
  • Replaced the following vendors with Vertica:
    • Vertica is our primary solution

Use Case

  • Currently manages 6TB or less of data with Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with Vertica:
    • ETL: Hadoop
    • ETL: Talend
    • BI: Tibco Spotfire/Jaspersoft
    • BI: Microstrategy
    • BI: Qlikview/QlikSense
  • Uses the following Advanced Analytics and/or Replication tools in their environment with Vertica:
    • Replication: Home Grown (describe)
    • Advanced Analytics: Home grown (describe in other)

Results

  • The following are the most valuable Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Simultaneous loading and querying
    • Concurrency for hundreds or thousands of users
    • Superior compression
    • In-database analytics capabilities
    • Ease of interaction with existing BI tools & ETL tools
    • High availability without hardware redundancy
    • Advanced analytics: predictive, geospatial, sentiment, etc
  • Reduced TCO by 1-25% with Vertica.
  • Improved query performance by 51 – 100% with Vertica.

Case Study: S&P 500 Computer Software Company

Introduction

This case study of a S&P 500 computer software company is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“Our organization uses HPE Vertica as the primary query platform for EDW.”

“Vertica has been a solid performer for our specific workflow. HPE has been a great partner. They have been very willing to work with us to make sure that Vertica continues to be a great fit.”

“HPE has been a great partner. Vertica has worked well in a number of different applications.”

“With HPE Vertica, our analysts’ workflows have completely changed. Instead of submitting a query and getting the results in hours, they are getting results in seconds. That totally changes their interactions with our clients.”

Challenges

  • Uses HPE Vertica for the following:
    • Claims analytics
    • Patient records analytics
    • Clinical data analytics
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with HPE Vertica:
    • Pivotal
    • IBM
    • Oracle Exadata
    • SAP
    • SybaseIQ

Use Case

  • Currently manages 201 – 500 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with HPE Vertica:
    • ETL: Hadoop
    • ETL: Kafka
    • BI: Business Objects (Inc Crystal Reports)
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tool in their environment with HPE Vertica:
    • Replication: Home Grown

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Superior compression
    • Ease of interaction with existing BI tools & ETL tools
    • Workload management
  • Improved query performance by > 1,000% with HPE Vertica.

Case Study: S&P 500 Computer Software Company

Introduction

This case study of a S&P 500 computer software company is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“We use Vertica to provide access to Healthcare data through a variety of tools and technologies. We rely on Vertica’s speed and scale to enable us to load hundreds of TBs of data while providing continuous high-speed access to the data.”

“We have had a lot of success with HPE products and have received very good support from the account team.”

“I would recommend Vertica for its speed and scale.”

“Vertica has enabled us to answer questions that were not possible to answer with some of our legacy RDBMS platforms. Vertica also increases the efficiency with which our end users can browse data and gain valuable insights.”

Challenges

  • Uses HPE Vertica for the following:
    • Claims analytics
    • Patient records analytics
    • Clinical data analytics
    • Predictive analytics
  • Replaced the following vendors with HPE Vertica:
    • SAP
    • Teradata

Use Case

  • Currently manages 201 – 500 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with HPE Vertica:
    • ETL: Hadoop
    • BI: Business Objects (Inc Crystal Reports)
    • BI: Tableau

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
    • Ease of interaction with existing BI tools & ETL tools
  • Reduced TCO by 51-100% with HPE Vertica.
  • Improved query performance by 501 – 1,000% with HPE Vertica.

Case Study: Small Business Computer Software Company

Introduction

This case study of a small business computer software company is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“We use Vertica to store and query normalized security log data from a variety of sources at high rates, up to and exceeding 15K events per second. We make significant use of Live Aggregate Projections, which has sped up our ability to visualize data by a factor of 10. Our customer installations range from a single node to 5 node clusters and are hosted or on-premise.”

“Yes, I would recommend HPE Vertica on the basis that our organization does not have a dedicated DBA, and the three of us that make use of Vertica did so without strong DB experience. We have been able to setup clusters with little complication, load, and age out data quickly, and achieve good query response times with the product.”

“We are a startup company that is highly flexible in our product offering. Vertica affords us this flexibility with its ease of installation, maintenance, and configuration, all while sustaining good performance within our expectations. We often refer to Vertica as ‘alien’ technology, in that it does amazing things as long as we follow the instructions handed down to us by smarter people.”

Challenges

  • Is using HPE Vertica for the following:
    • Cyber security monitoring/prevention
  • Replaced the following vendor with HPE Vertica:
    • MongoDB

Use Case

  • Currently manages 21 – 40 TB of data with HPE Vertica.

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
    • Optimizer and execution engine
  • Reduced TCO by 51-100% with HPE Vertica.
  • Improved query performance by 101 – 500% with HPE Vertica.

Case Study: Medium Enterprise Computer Software Company

Introduction

This case study of a medium enterprise computer software company is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“With HPE Vertica, data from the data warehouse is loaded into Vertica for analysis. It is preferred by our analysts for the large data sets over Oracle.”

“Analyzing video game success from all angles is the key to our business. Vertica allows us to achieve that with record speed!”

“It performs very well. I think that its ability to self-tune with new projections gives it a lead on other analytic databases.”

Challenges

  • Uses HPE Vertica for the following:
    • Financial tracking
    • Behavior analytics
    • Customer analytics
    • Enterprise Data Warehouse optimization
    • Sales Analytics
  • Replaced the following vendor with HPE Vertica:
    • Green Plum

Use Case

  • Currently manages 6 – 20 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with HPE Vertica:
    • ETL : Informatica – Power Center
    • BI: Cognos 8/10/11
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tools in their environment with HPE Vertica:
    • Replication: Home Grown

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Standard SQL interface
    • Simultaneous loading and querying
    • Database designer and administration tools
    • Ease of interaction with existing BI tools & ETL tools
    • Optimizer and execution engine
  • Improved query performance by 51 – 100% with HPE Vertica.

Case Study: Datorama

Introduction

This case study of Datorama is based on a February 2016 survey of Vertica customers by TechValidate, a 3rd-party research service.

“We use Vertica for our Marketing analytic platform.”

“Yes, we would recommend Vertica in reason of being fast, reliable, and cost effective.”

“With Vertica, we were able to reduce time of creating Dashboard with data to our clients.”

Challenges

  • Is using Vertica for the following:
    • Behavior analytics
    • Customer analytics
  • Replaced the following vendors with Vertica:
    • Hadoop
    • Amazon Redshift
    • MongoDB

Use Case

  • Currently manages 21 – 40 TB of data with Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tool in their environment with Vertica:
    • BI: Tableau
  • Uses the following Advanced Analytic and/or Replication tool in their environment with Vertica:
    • Custom build

Results

  • The following are the most valuable Vertica capabilities:
    • Simultaneous loading and querying
    • Concurrency for hundreds or thousands of users
    • Superior compression
  • Reduced TCO by 26-50% with Vertica.
  • Improved query performance by 101 – 500% with Vertica.

Case Study: Medium Enterprise Computer Software Company

Introduction

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

“We use HPE Vertica as a data warehouse to understand and debug our customer base.”

“Yes, we would recommend HPE Vertica because there’s nothing quite as good as it in ease of use, and scalability.”

“Fast, reliable, and is SQL.”

“Vertica allowed us to do large scale analysis on our users that allowed us to find toxic behavior, game trends, and sales correlation we couldn’t do with other solutions.”

Challenges

  • Using HPE Vertica for the following:
    • Promotional testing
    • Fraud monitoring/prevention
    • Behavior analytics
    • Network performance analytics
    • Customer analytics
    • Predictive analytics
  • Replaced the following vendors with HPE Vertica:
    • HPE Vertica is our primary solution

Use Case

  • Currently manages 6 – 20 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tool in their environment with HPE Vertica:
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tools in their environment with HPE Vertica:
    • Replication: Home Grown (describe)
    • Advanced Analytics: Home grown (describe in other)

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • In-database analytics capabilities
    • Ease of interaction with existing BI tools & ETL tools
    • High availability without hardware redundancy
    • Optimizer and execution engine
  • Reduced TCO by 26-50% with HPE Vertica.
  • Improved query performance by 501 – 1,000% with HPE Vertica.

Case Study: Small Business Hospitality Company

Introduction

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

“Our organization uses HPE Vertica for Analysis of slot machine gameplay detail to optimize casino game mix and maximize revenue.”

“Yes, we would recommend HPE Vertica for its performance, data compression, and the ability to run on commodity hardware.”

“Performance is outstanding.”

“With HPE Vertica, we have created a competitive advantage for our sales teams by providing immediate insights into game performance and player behavior that was not available in our previous environment.”

Challenges

  • Using HPE Vertica for the following:
    • Financial tracking
    • Behavior analytics
    • Predictive analytics
  • Replaced the following vendors with HPE Vertica:
    • IBM
    • Teradata

Use Case

  • Currently manages 6 – 20 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with HPE Vertica:
    • ETL: Hadoop
    • ETL: Microsoft Integration Services
    • ETL: Talend
    • BI: Microsoft Reporting Services
    • BI: Tableau

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Superior compression
    • Ease of interaction with existing BI tools & ETL tools
  • Improved query performance by 101 – 500% with HPE Vertica.

Case Study: Global 500 Consumer Products Company

Introduction

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

“We use HPE Vertica in a machine to machine data. We analyze data from MRI sensors to preempt maintenance on the device.”

“We recommend Vertica for its speed, industry standard, and the capability of the HPE team.”

“Simple numbers convinced our organization to use Vertica instead of IBM in a specific situation. It’s cheaper, faster and quite simply, better.”

Challenges

  • Using HPE Vertica for the following:
    • Machine/sensor data analysis (Internet of Things)
  • Replaced the following vendors with HPE Vertica:
    • IBM

Use Case

  • Currently manages 201 – 500 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with HPE Vertica:
    • ETL: Hadoop
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tools in their environment with HPE Vertica:
    • Advanced Analytics: Home grown (describe in other)
    • NA

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Standard SQL interface
    • Ease of interaction with existing BI tools & ETL tools
    • Semi structured and structured data analytics in one environment
    • Ability to do low latency SQL queries on Hadoop
  • Reduced TCO by 26-50% with HPE Vertica.

Case Study: MD Insider

Introduction

This case study of MD Insider is based on a February 2016 survey of Vertica customers by TechValidate, a 3rd-party research service.

“We push medical claims data going back several years into Vertica, and make it available to our data scientist to mine gems out of it.”

“Yes!! We would recommend Vertica. The need to run low latency ad-hoc query on large datasets is satisfied with ease using Vertica! While Redshift comes very close in terms of performance, the fact that I can take a Vertica license to my data center, unlike Redshift, makes it preferable!”

“My consumers are data scientists within the organization that mine data out of billions of ingested medical data. Using Vertica has increased, significantly, the productivity of data scientists; due to the speed at which data can get into the engine and can get out of it!”

Challenges

  • Is using Vertica for the following:
    • Claims analytics
    • Patient records analytics
  • Replaced the following vendor with Vertica:
    • MySQL

Use Case

  • Currently manages 6TB or less of data with Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with Vertica:
    • ETL: Talend
    • BI: Tableau

Results

  • The following are the most valuable Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Superior compression
    • In-database analytics capabilities
    • Ease of interaction with existing BI tools & ETL tools
    • High availability without hardware redundancy
    • Ability to do low latency SQL queries on Hadoop
  • Improved query performance by 101 – 500% with Vertica.

Case Study: Abiba Systems

Introduction

This case study of Abiba Systems is based on a February 2016 survey of Vertica customers by TechValidate, a 3rd-party research service.

“We use Vertica for Analytics and DWH.”

“Yes, we would recommend Vertica in reason of good performance and compression technique.”

“Great support and cutting edge technology.”

“My clients are impressed by its query performance and the compression technique. It helped them to do the near to real time analysis of their data.”

Challenges

  • Is using Vertica for the following:
    • Machine / sensor data analysis (Internet of Things)
    • Fraud monitoring / prevention
    • Behavior analytics
    • Customer analytics
    • Predictive analytics
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with Vertica:
    • Apache Spark
    • IBM
    • Infobright
    • MySQL
    • Oracle
    • Vertica is our primary solution

Use Case

  • Currently manages 21 – 40 TB of data with Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with Vertica:
    • ETL: Hadoop
    • ETL: Talend
    • BI: Pentaho B
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tools in their environment with Vertica:
    • Advanced Analytics: Microsoft Analysis Services
    • Advanced Analytics: Pentaho Mondrian

Results

  • The following are the most valuable Vertica capabilities:
    • Standard SQL interface
    • Simultaneous loading and querying
    • Concurrency for hundreds or thousands of users
    • Superior compression
    • Database designer and administration tools
    • In-database analytics capabilities
    • Ease of interaction with existing BI tools & ETL tools
    • Advanced analytics: predictive, geospatial, sentiment, etc
  • Reduced TCO by 26-50% with Vertica.
  • Improved query performance by 51 – 100% with Vertica.

Case Study: Medium Enterprise Health Care Company

Introduction

This case study of a medium enterprise health care company is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“HPE Vertica is used as our hosting platform where a lot of analytics have been performed.”

“Yes, we would recommend HPE Vertica because of the following:
1. It runs really really fast
2. They have the best support professionals
3. There are multiple ways to monitor the performance of the database/queries
4. Parallel load and query feature
5. High availability with improved query performance
6. An easy way to remove/replace/add nodes to the cluster
7. Interface with HADOOP
8. Database design features to enable the best design
9. Addition of new features for Backup, recovery, catalog footprint
10. Feature to save and use the optimized query path
11. Ability to guide an optimized query path.”

“I received valuable support from Vertica support professionals. The way they respond is awesome and support answers all of my queries with patience and dedication. Furthermore, I personally like the product and find the concept to be cool. If there is a problem, HPE always has a solution to fix it through a new patch."

“With HPE Vertica, we are able to reduce the response time significantly. We continue to see an increase in usage by our clients.”

Challenges

  • Is using HPE Vertica for the following:
    • Claims analytics
    • Patient records analytics
    • Clinical data analytics
    • Fraud monitoring/prevention
    • Predictive analytics
  • Replaced the following vendors with HPE Vertica:
    • IBM
    • Oracle
    • Oracle Exadata

Use Case

  • Currently manages 21 – 40 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tool in their environment with HPE Vertica:
    • BI: Microstrategy
  • Uses the following Advanced Analytics and/or Replication tool in their environment with HPE Vertica:
    • Advanced Analytics: SAS

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Database designer and administration tools
    • High availability without hardware redundancy
    • Optimizer and execution engine
    • Workload management
  • Reduced TCO by > 100% with HPE Vertica.
  • Improved query performance by 501 – 1,000% with HPE Vertica.

Case Study: Integra Group

Introduction

This case study of Integra Group is based on a February 2016 survey of Vertica customers by TechValidate, a 3rd-party research service.

“Using Vertica Software provide us with valuable, collectible user behavior data. This significantly decreased the time we spent on our product.”

“We use Vertica as an engine for our product.”

“Top technology.”

Challenges

  • Is using Vertica for the following:
    • Fraud monitoring/prevention
  • Replaced the following vendor with Vertica:
    • Home grown solution

Use Case

  • Uses the following Business Intelligence (BI), Visualization and/or ETL tool in their environment with Vertica:
    • BI: Tableau

Results

  • The following is the most valuable Vertica capability:
    • High availability without hardware redundancy
  • Reduced TCO by 51-100% with Vertica.
  • Improved query performance by 101 – 500% with Vertica.

Case Study: Small Business Health Care Company

Introduction

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

“We use HPE Vertica for back-end storage for medicare claims.”

“Yes, we would recommend HPE Vertica.”

“We’ll give HPE Vertica 10/10 rating because of speed, convenience, SQL query compatibility, and support”

“Vertica allows us to cut query times to one tenth the time of our previous solution. It is easier to implement redundancy while maintaining SQL compatibility. Management is also much simpler.”

Challenges

  • Is using HPE Vertica for the following:
    • Claims analytics
    • Patient records analytics
    • Clinical data analytics
  • Replaced the following vendors with HPE Vertica:
    • MSFT
    • HPE Vertica is our primary solution

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: Microsoft Reporting Services
    • BI: Tableau

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Superior compression
  • Reduced TCO by 26-50% with HPE Vertica.
  • Improved query performance by 101 – 500% with HPE Vertica.

Case Study: Snag A Job.Com, Inc.

Introduction

This case study of SnagAJob.com, Inc. is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service.

“A couple of years ago Snagajob’s data Volume, Velocity, Variety hit a point that couldn’t be handled with traditional database/data warehousing technology. We had transitioned into the BigData space. HPE Vertica and its horizontal scalability model enabled us to provide the same or even better service to our end users while data Volume, Velocity, and Variety are constantly growing to keep up business requirement.”

“Vertica is an excellent product. Performance, ease of use, and stability are exactly as expected.”

“Vertica is the backend engine for high-value customer facing performance data. It also is the backend engine for all Analytical operations for internal users.”

“I’d recommended Vertica to a multiple of my colleagues, primarily due to its performance and stability.”

Challenges

  • Using HPE Vertica for the following:
    • Behavior analytics
    • Clickstream analytics
    • Customer analytics
    • Predictive analytics
  • Replaced the following vendors with HPE Vertica:
    • Amazon Redshift
    • Infobright
    • ParAccel

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:
    • ETL: Hadoop
    • ETL: Pentaho Data Integrator
    • BI: Eclispe Birt
    • BI: Looker
  • Uses the following Advanced Analytics and/or Replication tools in their environment with HPE Vertica:
    • Advanced Analytics: Home grown (describe in other)
    • Luigi Framework

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
    • High availability without hardware redundancy
    • Unified environment: On-prem, on Hadoop, and in the Cloud
  • Improved query performance by 501 – 1,000% with HPE Vertica.

Case Study: Icontact Corporation

Introduction

This case study of Icontact Corporation is based on a February 2016 survey of Vertica customers by TechValidate, a 3rd-party research service.

“Our clients were asking for information that we were not able to provide. We attempted to build a usable product on Infobright where we received inconsistent results. Deploying Vertica has provided the ability to load and analyze all the data we needed accurately. We can now provide insight for our clients at speeds never before seen.”

“Ease of maintenance. Speed and flexibility of querying and loading.”

“We recommend Vertica for all the reasons already mentioned. Customer support too!”

Challenges

  • Using Vertica for the following:
    • Financial tracking
    • Behavior analytics
    • Customer analytics
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with Vertica:
    • IBM
    • Infobright
    • MySQL
    • Teradata

Use Case

  • Currently manages 6TB or less of data with Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with Vertica:
    • ETL: Pentaho Data Integrator
    • BI: Pentaho B
  • Uses the following Advanced Analytics and/or Replication tools in their environment with Vertica:
    • Advanced Analytics: Pentaho Mondrian

Results

  • The following are the most valuable Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Database designer and administration tools
    • Ease of interaction with existing BI tools & ETL tools
  • Improved query performance by 51 – 100% with Vertica.

Case Study: Easy Data

Introduction

This case study of EasyData is based on a February 2016 survey of Vertica customers by TechValidate, a 3rd-party research service.

“Our customers are always sure that they are able to collect all data and analyze it quickly.”

“We are Gold Vertica Specialist 2015 and Gold Big Data Platform Specialist 2016.”

“We would recommend Vertica because it’s the best.”

“Vertica is the best DB platform for analytical processing.”

Challenges

  • Using Vertica for the following:
    • Financial tracking
    • Behavior analytics
    • Network performance analytics
    • Customer analytics
    • Information security
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with Vertica:
    • Oracle
    • SybaseIQ

Use Case

  • Currently manages 81 – 200 TB of data with Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with Vertica:
    • ETL: Oracle Data Integrator
    • ETL: Talend
    • BI: Business Objects (Inc Crystal Reports)
    • BI: Cognos 8/10/11
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tools in their environment with Vertica:
    • Replication: Oracle GoldenGate
    • Advanced Analytics: Microsoft Analysis Services

Results

  • The following are the most valuable Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Concurrency for hundreds or thousands of users
    • Superior compression
    • High availability without hardware redundancy
  • Reduced TCO by 51-100% with Vertica.
  • Improved query performance by 101 – 500% with Vertica.

Case Study: Global 500 Telecommunications Services Company

Introduction

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

“In the world of Analytics, user requirement evolve at a rapid pace. Our users want to gain insights from a VERY large volume quickly and they want to be able to do that immediately. They are excited and want more. Vertica allows me to bring server data to the dashboard with a response time that exceeds SLA. Also “time to market” for new and varied data into dashboard ready form is very low."

“HPE Vertica is an excellent enterprise-level analytic database. It does what it is supposed to do and does it very well. Period.”

“In our Big Data analytic stack, Vertica sits at the end of data flow pipeline. Both ETL and ELT processes are used to load data into Vertica. Analytics dashboards and users retrieve/query data from Vertica.”

Challenges

  • Using HPE Vertica for the following:
    • Clickstream analytics
    • Customer analytics
    • Campaign management
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with HPE Vertica:
    • Oracle
    • Oracle Exadata

Use Case

  • Currently manages 6 – 20 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with HPE Vertica:
    • ETL: Hadoop
    • ETL: Kafka
    • BI: Microstrategy
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tools in their environment with HPE Vertica:
    • Advanced Analytics: Home grown (describe in other)

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Superior compression
    • Database designer and administration tools
    • In-database analytics capabilities
    • Ease of interaction with existing BI tools & ETL tools
    • High availability without hardware redundancy
    • Optimizer and execution engine
    • Advanced analytics: predictive, geospatial, sentiment, etc
    • Semi structured and structured data analytics in one environment
  • Improved query performance by 51 – 100% with HPE 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.

Case Study: Medium Enterprise Energy & Utilities Company

Introduction

This case study of a medium enterprise energy & utilities company is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“Fast and reliable database system.”

“We use HPE Vertica for loading data from different sources, data normalization, ad hoc queries, and SAP Business Objects reports.”

“We would recommend Vertica because it is fast, easy to install, scale easily, aggressive data compression, and high availability.”

“Using the Vertica, we were able to increase on a large scale the speed of Data Warehouses queries.”

Challenges

  • Is using HPE Vertica for the following:
    • Enterprise Data Warehouse optimization
  • Replaced the following vendor with HPE Vertica:
    • Oracle

Use Case

  • Currently manages 6 – 20 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tool in their environment with HPE Vertica:
    • ETL: Pentaho Data Integrator

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Simultaneous loading and querying
    • Superior compression
    • High availability without hardware redundancy
  • Improved query performance by 101 – 500% with HPE Vertica.

Case Study: Large Enterprise Computer Services Company

Introduction

This case study of a large enterprise computer services company is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“We are using HPE Vertica to improve query performance in analytic processes and to integrate it with several applications using Hadoop.”

“I will recommend it to my co-workers so that they can implement solutions that require critical analytics solutions and solid data warehouse improvement.”

“With HPE Vertica, the query performance of the data warehouse process has been increased successfully. There are several requirements in the company focused on analytics process that will be using HPE Vertica as part of new infrastructures.”

“HPE Vertica has a very good performance and some advantages over their competitors. Also, it has good integrations with BigData.”

Challenges

  • Uses HPE Vertica for the following:
    • Customer analytics
    • Loyalty analytics
    • Predictive analytics
    • Campaign management
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with HPE Vertica:
    • HPE Vertica is our primary solution

Use Case

  • Currently manages 6 – 20 TB of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with HPE Vertica:
    • ETL: Hadoop
    • ETL : Informatica – Power Center
    • BI: Qlikview/QlikSense
  • Uses the following Advanced Analytics and/or Replication tools in their environment with HPE Vertica:
    • I don’t know if we’re using advanced analytics or not.

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Simultaneous loading and querying
    • Database designer and administration tools
    • Ease of interaction with existing BI tools & ETL tools

Case Study: Small Business Real Estate Company

Introduction

This case study of a small business real estate company is based on a February 2016 survey of HPE Vertica customers by TechValidate, a 3rd-party research service. The profiled company asked to have their name blinded to protect their confidentiality.

“We use HPE Vertica as our data warehouse for reporting and visualization.”

“We would recommend Vertica because it runs effortlessly for workloads that would not practically run on MySQL. Easy to use SQL interface.”

“Vertica cuts development time for visualization apps by eliminating the complexity of high availability MySQL or NoSQL solutions. We get all the speed and power we need with the familiarity of a full-featured SQL implementation and industry-standard APIs.”

Challenges

  • Is using HPE Vertica for the following:
    • Enterprise Data Warehouse optimization
  • Replaced the following vendors with HPE Vertica:
    • Amazon Redshift
    • MySQL

Use Case

  • Currently manages 6TB or less of data with HPE Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tool in their environment with HPE Vertica:
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tool in their environment with HPE Vertica:
    • Tungsten Replicator

Results

  • The following are the most valuable HPE Vertica capabilities:
    • Massive scalability on industry-standard hardware
    • Standard SQL interface
    • Superior compression
    • In-database analytics capabilities
    • Ease of interaction with existing BI tools & ETL tools
  • Improved query performance by 101 – 500% with HPE Vertica.

Case Study: JSC ATS

Introduction

This case study of JSC ATS is based on a February 2016 survey of Vertica customers by TechValidate, a 3rd-party research service.

“With Vertica, we were able to make a lean jump to new levels of DWH usage. Now it’s usable for our clients and inner customers.”

Challenges

  • Is using Vertica for the following:
    • Enterprise Data Warehouse optimization
  • Replaced the following vendor with Vertica:
    • Oracle

Use Case

  • Currently manages 6 – 20 TB of data with Vertica.
  • Uses the following Business Intelligence (BI), Visualization and/or ETL tool in their environment with Vertica:
    • BI: Tableau
  • Uses the following Advanced Analytics and/or Replication tool in their environment with Vertica:
    • Advanced Analytics: SAS

Results

  • The following are the most valuable Vertica capabilities:
    • Standard SQL interface
    • Simultaneous loading and querying
    • Workload management
  • Improved query performance by 101 – 500% with Vertica.