sabrecasestudywebcast_may2013final2

7/30/2019 Sabrecasestudywebcast_may2013final2

1/31

Copyright 2013, Oracle and/or its affiliates. All rights reserved.1

Sabre Holdings Case Study:Accelerating Innovation withOracle Data Integration

May 8

th

, 2013


2/31


Speakers

Irem Radzik, Director of Product Marketing,

Integration

Sandrine Riley, Product Manager, Data Integ

Amjad Saeed, Development Manager for

Enterprise Data & BI, Sabre Holdings


3/31


Agenda

Data Integration for Operational Data Warehousing

Introduction to Oracle Data Integration products Sabre Holdings Case Study: Data Warehousing with Ora

GoldenGate and Oracle Data Integrator

Summary

Q&A


4/31


Data Integration, Data Warehousing, InIt Starts with the Right Plumbing

Pervasive,Timely Data

Access

Complete,Trusted

Insight

EmpoweredEmployees

Innov


5/31Copyright 2013, Oracle and/or its affiliates. All rights reserved.5

Data Integration for Operational Data Wa

Reduce Data Latency

Fast Loading and Transformation

Minimize Batch, Maximize Availability

Ensure Trusted Data


6/31Copyright 2013, Oracle and/or its affiliates. All rights reserved.6

Advantages of Oracle Data Integration

Complete &

Integrated

HighPerformance

Low TCO

Fast Time toValue

Flexible

Proven

OracleData

Integration


7/31


Modernization MDM Big Data

Oracle Data IntegrationComplete Offering for Enterprise Data Integration

Complapproa

integra

Maximlower T

reliabil

Certifie

technotime to

Oracle Data Integrator

Oracle GoldenGate

Oracle Enterprise Data Quality

Oracle Data Service Integrator

OLTP

Applications

Legacy

Unstructured

SynchronizCustom BI


8/31


Real-time changedata capture optionbuilt-in for OracleData Integrator

OracleGoldenGate

Embedded &certified with majorOracle and non-Oracle technologies

Oracle DataIntegrator Out-of-the

time integrinsert dataflows into Data Integ

OracleDat

IntegratedEnd-to-End Solution for Data Integration


9/31


EMP DEPT

EMP DEPT

Batch Feeds, IncrementalUpdates and in-DB

transformations

Non-Invasive Real Time Transaction Feeds

tx4 tx2 tx1tx3

Oracle DataIntegrator

OracleGoldenGate

Heterogeneous Sources

Non-invasive capture from heterogeneous sources

No mid-tier. Set-based transformations use database Mini-batch loading throughout the day or bulk loading nightly

Top Performance, Integrated, Red Stack

Runs directly on Oracle Exadata

Heterogen


10/31


High Performance

E-LT architecture for fastest data loading with no

network hop Fast set-based processing leveraging database engine

Moving 1000s of transactions per second, only

committed changed data by reading transaction logs

Data cleansing, profiling, standardization millions of

records/hour

Seamless fit & integration between products supports

speed


11/31


ODI and Exadata Real World ExampleA Disruptive Improvement in Performance

A complex branch o

tax allocation proces

minutes during quart

Exadata and ODI (Eis able to execute th

42Xfaster(7mins 20

50

100

150

200

250

300

350

ODI on Exadata

Conventional ETL

Jobexec

utiontimeinminut

es

5hrs 11mins

7min 20sec

42XIMPROVEMENT


12/31


Flexible & Extensible

Heterogeneous sources and targets

Any data, any latency

Flexible transformation architecture

Extensible to work easily with emerging technologies

Support for multiple use cases and audiences


13/31


Log-basedChanged Data

Data Integrator

New DB/

HW/OS/APP

Fully Active

Distributed

DB

Reporting

Database

DataWarehouse

ODS

Zero

Quer

Data S

Rea

Even

High

Message

Bus

Oracle & Non-OracleDatabase(s)

Message Bus

Legacy Systems

Global

Data

Centers

Flexibility without ComplexityOracle GoldenGate Use Cases


14/31


Fast Time to ValueSimple, Easy-to-Use, Certified

Fast project setup, design and delivery

Simple deployment with fewer hardware

Easy management and monitoring

Embedded in, or certified for major Oracle and

non-Oracle Technologies

Real-time data integration deployments in

weeks, not months


15/31


Low Total Cost of Ownership

Less hardware & energy costs without middle tier

Less overhead on source systems and network withreal-time data Integration

Less labor needed for deploying, managing, and

monitoring solution

Faster, simpler to increase scalability

Less integration overhead to integrate with other

technologies such as SOA, MDM


16/31


Proven, Reliable SolutionCustomers Achieve Tangible Results

Redtime

Profiles and analyzesseveralmillion datarecords in one day

vs. one week prior tosolution

Increased dataloading and query

performance by30%.

Achieved 100%faster ETL speed forfeeding transactional

data to EnterpriseData Warehouse on

Oracle Exadata

50% reduction in time-to-market for new

services

500% performanceincrease & 80%

decrease inunnecessary branch

visits

Milliofro

Improved customerinformation accuracy by20%, to nearly 100%

accuracy


17/31


Sabre data integration technologiesAmjad SaeedManager DevelopmentEnterprise Data & BI

Introduction


18/31


Introduction

World leader in the travel marketplace

Merchandises and retails travel products

Provides distribution and technology solutions for the trav

industry

Supports travelers, travel agents, corporations and travel

suppliersConnecting people with the world's greatest travel possib

18

Enterprise Data and BI Team


19/31


Enterprise Data and BI Team

Maximize Sabres Return on Information by dractionable intelligence, and value for our cus

our growing data and information assets Do More With More DataMission Provide tools and techniques that enable our u

better insight of their business and customers Be competitive and streamline developmen

time to market for new solutions Improve the quality, system availability & relia

data and products we offer Be the best DW and Business Intelligence team

Goals

Deliver pervasive Business Intelligence solutiocustomers faster, better, cheaper, smarterVision

19

Enterprise Travel Data Warehouse


20/31


Enterprise Travel Data Warehouse

The Enterprise Travel Data Warehouse (ETDW) captures and storefrom Sabre systems for driving insights for both Sabre customers and

Enterprise

20

We serve all 4 divisions of Sabre Ho


21/31


We serve all 4 divisions of Sabre Ho

21

Dash-boards

Challenges We Faced


22/31


Challenges We Faced

Need of BI solutions on very complex data sets

Consolidation of data that provide right-time market insights

Providing a scalable and cost effective technology platform Ability to develop and maintain the solutions with a global workforce

Providing a flexible solution allowing new products and enhancements to be

quickly

Speed of deployment with diverse source technologies

Ability to utilize tool for both loading of data into Sabres data warehouse an

scheduling of outbound data reports for customer

Standard set of interfaces that allows reuse of the code replacing outdated

source solutions

Provide consistent data results throughout all data warehouse solutions

21

Where We Started


23/31


Where We Started

History of data integration in ETDWAnalysis and research performed on the transactional datab

7 data sources in batch mode

30 scheduled application in CRON

33 analytical and BI users

< 3TB of storage

Data gaps due to operational issue

Non-standard ETL applications

Limited reusable code

Complexity during functionality enhancements

2323

ETDW/BI Access Layer


24/31


Operational Systems

PNR

VCR

Traveler

OPs

ETDW

PNR VCR

Traveler OPsEnterprise Data Warehouse (EDW)

Operational / Historical Depth

ETDW/BI Access Layer

Extract,

T

ransform,

&

Load(ETL)

Streaming Data

24

Hitting the target Above and beyo


25/31


Hitting the target Above and beyo

Eliminated Complexity

Standardized development for global development teams

Reduced time to market for solutions and enhancements by 40 Gained ability to initialize new customers on our products

Consolidated diverse sources with high data volumes

Streamlined support and maintenance operations

Achieved real time view in the execution of the integration proc

Has the ability to manage the DW & BI performance on deman

Allowed enforcement of corporate IT best practices

125Million transactions/day through ODI

48Million inserts/updates/day through GoldenGate

25

ETDW Growth Matrix


26/31


ETDW Growth Matrix

36

11

16

26

2

6

10

14

18

22

26

30

2004 2006 2008 2010 2012

StorageinTB

Data Growth

5200

5380

5550

5650

33

55

83

9

25

50

75

100

125

150

175

200

2004 2006 2008 20

Numberof

application

Application Growth

30

254

650

0

200

400

600

800

1000

2004 2006 2008 20

Users

User Growth

7

15

24

30

57

5

15

25

35

45

55

2004 2006 2008 2010 2012

DataSource

s

ETDW Data Sources

26

Plans ahead


27/31


Plans ahead

Increase data assets in ETDW

Decrease latency on our batch type sources

Drive better data quality with tighter data integration

Create trigger alerts to source teams during operational issu

Integrate data sources in ODI and GoldenGate

Test data management using ODI

Data replication to our Big Data Solution

Integration between ETDW and Big Data Solution

Increase operational coverage for high availability applicatio

27


28/31


Thank You

28

O l D t I t ti f O ti l D


29/31


Oracle Data Integration for Operational DMeeting Key Requirements

Reduce Data Latency

Fast Loading and Transformation

Minimize Batch, Maximize Availability

Real-time data capture an

to-the minute information

Log-based change data ca

continuous data feeds

Ensure reliability, high perf

scalability, fast data loadin

Ensure Trusted DataBuilt-in data quality and pr

data

Join the Data Integration Comm nit


30/31


Join the Data Integration Community

Twitter

twitter.com/ORCLGoldenGate

Facebookfacebook.com/OracleDataIntegration

Oracle GoldenGate YouTube channelyoutube.com/oraclegoldengate

Oracle.com/goto/datain

LinkedIn

Oracle Data Integratio

Oracles Data Integratblogs.oracle.com/datai

Fusion Middleware Inoracle.com/goto/fmwin


31/31


Q&A

sabrecasestudywebcast_may2013final2

Documents