Case Study: REDPHARMA achieves cost-effective, high-performance AWS analytics with OpenText Vertica in Eon Mode

Vertica in Eon Mode delivers cost-effective, stable, and high performance analytics platform on AWS

REDPHARMA’s REDDATA service aggregates and anonymizes transactional data from 4,000+ pharmacies to measure campaign ROI and deliver market insights to pharmacies and pharmaceutical partners. As data volumes grew, Tableau dashboards slowed and the small analytics team needed a way to separate BI from heavy data processing, move to AWS, and control infrastructure costs while still demonstrating clear value to prospective customers.

REDDATA implemented Vertica in Eon Mode on AWS, using optimized columnar storage, a single flattened-table architecture, and automated cloud tooling to separate compute and storage and quickly scale resources. The result is a cost‑effective, stable, high-performance analytics platform that integrates with Tableau, simplifies management and backups, enables faster, in-depth dashboards, supports exploration of machine‑learning use cases, and frees the team to focus on advanced analytics and business growth.

REDPHARMA

David Nicholson-jones

Analytics Architect