Oracle Data Integrator Enterprise Edition - Sales Presentation-2009-01
-
Upload
sarah-mendoza -
Category
Documents
-
view
510 -
download
2
Transcript of Oracle Data Integrator Enterprise Edition - Sales Presentation-2009-01
<Insert Picture Here>
Oracle Data Integration A Technical Overview with Emphasis on ODI
Oracle Data Integration
Oracle’s Data Integration Strategy Pervasive Data Integration
• Embed Data Integration with Oracle Database• Integrated, Optimized and Best for Oracle Database• Easiest Path to Get External Information into the Oracle Database
• Provide Comprehensive Standalone Data Integration• Comprehensive Heterogeneous Technology Foundation• Integrated Runtime, Data Management Tools and Administration• Best of Breed: Significant Architectural Differentiators vs. Competitors• “Hot Pluggable”: Broad Range of Sources & Packaged Applications
• Pre-Integrate with Packaged Solutions for Oracle Portfolio• Make Data Integration Pervasive with Lower Cost & Complexity
• Oracle SOA Suite, including BPEL PM and ESB Messaging Technologies• Oracle’s Business Intelligence Server and Hyperion OLAP Tools• Oracle’s Business Intelligence Applications for all modules and domains• Oracle|Hyperion Planning, Budgeting, Financial Consolidation & Reporting• Oracle Fusion Applications for ERP, CRM, & Vertical Applications• Oracle Composite Applications & Application Integration Architecture• Oracle’s Industry-specific Vertical Applications• Oracle’s Master Data Management & Fusion Application Pillars
Where Does Data Integration Fit?Essential Ingredient for Information Agility
SOA
• Data Services• Information
services• Process
Integration• Event driven
data integration• Governance
and Impact Analysis
Business Intelligence
• Data Integration for BI applications
• Event driven BI• Heterogeneous Data
Access• Information-based
analytics• Report to Source
Data LineageData Warehousing
• Extract, Transform, Load• Data Migration, Bulk Data• Data Quality, Profiling
Data Integration
Use Cases for Oracle Data IntegratorUnified Data Integration Platform for Enterprise Projects
Data Integration• Bulk-load historical data to new application• Synchronize new and old applications• Complex transformations, CDC • Ensure database-level consistency across
applications bidirectional
BI & Data Warehouse• Real-time Data Warehouse for BI• Populate Warehouse with High Performance ODI• Aggregates and aligns data for operational
analytics, performance management, etc
Modernization• Mainframe / iSeries sources to Oracle RAC• Re-architect legacy batch processing to SOA and
ODI-EE• Unification of structured and unstructured data
Data Migrations & Consolidation• Upgrade Applications or Migrate to New Schema• Single-time Bulk load and/or keep in Sync with
ongoing translation, delivery of data.• Applications merge support
SOA Initiatives• Establish Messaging Architecture for Integration• Incorporate Efficient Bulk Data Processing with ODI• Providing data access, transformation etc. as
services within SOA
Master Data Management• Create Single View of the Truth in real time • Aggregating multiple operational sources• Synchronize Data with ODI-EE• Supports master data stores, publishes master data
changes to all consumers
Conventional Data Integration BI & DW Projects
Modernization Initiatives Migrations / Consolidation
SOA Projects Master Data Management
SOA SuiteSOA Suite
ESB
ODI Integrated
Oracle Fusion ERP ApplicationsOracle Fusion ERP Applications
Other Apps … (+more)Other Apps … (+more)Business IntelligenceBusiness Intelligence
Enterprise Performance Management and FinancialsEnterprise Performance Management and Financials
ODI-Enterprise Edition at OraclePervasive Data Integration in the Oracle Ecosystem
Fusion MDM
ODIEmbedded
Pre-builtContent
BPEL
ODI Integrated
BAM & CEP
ODIEmbedded
BIEE Suite
ODI Integrated
BI AppsODI
Embedded
Pre-builtContent
Agile PLMODI
Embedded
Pre-builtContent
RetekODI
Embedded
Pre-builtContent
HFM
ODIEmbedded
Planning
ODIEmbedded
Spend Analyzer
ODIEmbedded
MDM/DRM
ODI Integrated
Essbase
ODI Integrated
Governance& Risk
ODIEmbedded
Demantra+ CRM
ODIEmbedded
Fusion Pillar Replication
ODIEmbedded
Pre-builtContent
Fusion CDH
ODIEmbedded
Pre-builtContent
Fusion AIA
ODIEmbedded
Pre-builtContent
Fusion BI
ODIEmbedded
Pre-builtContent
Fusion Financials
ODIEmbedded
Pre-builtContent
Fusion Migration
ODIEmbedded
Pre-builtContent
Pre-builtContent
Pre-builtContent
Pre-builtContent
Pre-builtContent
Oracle Database (Standard)Oracle Database (Standard) Oracle Database (Enterprise Edition & Exadata)Oracle Database (Enterprise Edition & Exadata)OWB
EmbeddedOWB Enterprise
EmbeddedODI Integrated ODI Integrated
Key Data Integration Products• Comprehensive Integration• ELT/ETL for Bulk Data• Data Delivery Services• Process Orchestration• Service Bus
• Human Workflow• Data Federation• Replication & Migration• Data Governance• Data Grid
• ELT/ETL for any DB• Changed Data Capture• Native SQL Code Gen• Declarative Design
• ELT for Oracle DB• Database Modeling• PL/SQL Code Gen• Flow-based Design
• Business Data / Metadata• Statistical Analysis
• Time Series Reporting• Integrated Data Quality
• Cleansing & Parsing• De-duplication
• High Performance• Integrated w/ODI
New
Data Integration Package FeaturesFeatures ODI Suite ($70k) ODI-EE ($23k) DB (free ETL)
Core ETL features for loading the Oracle DB
ELT/ETL for Oracle DB Targets Y Y Y
Non-Oracle Sources Y Y ODBC/Gateways
Slowly Changing Dimensions (type 1) Y Y Y
Inline Constraint Checking Y Y Y
Database Partitioning Support Y Y Y
OLAP (Oracle + Essbase) Y Y Oracle OLAP only
Built-in Scheduler Y Y Oracle DBMS only
Advanced features for enterprise ETL use cases
ELT/ETL for non-Oracle DB Targets Y Y
Changed Data Capture Y Y
Web Services (API & Src/Trgt) Y Y
Data Lineage / Impact Analysis Y Y
Declarative Design Environment Y Y
Slowly Changing Dimensions (2 & 3) Y Y
Pre-built Integration with OBI-EE & EPM Y Y
Pre-built Integration with Fusion AIA Y Y
Advanced features for enterprise information management and data distribution
Human Workflow (BPEL PM) Y
Process Orchestration & Service Bus Y
Data Relationship Mgmt / MDM Y
Coherence Data Grid Y
WebLogic Suite (B2B, Biz Rules, etc.) Y
Core ODI-EE Differentiators
Move and transform data. Mixed sources and targets.
BENEFITS KEY DIFFERENTIATED FEATURES
1. Performance >>> Heterogeneous “E-LT”2. Flexibility >>> Event-Driven Platform3. Productivity >>> Declarative Design4. Open >>> 100% Java and SOA Native5. Hot-Pluggable >>> Knowledge Modules
ODI-EE Value PropositionAgile Data Integration
11
1212
Differentiator: E-LT ArchitectureHigh Performance
Conventional ETL Architecture
Extract LoadTransform
Next Generation Architecture
“E-LT”LoadExtract
Transform Transform
Conventional: Separate ETL Server• Proprietary ETL Engine• Poor Performance• High Costs for Separate Standalone Server• IBM & Informatica’s approach
Oracle: No New Servers• Lower Cost: Leverage Compute Resources &
Partition Workload efficiently• Efficient: Exploits Database Optimizer• Fast: Exploits Native Bulk Load & Other
Database Interfaces• Scalable: Scales as you add Processors to
Source or TargetBenefits
• Optimal Performance & Scalability• Better Hardware Leverage• Easier to Manage & Lower Cost
E-LT Architecture with Data IntegratorComprehensive, Lightweight Data Integration
• Key Architecture Benefits: 100% Java, Open APIs, very fast E-LT• Embeddable Java Agent consumes very little CPU or RAM• E-LT Architecture uses DBMS CPUs, not the Application CPUs• Open APIs, Open Metadata, Open XML Knowledge Modules
DA
B
File C
C$_0
C$_1
LKM
LKM
IKM
I$ E$ (Errors)
CKMIKM
RKM
JKM
Check-Load TransformExtract-Load
ODI Agent
ERPApplication
Business Intelligence& Data Warehouse
ODI Agent may be deployed in any part of the architecture
1414
JournalizeRead from CDC
Source
LoadFrom Sources to
Staging
CheckConstraints before
Load
IntegrateTransform and Move
to Targets
ServiceExpose Data and Transformation
Services
ReverseEngineer Metadata
• Leverage Database Optimizations: Native SQL; Native Functions; Native Loads; Native Journaling / CDC
• Tailor to an organization’s existing best practices• Ease administration work• Reduce cost of ownership
Reverse
Journalize
Load
Check
IntegrateServices
Pluggable Knowledge Modules Architecture
CDC
Sources
Staging Tables
Error Tables
Target Tables
WS
WS W
S
SAP/R3
Siebel
Log Miner
DB2 Journals
SQL Server Triggers
Oracle DBLink
DB2 Exp/Imp
JMS Queues Check MS Excel
Check Sybase
Oracle SQL*Loader
TPump/ Multiload
Type II SCD
Oracle Merge
Siebel EIM Schema
Oracle Web Services
DB2 Web Services
Sample out-of-the-box Knowledge Modules
Benefits
Differentiator: Knowledge Modules“Hot-Pluggable,” Modular, Extensible
Change Data Capture (CDC) allows for real time data to be available for any type of data integration solution. Change Data Capture is accomplished by capturing just the changed records and not the full data set, dramatically reducing time and resources over the life of the data integration solution.
Key Use Case: Realtime Data Warehouse(continuously refreshed throughout the day)
15
Differentiator: Changed Data CaptureEvent-Driven Framework for Realtime Data Integration
1616
Oracle: One-Click CDC• Publish and Subscribe
Framework for Changed Data Capture (CDC)
• Ensures “read” transaction integrity across multiple tables
• Out-of-box Log Mining and Triggers (platform dependent)
• Extensible to any capture technique
Steps to Easy CDC1. Design or generate Mappings2. Select Journalized Data Only3. Start Journals
CDC
Easy Steps to CDCSimple Framework for Business Intelligence & Warehousing
17
Differentiator: Flexible Error WorkflowError Recycling, Native Integration with BPEL & Human Workflow
BPEL Process Manager
Target
StaticCheck Integration
Process
Errors
Sales
Flow Check During Integration
HumanWorkflow
Sources
Errors
CorrectionsConventional: Rigid/Non-
Existent Workflow• Proprietary workflow baked-in• No workflow /
3rd party solution• Weak integration,
non-standard
Oracle: Open, Flexible Workflow• Flexible Data Correction Workflow
• Static Constraint Checking and Validation
• Flow-based Constraint Checking and Validation
• Error Recycling • Standards-Based Process Flow
• BPEL Process Manager / BPEL4People
• Reuse Standardized Error Handling Procedures
• Integrated with Human Workflow• Manage Long Running Transactions• Manage Complex Approval and
Overriding Patterns
Error Recycling
181818
• Data Integrity Firewall• Auditing, cleansing and
recycling
1. Declare constraints at table level2. Design mappings and check
flow integrity3. Audit, cleanse or recycle
rejected records
Message Id Name CityDuplicated Record 001 John Doe New YorkDuplicated Record 022 John Doe BostonInvalid City Reference 230 Albert Fresh Maris
Differentiator: Data QualityInline E-LT Data Integrity Framework
Differentiator: Dimensional ModelingWarehouse Builder Enterprise ETL Modeling Framework
• One editor for:
• Creation of objects
• Configuration for multiple databases
• Validation• DDL Code
generation• Deployment to
multiple databases
• Data viewing
2020
Differentiator: Native SOA ArchitectureSOA and ODI for Evolution to Modern IT Architecture
Conventional: Monolithic/Legacy C++• Decade(s) old heavy-weight architectures• SOA is a “bolt-on” – not integral• Java is a “wrapper” – not native
Oracle: Lightweight & 100% Java• Lightweight Java Runtime
• <36MB memory, runs on any platform
• Data Flow Steps accessible as Web Services• Out-of-box data access services• Published to Service Registry• Easy to Test & Deploy
• Data Transformation Services• Deployable as SQL-Oriented
Transforms (Structured Sources)• Or as XSL-T Transforms
(Unstructured Sources)
• Easy SOA Integration• Invoke Data Flow as part of ESB• Invoke Workflow via SOA for
Error Management & Escalation
ODI AgentData Flow Conductor
Sources
CRM
LegacyERP
Custom Database
Files / XML
ESB
Targets
Custom DB
Apps
Data Warehouse
Files / XML
ESB
Staging Area
Any DB
Data
Data Access Service
Batch DataService
Transformation Service
SOA ClientsBusiness Intelligence | Web 2.0 Mashups etc.
ODI for SOA Use Cases
22
Oracle SOA Suite and Data IntegratorAdd Comprehensive Data Service Capabilities to SOA
• Oracle SOA Suite - BPEL• BPEL Process Manager for Business
Process Orchestration & Workflow• Standards-based Composite Apps
and Integration Processes• Strategic SOA Technology
• Oracle Data Integrator• Efficient bulk data processing as part
of Business Process• Interact via Data Services and
Transformation Services• Unified modeling, monitoring,
metadata, error mgmt, auditing
• Example use cases• SOA Rules/Event driven BI Loads• Bulk Data Transformation (any2any)• Unified Data Steward Workflow• Data Virtualization (with caching)• XML/EDI Large File Handling• ERP Migration, Replication / Loading
Bulk Data Processing
App
File
DB
Legacy
ODI for Transforming Large Payloads
23
Data Integrator
Oracle BPEL PM or ESB
3
ODI Invoke
Reference
Reference
ProductSuppliersOrder DB
2
Transform
<zyx>
45
7
1. Large File arrives, detected by BPEL File Adapter
2. Execution Starts (BPEL/ ESB) – and a step for transforming a large document payload occurs
3. Pass XML payload, by reference, to ODI
8
<yxz>
Reference
Shared Container/JVM
SharedMetadata
Repository
1
6
Shared SOA Server
4. ODI loads payload5. ODI transforms payload6. ODI sends payload
wherever instructed7. ODI notifies BPEL/ESB
that job is complete8. Core BPEL/ESB
processing completes
ProductSuppliers
Any DB
Records A
Transform
Records B
ODI for Loading Bulk Data
24
Data Integrator
Oracle BPEL PM or ESB
3
ODI Invoke
Reference
Reference
2
4
7 8
<yxz>
Reference
Shared Container/JVM
SharedMetadata
Repository
1
Shared SOA Server
1. File arrives, detected by BPEL File Adapter
2. Execution Starts (BPEL/ ESB) – some demand for XML to DB load occurs
3. Pass XML payload, by reference, to ODI
5 <zyx>
6
4. ODI requests payload5. ODI inserts payload to DB6. ODI transforms payload7. ODI notifies BPEL/ESB
that job is complete8. Core BPEL/ESB
processing completes
DB Server
25
Data Integrator
Oracle BPEL PM or ESB1
3
ODI Invoke
Instruction
Confirmation
2
Transform
1. An event occurs which prompts a data load
2. Execution starts within BPEL/ ESB process
3. Instruction to start ODI 4. ODI extracts & loads data
a) Some errors w/in batchb) Notification to BPEL
Human Workflow engine
c) Repair & approvals process
d) Repairs are committede) ODI looks for repaired
data when “Recycle” option is on
5. ODI transforms the data6. ODI confirms job complete7. BPEL/ESB process
continues any additional process execution steps
Event
Shared Container/JVM
SharedMetadata
Repository
ODI Loads a BI Warehouse (with Error Hospital Human Workflow)
Records A
Transform
4
Records B
Any DB
a
b
HumanWorkflow
d
e
5
6
7
BusinessIntelligence
c
Shared SOA Server
DW ServerDB Server
ERPApp 1
UI
App
Data
ODI for SOA-based ERP Integration
26
Data Integrator
Oracle BPEL PM or ESB
ODI Invoke
Instruction
Confirmation
Transform
Shared Container/JVM
ERPApp 2
UI
App
Data
XML XML
DDL DDL
SharedCanonicalID XREFLookups
1. A business process for Migration (initial bulk data load) or Replication (ongoing synch) is invoked
2. BPEL/ESB sends instruction to ODI
3. ODI performs E-LTa) ODI creates
Unique ID for new ERP data objects
b) ODI updates Unique ID for existing objects
4. ODI confirms job5. BPEL/ESB begins
processing ERP business transactionsc) BPEL/ESB
leverage same Unique IDs for canonical XML
6. All SOA and ETL jobs keep business data aligned with Unique IDs
3
2
ab
c
4
5
Messaging and bulk data may leverage the same unique object IDs – thereby ensuring
uniform ERP data objects(eg: PK123 = Pkxyz)
1event
Data Integration Suite
What is ODI Suite?Extend SOA with Data Services
• Oracle Data Integration Suite
• Build reusable data integration and transformation services.
• Cleanse data and ensure data quality
• One truth for metadata of data structures
• SOA uses XML, ODI Suite uses native data integration
28
What is ODI Suite?Best of Breed SOA Middleware
• Packaged Components• Oracle Data Integrator Enterprise Edition (ODI-EE)
• Data Relationship Management (DRM - Hyperion MDM)
• BPEL Process Manager (w/Human Workflow)
• Oracle Service Bus
• WebLogic Suite (Coherence, B2B, Rules…)
• Optional Components• Oracle Data Quality (ODQ) & Oracle Data Profiling (ODP)
• Oracle Data Service Integrator (ODSI)
• Adapters (ERP, B2B, Unstructured, Mainframe, etc)
29
Data IntegrationThe Challenge of IntegrationD
ATA
SOU
RC
ESC
LIEN
TS
Need: Information
how and when you
want itHave: Data
In Disparate Sources
30
Oracle or 3rd Party: Applications | Analytics | Identity | SOA Platforms | Data Grid | Content Management | Search
Desired Use Cases
DataIntegration
DataGovernance
DataWarehousing
DataMigration
Client Applications
PackagedApplications
Master DataManagement
BusinessIntelligence
ContentManagement
DataFederation
DataReplication
SOAPlatforms
ActivityMonitoring
Data Connectivity
Core Data Integration Foundation
Leverage a Comprehensive Foundation
Usage Footprint (Supported Use Case)
DataIntegration
DataGovernance
DataWarehousing
DataMigration
Client Applications
PackagedApplications
Master DataManagement
BusinessIntelligence
ContentManagement
DataFederation
DataReplication
SOAPlatforms
ActivityMonitoring
Oracle or 3rd Party: Applications | Analytics | Identity | SOA Platforms | Data Grid | Content Management | Search
Deploy with the Flexibility of ServicesSOA Data Services Strategy
SOA Data Services
Fusion Applications
ActivityMonitoring
BusinessIntelligence
OracleApplications
MDMApplications
SOAPlatforms
Data Movement & Delivery
Data Integration Foundation
Data Integration Designer
Data ConnectivityTEC
HN
ICA
LPL
ATF
OR
MFU
NC
TIO
NA
L SE
RVI
CES
BatchData
Services
DataAccess
Services
DataEvent
Services
DataQuality
Services
DataXForm
Services
SOARegistryServices
SOAMetadataServices
MasterData
Services
DA
TASO
UR
CES
CLI
ENTS
32
Oracle or 3rd Party: Applications | Analytics | Identity | SOA Platforms | Data Grid | Content Management | Search
MDMApplications
SOAPlatforms
OracleApplications
BusinessIntelligence
ActivityMonitoring
Fusion Applications
Data Distribution & Delivery Services
Data Connectivity
Data Integration Foundation
Metadata Services
Data Quality Core
Models Relationships Lineage Object Cache
Relational Databases Non-Relational DBs Various File Formats XML Data
Packaged Applications Standard Msg Formats Message Queues Semi-Structured Data
Bulk Data API Data Quality API
Java SDO
Data Replication
Event-Driven (CDC)
Master Data Core
Exchange APIs
Data Virtualization
Matching/Dedupe’s
Cleanse/Parse
Cluster Analysis
Lifecycle Mgmt
Data Reconciliation
Data Classification
Oracle Data Integration Suite
Realtime Data Core
Data Caching
Query Federation
Realtime Query
Process-Oriented
Message-Oriented
Bulk Data CoreBulk Acquisition
Trickle Feeds
Complex Transforms
Change Data Capture
Event-Based
Integrity Constraints
Oracle or 3rd Party: Applications | Analytics | Identity | SOA Platforms | Data Grid | Content Management | Search
MDMApplications
SOAPlatforms
OracleApplications
BusinessIntelligence
ActivityMonitoring
Fusion Applications
Data Distribution & Delivery Services
Data Connectivity
Data Integration Foundation
Metadata Services
Data Quality Core
Models Relationships Lineage Object Cache
Relational Databases Non-Relational DBs Various File Formats XML Data
Packaged Applications Standard Msg Formats Message Queues Semi-Structured Data
Bulk Data API Data Virtualization
Java SDO
Data Replication
Event-Driven (CDC)
Master Data Core
Exchange APIs
Data Quality API
Matching/Dedupe’s
Cleanse/Parse
Cluster Analysis
Lifecycle Mgmt
Data Reconciliation
Data Classification
Oracle or 3rd Party: Applications | Analytics | Identity | SOA Platforms | Data Grid
Best-of-Breed Data Integration Platform
Realtime Data Core
Data Caching
Query Federation
Realtime Query
Process-Oriented
Message-Oriented
Bulk Data CoreBulk Acquisition
Trickle Feeds
Complex Transforms
Change Data Capture
Event-Based
Integrity Constraints
Data Quality(From Trillium Joint
Development)
Knowledge Modules for XML, Flat Knowledge Modules for XML, Flat File, Relational, Basic AppsFile, Relational, Basic Apps
Use-Case Centric Metadata ManagementUse-Case Centric Metadata Management
Core ETL SOA/Java APIsCore ETL SOA/Java APIs
Master DataMaster Data(From Hyperion MDM)(From Hyperion MDM)
BEA DSP APIsBEA DSP APIs
Licensed Adapters for Legacy & Specialized Apps
Stellent Content AdaptersB2B Adapters
StandardStandard
Option
Key:BPEL + ESBBPEL + ESB
ETL & CDC CoreETL & CDC Core(From Oracle Data (From Oracle Data
Integrator)Integrator)
Coherence Data Grid
Data Services(From BEA ALDSP)
Oracle Database
WarehouseWarehouseBuilderBuilder
Cleansing
CDC
ServiceBus Cloud
35
SOA DBAdapter
(ESB or BPEL
hosted)
DataServiceServers
BIEE
DW
BPEL
ODIODSI(BEADSP)
Data BulkData
Service
DataEvent
Service
DataCanonical
DataServices
BULK DATA
ODIInvoke.wsdl ODI SKM.wsdlDSP Object.wsdl
Async CDCSync
HYSL
BAM/CEP Coherence
Weblogic Server
Service Bus
High Level Reference ArchitectureFor a Comprehensive Data Services Strategy
Key:API Calls
Data Flows
Oracle Data Quality
Business Intelligence
Events and Grid
Client Applications
PackagedApplications
Master DataManagement
BusinessIntelligence
ContentManagement
SOAPlatforms
ActivityMonitoring
36
ApplicationUsers
BusinessAnalysts
CorporateLibrarians
DataStewards
Officers ProcessArchitects
Enterprise Architects
DBAs & Developers
Master Data Applications
Foundation Data Services
Foundation Data Stores
Enterprise Data Sources
Application Users & SMEs• Non-technical functional experts as end-usersBusiness Analysts• Understand and drive core IT requirementsCorporate Librarian• Applies knowledge catalogs to registered dataData Stewards• Maintain enterprise data integrity
Process Architects• Builds and deploys executable business processesOfficers• Policy Officer, Audit Officer, Security OfficerEnterprise & Data Architects• Define, design and assure software implementationsDatabase Administrators & Developers• Produce new data management capabilities and services
ERP Applications
PRIMARY FUNCTIONAL APPLICATION USAGE
DATA SERVICES ROLES
Data Services PersonnelSpecialist Roles Require Enterprise-class Platforms and Tools
BusinessProcess
MasterData
Workflow
ProcessArchitect
DataSteward
SOAArchitect
DataArchitect
SOABus
DataIntegration
Biz Rules
Quality
Data Grid
Apps…BI
ODISuiteBusiness
User
DataTaxonomist
Oracle Real Application Clusters
DBA
Data Services PersonnelKey Roles for a Complete Solution are at Every Tier
Oracle Oracle Data Data
IntegratorIntegrator &&
Oracle Oracle Data Data
QualityQuality
Oracle Oracle Data Data
IntegratorIntegrator &&
Oracle Oracle Data Data
QualityQuality
ODI Suite MDM in ActionClosed-loop Master Data Management with DRM
OperationalOperational
E-Business SuiteE-Business Suite
JD EdwardsJD Edwards
HRHR
LegacyLegacy
SAPSAP
Siebel CRMSiebel CRM
People SoftPeople Soft
Hyperion Data Relationship ManagementHyperion Data Relationship Management
Hierarchy Governance
Master Hierarchies and Versions
Cost Centers
Entities Accounts Org Struct Geography
AnalyticAnalytic
Financial AppsFinancial Apps
BudgetingBudgeting
Planning & Planning & ForecastingForecasting
AnalyticsAnalytics
Key PerformanceKey Performance
Query / ReportingQuery / Reporting
Enterprise Enterprise ReportingReporting
38
DataSteward
DataTaxonomist Business
UserBusiness
User
Oracle Data Integration SuiteCompetitive Summary for Data Services
Feature Oracle IBM Info Server Informatica Business
Objects EIMPerformance ODI Beats in
transforms (ELT)ODI Beats in
transforms (ELT)ODI Beats in
transforms (ELT)
Data Services (SOA) X XData Movement & Delivery
Process/Message Not Included
No Process/ Message Integr. X
Metadata Management ServicesMaster Data Management Services
Hierarchy Mgmt Not Included X X
Data Integration DesignerScheduling, Workflow, Error Mgmt
Data Quality & Profiling
Object Cache / Data Grid X X X
Packaged Adapters and Connectivity
39
ODI-EE for Oracle
41
Focus on Oracle BIEE Suite PlusUnify Data Integration with Business Intelligence
• Integrated with Oracle BIEE Plus
• Support for relational, R-OLAP, OLAP sources & targets
• Report-to-source lineage• Drill-in from a Report • Get query, DW schema, source
tables, transforms• Gain confidence in analytics
• Unified infrastructure• Unified metadata & lineage • Integrated Data Quality• Unified data access, • Common administration &
monitoring• Integrated scheduling & security • Common auditing & tracing• Common error handling
Oracle BIEE Suite PlusOracle BIEE Suite Plus
Oracle EBS
PeopleSoft
SAP/R3Other
Sources
Data Warehouse
CDC
MessageQueues
Enterprise Data Warehouse
Design & Drill
Data Flow
Bulk and Real-Time Data Processing
Oracle Data Integration SuiteOracle Data Integration Suite
Metadata Lineage
Data Distribution & Delivery APIs
Bulk/Trickle Loading
Changed DataCapture
MasterData
Data Quality& Profiling
ODI Knowledge Module Framework
Information Assets
Oracle Business Intelligence Server
Common Enterprise Information Model
InteractiveDashboards
Ad hocAnalysis
ProactiveAlerts
MicrosoftOffice
Reporting& Publishing
• Oracle RAC• Teradata• Netezza…etc
Report to Source Data LineageExplore Lineage from Target Columns to Source Columns
Focus on OBI Analytic Applications Overview
• Pre-Built BI Analytic Applications• Pre-built Metrics, 5000+ Dashboards, Data
Warehouse 350+ Star Schema• Implementation Time: 3-4 Weeks• Works with EBS, PSFT, SAP, SEBL, JD-
Edwards Sources• Biggest Savings: Pre-built ETL
• Faster & Lower Cost to Build & Maintain ETLs
• Knowledge Module Architecture Enables Efficient Development of Packaged ETL
• Reduce Complexity and Size of Code• Reuse DW Creation, Update, Load Times• Value-add Modules (e.g. SOX)
• Extensible by Customers & System Integrators
Oracle BI Analytic ApplicationsOracle BI Analytic Applications
Oracle BI Server and Semantic Layer
Oracle EBS
People Soft
SAP/R3Other
Sources
Data Warehouse
CDCMessage Queues
Analytics Data Warehouse
Information Assets
Sales MKtingOrder Mgt
Supply Chain FinanceHRContact
Center
Data Flow
Bulk and Real-Time Data Processing
Oracle Data IntegratorOracle Data Integrator
Metadata Repository
ODI Knowledge ODI Knowledge Modules for BI Modules for BI
Analytic Analytic ApplicationsApplications
Bulk Transform.
Changed Data
Capture
Data Integrity
Data Quality
ODI Connectivity Framework
Pre-Built ODI Interfaces and Pre-Built ODI Interfaces and Transformation Packages for Transformation Packages for
Analytic ApplicationsAnalytic Applications
Weeks or monthsWeeks or months
Pre-built BI AppsPre-built BI Apps
ETL ETL MappingMapping
DW DesignDW Design
TrainingTraining
Years or quartersYears or quarters
Metrics & Metrics & DashbrdsDashbrds
Build from ScratchBuild from Scratch
50%50%
Oracle Hyperion Oracle Hyperion PlanningPlanning
Oracle Hyperion Oracle Hyperion Financial MgtFinancial Mgt
Oracle Hyperion Oracle Hyperion EssbaseEssbase
Planning API HFM API Essbase API
Oracle | Hyperion Data AccessOracle | Hyperion Data Access
Data ServicesAuthentication Logging Services
API Layer
Hyperion Hyperion PlanningPlanning
Hyperion Hyperion Financial Financial
ManagementManagementHyperion Hyperion EssbaseEssbase
Metadata Discovery & Model Creation
Extract Data UseEssbase KM
Extracts Dimension Members
UseEssbase KM
Loads Data Loads Dimension Members
Other Features Cube Refresh Consolidate Calculate
Oracle Hyperion Application Adapters
Focus on Oracle | Hyperion ApplicationsLeveraging EPM with Embedded Data Integration
Oracle Data Integration SuiteOracle Data Integration Suite
Metadata Lineage
Data Distribution & Delivery APIs
Bulk/Trickle Loading
Changed DataCapture
MasterData
Data Quality& Profiling
ODI Knowledge Module Framework
Oracle EBS
PeopleSoft
SAP/R3Other
Sources
Data Warehouse
CDC
MessageQueues
Information Assets
Bulk and Real-Time Data Processing
Oracle Data IntegratorOracle Data Integrator
Focus on Oracle Data QualityOracle Data Quality for Data Integrator
• Best of breed Quality• Joint development with Trillium• Proven, scalable DQ engines• Rich global content for cleansing, standardization,
validation• Extensible by customers with domain-specific Data
Quality functions
• Packaged Quality Rules• Delivered Out-of-the-Box by Oracle• For 35 Countries & Domains
Target
Sources
Integration ProcessIntegration Process
Oracle Data Quality for Data Integrator Oracle Data Quality for Data Integrator (*)(*)
Global DataRouter
Transformer Parser PostalMatcher
RelationshipLinker
(*) Joint Development with Trillium
Parsing, Cleansing, Standardization, Parsing, Cleansing, Standardization, MatchingMatching
ODI Suite with Hyperion MDMFoundation for Data Relationship Management (DRM)
• Hierarchy management• Derivation/inheritance• Classification, categorization• Attribute management
• Change management• Streamlined, automated• Valid-from, Valid-to ranges• Compare any 2 versions
• Business-user driven• Easy user declarative tool• Specify business rules • Multi-user collaboration• What-if & historical analysis
• Meets IT requirements• Synchronize with operational systems• Complete auditing, fine-grained
security• Configurable, no coding
Hyperion Data Hyperion Data Relationship Relationship ManagementManagement
Oracle EBS
People Soft
SAP/R3Other
Sources
Data Warehouse
CDCMessage Queues
Oracle Data IntegratorOracle Data Integrator
DRM Import/Export
Profiles
Bulk and Real-Time Data Processing
Metadata Repository
ODI Knowledge Modules for DRMODI Knowledge Modules for DRM
Bulk Transform.
Changed Data
Capture
Data Integrity
Data Quality
ODI Connectivity Framework
Information Assets
46
47
Focus on Business Activity Monitor Use Data Integration with High Speed Event Processing
• Oracle SOA Suite - BAM• Business Activity Monitoring provides
real-time business insight• High speed, In-Memory, Complex
Event Processing• Determine impact of events on KPIs
• Oracle Data Integrator• High performance loading of BAM’s
In-Memory Event Cache• Pre-built and integrated via
Knowledge Modules• Provides ability to correlate events
with Real-Time Warehouse events
• Sample combined use cases• Monitor together events and the
aggregate implications of events
Data Warehouse
Oracle SOA SuiteOracle SOA Suite
BPEL Process Manager
Web Services Manager
Business Rules Engine
Enterprise Service Bus
SAP/R3 PeopleSoft Message Queues
Business Activity Monitoring
Active Data Cache
Event Engine Report Cache
Event Monitoring Web Applications
Bulk and Real-Time
Data Processing
CDC
Oracle Data IntegratorOracle Data Integrator
ODI Knowledge Modules for BAMODI Knowledge Modules for BAM
Bulk Transform.
Changed Data
Capture
Data Quality
ODI Connectivity Framework
ODI for Oracle FusionData Integration as a Key Fusion Differentiator
• Fusion Applications• Built-in, Automated Data Replication among ERP Applications
• Fusion Business Intelligence• Pre-built Analytics from Fusion ERP Applications
• Automatic Mapping and Model Updates (Application-driven)
• Fusion Master Data Management• Data Replication, Conflict Detection and Conflict Resolution
• Fusion w/Essbase• Fusion Financials (Automatic Financial Consolidation)
• Pre-built Essbase Content with Apps and Business Intelligence
Focus on Pillar ReplicationEmbedded ODI Architecture
JDeveloper
Pillar Editor
Enterprise Manager
MDS
Pillar Definitions
EM DBPillar Deployment
Configurations
Pillar Deployment Configuration UI Pug in
CRMHCMFSCMEPMELM
Pillar Metadata Generator Pug in
Service Registry
Oracle Data Integrator
ODI Repository
ODI SDK
Knowledge Modules
Replication Interfaces
CRMHCM
FSCMEPMELM
ODI Designer ODI Agent
ODI Agent
ODI Agent
OC4J
ADF BC with Pillar
ExtensionsFSCM DB
ODICDC
OC4J
ADF BC with Pillar
ExtensionsHCM DB
ODICDC
OC4J
ADF BC with Pillar
ExtensionsCRM DB
ODICDC
Design time Runtime
SQL
SQL
SQL
DataReplication
DataReplication
Focus on Pillar ReplicationPatterns Covered for Conflict Resolution
Pattern SolutionPhysical Conflict (Insert/Update/Delete)
Pillar Replication Framework default KMs to detect & resolve database level conflicts
Logical Conflicts (Primary Flag & Date Effectivity)
Application Specific logic built using ODI Knowledge Modules to detect & resolve conflicts.
Column sub-setting All or some columns can be selected from EOs using the RDS Editor.
Row sub-setting A Filter can be added to a replication data set using the RDS Editor
Q51
A&
The preceding 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.