Infosphere Optim Case Study GCS Profile Founded in

Infosphere Optim Case Study • GCS Profile – Founded in 2004 in New Jersey – Locations in New Jersey, Mexico City, and soon in Denver, CO. – Optim certified partner since 2005 – IBM certified Optim partner since 2007

Valeant Pharmaceutical Case Study • Customer challenge: – Valeant Pharmaceutical was growing rapidly through acquisition. – company inheriting a variety of applications that did not align with its internal portfolio of applications. – As the newly acquired businesses were integrated, the acquired legacy applications and their infrastructure footprints became extraneous and a drain on the IT teams. – Business required access to the historical data for analysis and audits, both internal and regulatory. – Various OS platforms and databases. – Valeant required a solution that was agnostic to these variations and enterprise-grade.

Valeant Pharmaceutical Case Study • Why Infosphere Optim? – Create an enterprise level Archive Repository that would become a part of their acquisition strategy. – A repeatable process for a long term application retirement factory. – Must be able to archive SAP data. – Easy for internal staff to learn and run with beyond our initial project. – GCS ability to provide managed services support on demand.

Valeant Pharmaceutical Case Study • Initial archiving scope included: – Peoplesoft HRMS on SQL SVR database – PRMS ERP on DB 2 database – QAD ERP on Progress database – SAP ECC 6. 0 on Oracle database – Creation of data models for future queries

Valeant Pharmaceutical Case Study • GCS challenge was convincing Valeant that archiving SAP was possible. • SAP archiving solution components: – Optim for Transparent tables – IIS Datastage SAP PAK for Pooled and Clustered tables – IIS Datastage Data Architect to generate ERDs – GCS Optim and SAP expertise

GCS Archiving Solution for the SAP database SAP PAK Extraction of Cluster and Pool Tables using SAP PAK Plug-In SAP Database Server Install Information Server Datastage and SAP PAK Plug-in Archive SAP Transparent Tables directly Use Data. Stage Data Architect To create SAP ERD Models For ongoing Query development over Archive Repository SQL SVR Staging Database Uncompressed Pool and Cluster Tables Archive SAP Pool and Cluster tables Optim Engine v. 11. 3 Open Data Manager Windows SQL SVR DB Alternate Optim DB Server Optim Database Server Compressed. AF Tables

Valeant Pharmaceutical Case Study Questions?