Maximize Cost Savings While Improving Visibility Into Lines of Business

1. Maximize Cost Savings While Improving Visibility Into Lines of Business Wendy Tam, CDC Product Marketing Manager wendytam@ca.ibm.com

2. Agenda • Current challenges • Case Studies • Recap

3. Current challenges • Organizations are feeling the pressure of economic uncertainty • Clients feeling pressure to achieve more with less • Need for up-to-date insight into operations, finance, and sales processes is even more important • Increased demand for information leads to shrinking batch windows

4. Information Server Log-Based Change Data Capture Monitoring and Configuration Database Web Services Message Queue InfoSphere Information Server TCP/IP DB2, Oracle, SQL Server, Sybase, Informix Database Logs Source Engine Target Engine Business Process Flat files

5. Case Study 1:Increased Reporting Costs with Data Growth Challenge • Large insurance company has a hosted z/OS environment supporting financial billing reconciliation reporting requirements (MIPS based pricing model). • Projected data volume growth (approximated at 10% monthly) increasing resource consumption and total report generation costs. • Reports generated nightly. Line of business looking for on-request/ad hoc reporting capability. • Personal Lines Division looking for more agility and cost reduction opportunities for report generation. Sample Daily MIPS profile 700

6. Solution DB2 z/OS • Lower impact data movement by implementing InfoSphere Change Data Capture resulted in a more cost effective query and reporting solution. • Optimize resource consumption and mainframe costs related to data access and report processing. • Synchronize changed data in real-time to a reporting ODS.

7. Benefits • Agency Auto able to leverage technology they already owned (DB/Hardware) to build reporting Operational Data Store (ODS) infrastructure. • Improved visibility to Line of Business by supporting on request query and reporting capability. • Cost savings of approximately $100K per month. • Return on software investment pay back in 3 months. • Significant optimization in MIPS utilization, freeing re-allocation to other workloads. Sample Daily MIPS profile 50

8. Case Study 2: Shrinking Batch Windows and E-business Integration • Large petroleum company requires data extraction/delivery from System i based ERP application to support multiple lines of business (EDW, E-Business) while maintaining core application availability, system performance and reducing length of nightly batch window. • Data volume growth of 30% yearly increasing nightly data extraction run time and processor utilization threatens their ability to complete EDW processing for the start of the next business day. • File locking during data extraction (post batch job completion) prevented application availability to business users for extended periods of time. • Development costs of hand coding • Performance degradation caused by database triggers used to capture changed operational data for e-business integration • Termination of batch job due to trigger errors during nightly financial batch processing

9. Solution Implemented IBM InfoSphere Change Data Capture to provide continuous, low impact access and delivery of critical ERP data to EDW and E-Business line of business users. JD. Edwards ERP System i EDW Remote Sites Stage Polling Mechanism ESB Partners

10. Benefits • Elimination of file locking during data extraction enabling continuous availability of critical business applications. • Data extraction optimization which reduced the nightly batch window from 15 hours to 6 hours. • Development costs reduced by simplifying or eliminating several custom developed batch processes. • A scalable data extraction architecture allowing IT to maintain EDW service levels with yearly data volume growth. • A solution that worked within their existing IT infrastructure and that was applied to solve multiple business problems. “The InfoSphere technology represented such clearly superior solutions that we elected to proceed with aggressive implementations and then move on to other projects” . - Senior Staff Systems Architect

11. Solution – Change Data Capture (CDC) What is CDC? • Means of detecting and distributing changes from data sources across the enterprise What is IBM InfoSphere Change Data Capture • Log-based CDC solution from IBM that’s part of an overall information management portfolio • Used for: • Active data warehousing • Application consolidations/migrations • Shrinking batch window processing • SOA initiatives • Operational/Live Reporting

12. To Recap Maximize cost savings, reduce risk and increase business visibility with InfoSphere Change Data Capture: • large petroleum company reduced their batch window by over 50% and leveraged the same solution in another project • An insurance company benefits from a monthly cost savings of $100K, pay back period of 3 months Are you making use of the CDC advantage?

13. Get the most out of the CDC advantage Visit our webpage: http://www-01.ibm.com/software/data/infosphere/change-data-capture/ Information Management Library: http://www-01.ibm.com/software/data/integration/en_US/sw-library/ For more information, please contact your IBM Sales Rep

14. Thank You