Optim Enterprise Data Management Featuring IBM Optim Unlocking

® Optim™ Enterprise Data Management Featuring IBM® Optim™ Unlocking the Business Value of Information for Competitive Advantage Bryan Vogus bvogus@us. ibm. com (818) 551 -0366 05 November 2020 © 2008 IBM Corporation

Optim ® What is EDM? § A concept referring to the ability of an organization to precisely define, easily integrate and effectively retrieve data for both internal applications and external communications § EDM as an essential business requirement has emerged as a priority for many organizations. § The goal and objective is confidence and trust in data as the glue that hold business strategy together 52% of users don’t have confidence 59% of managers miss information 42% of managers use wrong information in their information they should have used at least once a week AIIM Survey, 2007 © 2008 IBM Corporation

Optim ® Enterprise Data Management (EDM) Four Areas of Impact within Your Organization § Business Value § Information Governance § Simplification of Infrastructure § Business Continuity © 2008 IBM Corporation

Optim ® EDM Solution Requirements – The Four Pillars 1 Enterprise Architecture 2 Complete

Optim Custom Amdocs SAP JDEdwards People. Soft Oracle Siebel OEM/ISV SAP Custom Archive Amdocs Subset & Mask JDEdwards Production Environments People. Soft Non Production Environments OEM/ISV Enterprise Architecture Oracle Siebel 1 ® Data Growth, Data Privacy, Test Data Management, Application Upgrades, Application Retirement Optim ™ Oracle SQL Server Sybase Informix Windows XP/2000 DB 2 LUW Solaris NAS SAN HP/UX ATA XML Linux CAS IMS AIX Optical VSAM OS/390 Adabas Z/OS DB 2 z/OS Teradata i-Series Tape Single, scalable, Enterprise Data Management Solution © 2008 IBM Corporation

Optim 2 ® Complete Business Object § Represents application data record – payment, invoice, customer – Referentially-intact subset of data across related tables and applications; includes metadata § Provides “historical reference snapshot” of business activity § Federated extract support across enterprise data stores © 2008 IBM Corporation

Optim 3 ® Extract, Store and Restore § Extract: Identify and extract business objects across multiple related applications, databases and platforms § Store: Store immutable business objects independent of infrastructure – any hardware device or platform § Restore: Migrate or restore business objects seamlessly from any database, application or version to any other database, application or version. Choose precisely which items to restore – a single transaction record, a year’s worth of data, or any other range or parameter you specify. © 2008 IBM Corporation

Optim 3 ® Extract, Store and Restore Federated Extract Complete Business Object Captures End to End Business Process EBiz Financials / Oracle Custom Inventory Management / DB 2 Siebel / Oracle © 2008 IBM Corporation

Optim 3 ® Extract, Store and Restore Store in Any Environment Current Data Active Historical Online Archive Offline Archive 1 -2 years 3 -4 years 5 -6 years 7+ years Archive Production Database Archive Reporting Database Arc h Restore ive De fin Non DBMS Retention Platform Offline Retention Platform ATA File Server EMC Centera IBM RS 550 HDS CD Tape Optical itio n s Compresse d Archives © 2008 IBM Corporation

Optim 3 ® Extract, Store and Restore to Any Environment Legacy HRIS on DB 2/z Archives Archive Reference Data Legacy Application Data Historica l Data Optim d loa Re ERP HCM App on DB 2 LUW Replacement Application Data Reporting Data Universal Access to Data ODBC / JDBC XML Report Writer © 2008 IBM Corporation

Optim 4 ® Universal Access § Native application access ERP Applications – Familiar screens and processes Additional Options ODBC / JDBC XML SQL Excel Access § Application independent access – Industry standard methods: SQL, ODBC/JDBC, XML – Portals – Report writers: Crystal Reports, Cognos, Business Objects, Discoverer, Actuate – Desktop formats: Excel, CSV, MS Access Optim – Database formats Access Any Record, Anytime, Anywhere! © 2008 IBM Corporation

Optim ® EDM Solves Enterprise Challenges § Data Growth § Upgrades & Migrations §

Optim ® Optim™ Enterprise Opportunity Solution Focus Upgrades & Migrations Application Retirement Data Privacy Custom Z-DB 2 Custom - UDB Custom - Oracle Custom – SQL SVR Custom- Sybase Custom – Informix e. Business Enterprise 1 Siebel Amdocs SAP Planned 2008 Introduction Retention & Discovery Test Data Management Heterogeneous Environments Product Focus Data Growth © 2008 IBM Corporation

Optim ® Key customer needs for an Optim solution Issue Pain Optim Solution Data Growth 40% per year Data Growth Data Privacy Fines Data Privacy Compliance Failed Audit Data Privacy Business Continuity Unexpected Downtime Data Growth Accelerating Demand 50% Performance hits Data Growth High Cost Surprise Hardware Purchases Data Growth Project Implementation Missed Deadlines Test Data Mgmt © 2008 IBM Corporation

Optim ® Compliance: My old way vs. Archive Architecture Business / Technology Risk My old way Not system of record Value Props 1. Compliance 2. EDM 3. ILM 4. Performance 5. Savings 6. … Production Extract Data Warehouse Y 07, 06, 05, 04, 03, 02, 01 Y 06 Production Y 05 Y 06 Archive Architecture Data Privacy Y 05 Y 07 Restored Appl/Data Y 01 Y 02 Restored Appl/Data Y 02 Delete on expiration Y 01 Y 07 No policy No way Data Growth Tier-1 $$$ Archive Y 05 Tier-2 $$ Archive Y. . Tier-3 $ Storage © 2008 IBM Corporation

Optim ® Optim™ Delivers Business Value “ “ Our backup times are 20% faster… Mid. American Energy Optim has already yielded the returns we were looking for, and we have just touched. Discovery the tip of the – iceberg… Saving up to $720 k/year in storage deferrals “ It has been a very positive experience working with [IBM] to maximize our performance AEP and Archived lower our 1 TCO… billion rows of data “ “ We can easily comply with data privacy regulations without incurring additional RCIcosts… Banque The bottom line is that Optim's archiving capabilities will help us exceed our SLAs… Chiquita © 2008 IBM Corporation