slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897) PowerPoint Presentation
Download Presentation
Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897)

Loading in 2 Seconds...

play fullscreen
1 / 39

Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897) - PowerPoint PPT Presentation


  • 230 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Powering Solutions for Oracle Applications with Oracle GoldenGate (CON8897)' - madison


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
powering solutions for oracle applications with oracle goldengate con8897
Powering Solutions for Oracle Applications with Oracle GoldenGate(CON8897)

Ryan Lolli – GoldenGate Product ManagerJustin Hyde – Oracle BI Apps Director

David Felcey – Coherence Product Manager

slide3

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.

agenda
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
oracle data integration solutions
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
fun facts about oracle goldengate
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

oracle data integration dis
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

delivering real time integration for big data and cloud

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

slide10

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

oracle goldengate
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

oracle enterprise data quality
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

oracle data services integrator
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

oracle goldengate1
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

e business suite operational reporting
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.
e business suite operational reporting1
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

introducing e business suite platform migrations
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.
e business suite platform migration what is triple o
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
e business suite platform migration the solution
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
ebs platform migrations solution overview
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

introducing the bi apps sds architecture
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.

bi apps dw etl architecture sds
BI Apps DW ETL Architecture + SDS

Optimized ETL for local SDS

Optimized for Incremental ETL

Generated based on a customers BI Apps deployment

oracle coherence in memory data grid
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.

challenge shared database
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

coherence hotcache
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

benefits1
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
join the data integration community
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