Oracle Travel and Entertainment Collection Pack

1
OracleTravel and EntertainmentCollection Pack
Alan Knitowski Drew McMorrow Jeff Phillips Cindy
Satero
2
Background

• Oracle aquired E-Travel, Inc.
• March 1999
• Integration of product suite underway
• Oracle ERP and OADW
• TE collection pack

3
Oracle eTravel
Travel Suppliers
Traveler
Travel Agent
GDS
Without eTravel
eTravel
With eTravel
eTravel plus eTLink
With eTravel eTLink
4
Data Warehouse JustificationWhat Gets Measured
Gets Managed

• Manage corporate travel policies
• How well are my employees complying with travel
  policy? What is the cost impact of
  non-compliance?
• Manage suppliers
• Should I renegotiate my contract with Hertz based
  on the amount Im spending on Hertz vs. all other
  rental car suppliers?
• Manage performance
• Is a particular salesperson spending more in
  travel and entertainment than appropriate? What
  is the ratio of customer visits per business
  trip?

5
Oracle DW Architecture Oracle Warehouse Builder
Any Source
Any Access
Any Data
Operational Data Sources
Oracle Discoverer
Oracle Express
Collection Packs
Other Tools Applications
External Data Sources
6
TE Collection Pack
Oracle eTravel OLTP
OADW
Travel Star Schema
Data Mart

• Pre-generated warehouse schema
• Generic for any enterprise
• Extensible using Oracle Warehouse Builder (OADW)
• Out-of-the-box data warehouse
• Two step implementation press Install, press
  Start

7
Collection Pack Definition
8
Star Schema Dimensions
Geog.
Purpose
Time
Fact
Mode
Org.
9
Future Research

• Travel Intelligence
• Finalize design specification
• Code collection pack
• Define pre-built reports and workbooks
• Enhance product
• Reservations API
• Geographic Information Systems