Symphony Advanced Media

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.