Introducing Oracle Data Integrator 12c - Upstate New York ...

1 Copyright 2014, Oracle and/or its affiliates. All rights reserved. 1 Oracle data Integrator (ODI) Sandrine Riley - Product Management, Oracle Oracle data Integration Moving data to Transform Business Copyright 2014, Oracle and/or its affiliates. All rights reserved. 2 Agenda Oracle data Integration Overview Oracle data Integrator Overview and New Features in 12c Oracle data Integrator @ Oracle Oracle Warehouse Builder Migration Utility Copyright 2014, Oracle and/or its affiliates. All rights reserved. 3 Oracle data Integration Overview Copyright 2014, Oracle and/or its affiliates. All rights reserved. 4 data Integration Trends Changing Requirements Fuel Market Growth Projected to grow to $ by 2017 Big data is the new normal Application data now lives in the cloud and in a multitude of disparate environments Conventional ETL tools are struggling to meet performance demands Integrating across applications 1.

2 Gartner data Integration Magic Quadrant 2013 Report Copyright 2014, Oracle and/or its affiliates. All rights reserved. 5 New Requirements for data Integration Integrated and High Productivity Tooling High Performance, High Availability Cloud Ready Any data Latency, Real-time Any data , Any Source Copyright 2014, Oracle and/or its affiliates. All rights reserved. 6 Oracle data Integration 12c Delivering Real-Time Integration for Big data and Cloud Future Ready Extreme Performance Fast Time to Value Oracle data Integrator Oracle GoldenGate Oracle Enterprise data Quality Oracle data Service Integrator Big data Database Apps Cloud Copyright 2014, Oracle and/or its affiliates. All rights reserved. 7 Oracle data Integrator Customers Copyright 2014, Oracle and/or its affiliates.

3 All rights reserved. 8 Enterprise-Class data Integration with Oracle Customers Achieve Tangible Results Real-time enterprise data warehouse Reduced time by 30% to 40% to integrate a new data source into its warehouse 50% reduction in time-to-market for new services data warehousing for operations from restocking to marketing Millions of $ savings from shared data services Improved data handling speed by more than 20% with automation Increased data loading process by 25% to 30% Reliable bulk data movement and transformation for high volume, transactions Copyright 2014, Oracle and/or its affiliates. All rights reserved. 9 Used Oracle data Integrator along with Oracle GoldenGate for real-time data integration Feeds from HP NonStop, SQL Server, and Oracle databases into ODS Achieved higher application performance, reduced complexity and cost Accelerated time to market by 50% for applications supporting financial advisors Faster Time to Solution Raymond James Centralized Operational data Store for Application Services Copyright 2014, Oracle and/or its affiliates.

4 All rights reserved. 10 Used to take ~3-9 months for data to propagate from operational systems into the data Warehouse Uses Oracle data Integrator and Oracle GoldenGate to move data within a matter of days and reduced storage required from 150 GB to 20 GB Credit Risk Officers and Credit Risk Modelers do not need to perform individual checks and reconciliations Faster Time to Solution Royal Bank of Scotland Reducing Risk with Better data Copyright 2014, Oracle and/or its affiliates. All rights reserved. 11 Travel and Rest Easy Working behind the scenes to make the world a better place, one journey at a the technology behind Sabre Holdings technology includes Oracle data Integrator . Wherever your Freight is Moving When you work with Schneider National, Oracle data Integrator is part of the foundation to making sure your freight moves and arrives at its destination on time.

5 Life Well Planned With Oracle data Integrator , Raymond James Financial ensures your portfolio is tended to with the upmost care and in tune with today s rapid pace of life. Painting the Town Or just your home - PPG Industries, known for its paints sold at Lowes and Menards, uses Oracle data Integrator to manage all of its customer transactions. Save a Bundle They do the work, you do the saving uses Oracle data Integrator to help you save money by checking over half a million prices each week and catering your experience on their website to you. Fun Facts About Oracle data Integrator Copyright 2014, Oracle and/or its affiliates. All rights reserved. 12 Oracle data Integrator 12c New Features Copyright 2014, Oracle and/or its affiliates.

6 All rights reserved. 13 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 Oracle data Integrator High Performance E-LT Declarative Design CEP data Services Extensible Knowledge Modules Capable of Integrating Structured & Unstructured data Big data Database Apps Cloud Oracle data Integrator Bulk data Processing and data Transformation Copyright 2014, Oracle and/or its affiliates. All rights reserved. 14 Improved developer productivity through declarative flow based mapping Extreme performance through parallelism and low session overheads Enterprise solutions through support for big data analytics and Oracle BI Applications New Features in Oracle data Integrator 12c Copyright 2014, Oracle and/or its affiliates.

7 All rights reserved. 15 Conventional ETL Architecture Extract Load Transform Next Generation Architecture E-LT Load Transform Transform Extract Leverages set-based transformations Improves performance for loading, no middle tier and no network hop Takes advantage of existing hardware and software infrastructure ETL versus E-LT Flexible Optimized Architecture Copyright 2014, Oracle and/or its affiliates. All rights reserved. 16 Easy and universal for designing simple to complex mappings Robust and Reusable: Create mappings once for any physical design Quick to define and refactor maps, high degree of automation Extensible model for any data integration mechanism Benefits Significantly reduces the learning curve Shortens implementation times Simpler maintenance ODI Declarative Design Define How: Knowledge Modules Define What You Want Automatically Generate Dataflow 1 2 Declarative Design Improved Productivity for Faster Time to Solution Copyright 2014, Oracle and/or its affiliates.

8 All rights reserved. 17 Flow Based Design Increased Productivity through Enhanced Design Declarative, flow based mapping to easily design complex transformation logic combined with technology specific out of the box knowledge modules Component reusability to capture shared logic throughout mappings (sources, targets and transformations) Step by step debugger with complete user control / access to uncommitted data , and defining break points Copyright 2014, Oracle and/or its affiliates. All rights reserved. 18 A mapping can contain multiple targets Any component can map result to multiple downstream components Split component allows to split input logically based on expressions Multiple Target Load Improving Productivity through Multiple data Flows Copyright 2014, Oracle and/or its affiliates.

9 All rights reserved. 19 Capture common logic (sources, targets, transformations) Reuse logic in mappings Improving Productivity through Component Reuse Reusable Mappings Copyright 2014, Oracle and/or its affiliates. All rights reserved. 20 In-session parallelism Parallel task execution Narrower execution windows Low overhead session during execution When executing repeated scenarios, restarting sessions Efficient micro-batch loading for real time data Reduced logging, better cache utilization reduce network traffic for entire IT system Total Execution Time TRADITIONAL SrcSet1 SrcSet2 SrcSet3 Integration Total Execution Time ODI Integration SrcSet1 SrcSet2 SrcSet3 Faster Loads for Improved Run-time Caching Performance Optimizations Copyright 2014, Oracle and/or its affiliates.

10 All rights reserved. 21 Reverse Engineer Metadata Journalize (CDC) Load from Source to Staging Check Constraint Integrate, Transform data Service Pluggable Knowledge Modules Architecture Sample Out-of-the-Box Knowledge Modules (100+) Sources Teradata Hadoop IBM DB2 SQL Server SAP ABAP JMS Sybase NoSQL Oracle Solutions Oracle Spatial GoldenGate Oracle Utilities Siebel CRM Oracle DBLINK Oracle Web Services E-Business Suite Oracle Merge Simpler Design and Shorter Implementation Time Knowledge Modules Copyright 2014, Oracle and/or its affiliates. All rights reserved. 22 KEY ARCHITECTURE BENEFITS: Faster development and simpler maintenance using templates Easy to extend and add new best practices Enforces predictability and reduces cost of ownership Knowledge Modules Integrated, High Productivity Reusable Modules Copyright 2014, Oracle and/or its affiliates.