Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897)

2. Powering Solutions for Oracle Applications with Oracle GoldenGate(CON8897) Ryan Lolli – GoldenGate Product ManagerJustin Hyde – Oracle BI Apps Director David Felcey – Coherence Product Manager

3. The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

4. Agenda • Oracle GoldenGate Overview • GoldenGate for E-Business Reporting and Migration Solutions • GoldenGate for Oracle Business Intelligence SDS Architecture • GoldenGate for Oracle Coherence Reporting • Q & A

5. Oracle GoldenGateOverview

6. Oracle Data Integration Solutions • Thousands of customers including Fortune 500 companies, representing Financial Services, Communications, Healthcare, Public Sector, Retail, Utilities industries • 4 of top 5 largest commercial banks • 3 of top 3 busiest ATM networks • 5 of top 5 financial data services companies • 5 of top 5 telecommunications providers • 3 of top 5 largest food & drug stores

7. Fun Facts About Oracle GoldenGate That’s the Magic of Macy’s Shopping at the worlds largest retails and your credit card transactions are moved in real-time to data centers around the world, before being approved, using Oracle GoldenGate (Retail Decision) Good TV. Better TV. DirecTV. If you call DIrecTV customer service, your call data will move to their data warehouse via Oracle GoldenGate, so the rep can provide you with personalized recommendations and promotions. Say it with Flowers Ordering from 1800-Flowers, Oracle GoldenGate will move your order to their reporting systems to help process and track your order seamlessly No Charge ATM Fees 3 of the 3 busiest ATM Networks use Oracle GoldenGate for Continuous Availability. Get Sick in Pittsburgh If you get a health check at UPMC, the clinical applications that doctors use are supported by Oracle GoldenGate to enable high-availability

8. Oracle Data Integration (DIS) Breadth Enables Leverage and Agility Data Quality Data Integration Match/Merge Profiling Standardization Heterogeneous Virtualization Big Data ETL/E-LT Replication

9. Real-time replication; optimized for Database 12c and Oracle Exadata End-to-end integrated with simplified deployment Unified tooling for both structured data sources and Hadoop / NoSQL Flexible deployment on-premise or in the Cloud for heterogeneous systems Expanded support for 3rd party systems and Oracle Applications in real-time data integration and continuous availability solutions Oracle Data Integration 12c Delivering Real-Time Integration for Big Data and Cloud Cloud Oracle Data Integrator Apps Oracle GoldenGate Oracle Enterprise Data Quality Database Oracle Data Service Integrator Big Data

10. Oracle Data IntegratorBulk Data Processing and Data Transformation Oracle Data Integrator • Certified for leading technologies to deliver fast time to value • High-performance, low cost of ownership E-LT architecture • Lightweight deployment • Flexible, easy to enrich functionality Cloud High Performance E-LT Apps Declarative Design Database Extensible Knowledge Modules CEP Data Services Big Data Capable of Integrating Structured & Unstructured Data

11. Oracle GoldenGate Real-time Data Integration Oracle GoldenGate • High-performance, low-impact real-time data integration and replication • Timely data for improved business insight • Continuous availability for 24/7 operation Cloud Log-based Change Data Capture and Delivery Apps Active-Active Replication Heterogeneous Source and Targets Database Reliability and Transaction Integrity Big Data Java Integration, Real-time Events

12. Oracle Enterprise Data Quality Data Quality for Customer and Product Data Oracle Enterprise Data Quality • Improves data accuracy, usability and ‘fitness for purpose • Unified interface for ease-of-use, lower TCO • Depth of capability in multiple data domains reduces project risk Cloud Profile, Explore, Audit Apps Parse, Standardize, Cleanse Match, Merge, Enrich Database Governance Big Data Case Management

13. Oracle Data Services Integrator Data Federation and Virtualization Oracle Data Services Integrator • Easily develop data services and ad-hoc queries without infrastructure changes • Open and standards based—SOA, Web Services, Java, Service Data Object Cloud Federated Data Services Apps Data Virtualization Integrates with Oracle SOA Database Bidirectional Reads & Writes Big Data Integrates with Oracle Business Analytics

14. Oracle GoldenGate Low-Impact, Real-Time Data Integration & Transactional Replication Zero Downtime Upgrade & Migration New DB/HW/OS/APP Fully Active Distributed DB High Availability/ Disaster Recovery Legacy Systems Log-based Changed Data Query & Report Offloading Reporting Database Data Warehouse Real-time BI, Operational Reporting, MDM Oracle & Non-OracleDatabase(s) Data Integrator Global Data Centers ODS Data Synchronization within the Enterprise Message Bus Message Bus Event Driven Architecture, SOA

15. GoldenGate for E-Business Reporting and Migration Solutions

16. E-Business Suite Operational Reporting ‘Operational Reporting’ – Ability to off-load reporting functions or heavy read operations to a real-time replica copy from a source production database. Tables required for reporting must be self identified, as every E-Business Suite customer’s reporting needs are unique. Key Benefits • Resource Off-Loading – Rather than all users having to execute reports and business-critical transactions against a single system, organizations can allocate operations to systems optimized for a particular role. • Optimization – Transactional and reporting systems operate more efficiently if they are tuned specifically for the expected usage. • Full Use of Reporting Instance – Reporting needs that include the creation of temporary tables or other processes to prepare data for reporting can be run on the replica without impacting business-critical systems.

17. E-Business Suite Operational Reporting LAN / WAN / Internet Over TCP/IP Reporting Server Application Server Other Reports EBS EBS Trail Files Trail Files Capture Pump Delivery Source Primary Reporting Instance Uni-directional

18. Introducing E-Business Suite Platform Migrations ‘Platform Migration’ – The process of moving an existing production system to a new set of hardware that may or may not include a new operating system, new database platform/version, and new storage technology. This does not include upgrading the E-Business Suite application environment to a new version. Key Benefits • Minimal Downtime – Migration of large Oracle database environments with minimal downtime to business operations. • Move to Latest Technology – Take advantage of latest technologies such as Oracle Exadata to maximize system performance. Stay current on the latest hardware and software versions. • Utilizes Oracle ACS Triple-O Solution – Solution was co-developed with Oracle ACS to utilize proven migration methods and techniques.

19. E-Business Suite Platform MigrationWhat is Triple-O? • Oracle to Oracle Database Migrations “Online” Online = GoldenGate • Developed by ACS to Migrate Large High Volume Databases • Complete Database Reorganization • Take Advantage of New Database Features • Conversion Speeds of 2TB/h Possible • Handled Databases > 10TB with Redo 24h > 2TB • Over 3000 Databases Migrated

20. E-Business Suite Platform MigrationThe Solution • Exclusively controlled and managed by Oracle ACS • A reusable and repeatable solution • Built-in flexibility to handle all EBS customer environments • Allows customers to move to new operating system, hardware, storage, and database version • GoldenGate provides near zero downtime migrations • Triple-O solves moving very large databases with high transaction volumes

21. EBS Platform Migrations – Solution Overview LAN / WAN / Internet Over TCP/IP EBS EBS Trail Files Trail Files Capture Pump Delivery 11g 10g Source Primary New Target Uni-directional

22. EBS Platform Migrations – Solution Overview EBS 11g New Target

23. GoldenGate for Oracle Business Intelligence SDS Architecture

24. Introducing the BI Apps SDS Architecture ‘Source Dependent Data Store (SDS)’ - a separate schema on the BI Apps DW database that is a replication of the source OLTP systems tables + deletes + additional optimizations for incremental ETL GoldenGate – a service on both database systems that performs: • On the source database system - continuous asynchronous change data capture 'CDC' at a low level in the database, then compresses and ships the changed data across the network to… • On the target database system - receives the changed data from one or more source systems and loads them into the target database (into the SDS schemas, 1 per source).   Note: GoldenGate is optimized for replication, not complex ETL, so ODI is absolutely required.

25. BI Apps DW ETL Architecture

26. BI Apps DW ETL Architecture + SDS Optimized ETL for local SDS Optimized for Incremental ETL Generated based on a customers BI Apps deployment

27. Benefits

28. Oracle GoldenGate For Coherence

29. Oracle Coherence In-Memory Data Grid Application Infrastructure for Scalability • Java application that stores key/value pairs in memory as caches or Maps • Coherence JVM’s communicate to provide fast, consistent and reliable access to data • It distributes cache data across JVM’s – and servers • Enables scalable and very fast processing inside caches – like stored procedures • Provides real-time eventing, query, and map/reduce aggregations • Back-end data source offload • Dynamically scalable platform with seamless failover and recovery for data and processing End Users Application Servers Application Objects Mainframes, Databases, etc.

30. Challenge: Shared Database 3rd PartyApplication • Coherence applications backed by a relational database can suffer from stale caches due to 3rd party database updates. • Existing solutions: • Cache Expiry • Inefficient—expires fresh data • Refresh Ahead • Inefficient pull model refreshes fresh data • Possible high latency Coherence Application Coherence Application Coherence Coherence Application Read / Write Read / Write Database

31. Coherence “HotCache” 3rd PartyApplication • Built on TopLink, it integrates with GoldenGate to push database changes into Coherence cache • Maps data changes to affected objects using JPA metadata • Zero to minimal change to Coherence application • Efficient push model—only stale data is processed • Low latency—push happens on change Coherence Application Coherence Application Coherence Coherence Application Read / Write Read / Write GoldenGate Adapter GoldenGate Database

32. Benefits Coherence HotCache • Propagates database changes to corresponding objects in Coherence cache leveraging: • GoldenGate for database change capture • TopLink Grid to map database changes to cached objects • Can be added to ANY existing Coherence application • Efficient ‘update on change’ operation • Adapter configuration completely declarative—XML only config supported • Improve application data consistency

33. Resources and Q&A

34. Questions & Answers

35. Join the Data Integration Community LinkedIn“Oracle Data Integration” Oracle’s Data Integration blogblogs.oracle.com/dataintegration Twittertwitter.com/ORCLGoldenGate Facebookfacebook.com/OracleDataIntegration Oracle GoldenGate YouTube channelyoutube.com/oraclegoldengate Oracle Technology Network Oracle’s Public Help Forumhttp://forums.oracle.com/forums/forum.jspa?forumID=860&start=0 Oracle.com/goto/dataintegration

36. Oracle OpenWorld – Key DIS Sessions Oracle GoldenGate

37. Graphic Section Divider