oracle data odi
TRANSCRIPT
Oracle Data Integrator
Craig Stewart, ODI Principal Sales Consultant EMEA
Data IntegrationData Integration
Data Data WarehousingWarehousing
Master Data Master Data ManagementManagement
SOASOARegulatory Regulatory ComplianceCompliance
- - -- - - - - -- - -
FederationFederationMigrationMigration
What you need: Manage PerformanceWhat you need: Manage Performance
Why Data Integration?Transform Information into Competitive Business Value
What you have: Information Assets in Disparate SourcesWhat you have: Information Assets in Disparate Sources
Understand the PastUnderstand the PastControl the PresentControl the Present
(BI)(BI)
Plan for the FuturePlan for the FutureManage PerformanceManage Performance
(CPM)(CPM)
Monitor ActivityMonitor ActivityTake ActionsTake Actions
(BAM)(BAM)
Coordinate Present Coordinate Present Manage ProcessesManage Processes
(BPM)(BPM)
ERP
------------
------
CRM
- - -
Legacy
------------
------ ------------
------
Best-of-Breed ApplicationsPLM
Use Cases for Oracle Data Integrator
Master Data Management• Create Single View of the Truth• Synchronize Data with ODI
Application Integration• Bulk-load historical data to new application• Synchronize new and old applications during overlap
time• Complex transformations, CDC
Migrations• Upgrade Applications or Migrate to New Schema• Move Bulk Data Once and Keep in Sync with ODI
Modernization• Mainframe / iSeries sources to Oracle RAC• Re-architect legacy batch processing to SOA and
ODI
E-LT for Data Warehouse• Create Data Warehouse for Business Intelligence• Populate Warehouse with High Performance ODI
SOA Initiatives• Establish Messaging Architecture for Integration• Incorporate Efficient Bulk Data Processing with ODI
Oracle Data IntegratorBased on Technology Foundation from
Data Movement and Transformation from Multiple Sources to Heterogeneous Targets
D I F F E R E N T I A T O RB E N E F I T
Knowledge ModulesHot-Pluggable4The Chosen Integration Technology of Fusion
Future Proof5
Declarative CDCReal-time Integration3
Declarative DesignProductivity2
Heterogeneous “E-LT”Best Performance1
Differentiator: E-LT ArchitectureHigh Performance
Transform in Existing RDBMS High Performance Easier to Manage & Lower Cost
Conventional ETL Architecture
Extract LoadTransform
Conventional ETL Architecture
Extract LoadTransformExtractExtract LoadLoadTransformTransform
Next Generation Architecture
“E-LT”“E-LT”LoadExtract
Transform Transform
Next Generation Architecture
“E-LT”“E-LT”LoadExtract
Transform Transform
“E-LT”“E-LT”LoadExtract
TransformTransform TransformTransform
Transform in Separate ETL Server Poor Performance High Costs
Customer Benefits:
Batch Load times went from 63 hours to under 10 minutes
Proprietary EngineProprietary Language
Leverage RDBMSNative SQL
Differentiator: Declarative Design Developer Productivity & Maintainability
Conventional ETL DesignConventional ETL Design
ODI Declarative Design
Define How: Built-in Templates
Define WhatYou Want
Automatically GenerateDataflow
11 22
ODI Declarative Design
Define How: Built-in Templates
Define WhatYou Want
Automatically GenerateDataflow
11 22
Define How: Built-in Templates
Define WhatYou Want
Automatically GenerateDataflow
11 22Define WhatYou Want
Automatically GenerateDataflow
11 2211 22
Conventional ETL Design Specialized skills Significant development & maintenance
efforts
Declarative Set-based Design Shorter implementation times Significantly reduced learning curve
“ODI is an incredibly powerful development environment. Not only have our development teams increased their productivity by at least 50%, but ODI also helps them to better structure their work, and to produce data interfaces that are better documented and easier to understand.”
Customer Benefits:
Necessity to define each step of Complex ETL Flow Logic
Simplified number of steps Automatic Data Flow generation
Differentiator: Active Integration Declarative CDCReal-Time Business Intelligence & DW
Tracking and moving just the changed data
Declarative set-based mapping Ensured Data Consistency
High efficiency of integration by reducing the volume of source data processed in the flow
Reduced implementation time
CDCCDC
• Real Time Synchronisation of Oracle 10g databases
• Low overhead on source system• On the fly transformations
Customer Benefits:
Differentiator: Knowledge ModulesHot-Pluggable: Modular, Flexible, Extensible
Tailor to existing best practices
Reduce cost of ownership
Library of hot-pluggable templates Open and extensible Declarative set-based mapping
• Spent 2-weeks at project initiation to tailor KMs to best practice
• Now can do development to add a table to their DW in 20 seconds, assured of Best Practice Implemetation
Customer Benefits:
Energy/Industrial Insurance / Health Retail Other
Communications Finance / Banking Media Services
Oracle Data Integrator Customers
Questions
<Insert Picture Here>
Oracle Data Integration Suite
Oracle’s Data Integration StrategyComprehensive, Integrated, Best of Breed, Hot Pluggable
• Provide a Comprehensive Data Integration Foundation…• Comprehensive - Complete data integration technology foundation • Integrated - Unified tools, metadata management and administration• Best of breed - Significant architectural and functional differentiators• Hot pluggable - Very broad range of information sources
Packaged Data Integration Suite
• …pre-Integrated with Oracle’s Middleware & Applications• Oracle Business Intelligence Tools & Business Intelligence Applications• Oracle’s Hyperion Planning, Budgeting, Financial Consolidation & Reporting• Oracle Packaged Applications for ERP, CRM, & Vertical Applications• Oracle Packaged Composite Applications & AIA• Oracle’s Master Data Management & Fusion Application Pillars
Data integration pervasive with lower cost & complexity within applications
Oracle Data Integration Suite
XML
Oracle Data Integrator with SOA and BIResolving Integration Challenges
Oracle BI Enterprise Data
Warehouse
Oracle BI
Dashboards, Reporting, Analysis, Publishing
Oracle BPA and Human Workflow
Oracle Data Integrator
Transformation Services Data Services
E-LT AgentMetadata
RepositoryKnowledge Modules
WSDL
Generate Data Services
High speed Batch ELT
High speed JMS ELT
CDC based ELT
Oracle JMS
CDC
Invoke
Invoke Invoke
Invoke
BPEL Process Manager
Invoke
Oracle BAM
Active Data Cache
Invoke
Service as Data Source
XML
Future Proof with SOA/BI/FusionResolve All Integration Challenges
Oracle BI Enterprise Data
Warehouse
Oracle BI
Dashboards, Reporting, Analysis, Publishing
Oracle BPA and Human Workflow
Oracle Data Integrator
Transformation Services Data Services
E-LT AgentMetadata
RepositoryKnowledge Modules
WSDL
Generate Data Services
High speed Batch ELT
High speed JMS ELT
CDC based ELT
Oracle JMS
CDC
Invoke
Invoke Invoke
Invoke
BPEL Process Manager
Invoke
Oracle BAM
Active Data Cache
Invoke
Service as Data Source