Customer stories

professional services industry logoSymphony Advanced Media

Symphony Advanced Media offers solutions and services in advertising strategy, advertising performance, and consumer and shopper insights

professional services industry logo

Outcomes

  • Simultaneous loading and querying
  • Ease of interaction with existing BI tools & ETL tools
  • Improved query performance by 51% – 100% with OpenText
  • Reduced TCO by 1%-25% with OpenText 

Challenge

Using OpenText 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 OpenText:

  • OpenText is our primary solution

 

Details

Use case

Currently manages 6TB or less of data with OpenText.

Uses the following Business Intelligence (BI), Visualization and/or ETL tools in their environment with OpenText:

  • 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 OpenText:

  • Replication: Home Grown (describe)
  • Advanced Analytics: Home grown (describe in other)

Results

The following are the most valuable OpenText 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 OpenText.

Improved query performance by 51 – 100% with OpenText.

I would personally recommend Vertica (now OpenText) 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.

Harman Support
DBA Engineer, Symphony Advanced Media

About Symphony Advanced Media

professional services industry logo

Symphony Advanced Media offers solutions and services in advertising strategy, advertising performance, and consumer and shopper insights