?????????? ?????????? ???????? ??????: Oracle Data Integrator

1
?????????? ?????????? ???????? ??????Oracle
Data Integrator

• ?????? ????????????

2
???? ???????????
ltInsert Picture Heregt

• 4 ???????? ????????????
• ??????????? ???????????
• 6 ????? ? ?????????
• ???????? ?????????????

3
?????? ?????????? ???????
?????
?????
4
Oracle Data Integrator

• ????????????? ? ??????????? ?????? ??
  ????????????? ?????????? ? ???????????? ?????
• ???????? ??????????? E-LT
• ???????? ???????? ??????????
• ?????????????? ????????????? ??????
• ????????????? ?????? ??????

????????????
????????????? ???????????
5
E-LT ?????????????????? ??????????????????

• ?????????????????? ETL ??????
• ?????? ????
• ?????? ??????????????????
• ??????? ????
• ?????????????? ?????? ????
• ????????????? ??????????? ????????????
• ?????????????
• ??????? ??????????????????
• ????????????
• ??????????? ?????????????????? ? ????????????????
• ???????? ?????????? ? ?????? ????

6
??????????? ?????????

• Java design-time environment
• ???????? ?? ????? ??????????
• ?????? ?????? ??? ????????? ??????????
• Java runtime environment
• ???????? ?? ????? ??????????
• ????????? ??????????? ?????? ?????
• Metadata repository
• ???????? ?? ????? ??
• ??????????? ? ?????????????

7
??????????? ??????????
8
???????? ??????????C????????? ?
??????-??????????????? ??????????

• ??????? ?? ???????? ???????? ? ??????????
  ????????? ???????
• ???????????? ???????????
• ?????????? ?? ????
• ????????????

• ????????? ????????? ????????? ????????? ??????? ?
  ????
• ????? ???????????? ? SOA

9
?????? ?????? (Knowledge Modules)???????????,
????????, ?????????????
Journalize Read from CDC Source
Load From Sources to Staging
Check Constraints before Load
Integrate Transform and Move to Targets
Service Expose Data and Transformation Services
Reverse Engineer Metadata
Reverse
WS
WS
WS
Staging Tables
Load
Integrate
Services
CDC
Check
Journalize
Target Tables
Sources
Error Tables
??????? ?????? ??????
SAP/R3
Log Miner
SQL Server Triggers
Oracle DBLink
JMS Queues
Check MS Excel
TPump/ Multiload
Oracle Merge
Oracle Web Services
Siebel
DB2 Journals
DB2 Exp/Imp
Check Sybase
Oracle SQLLoader
Type II SCD
Siebel EIM Schema
DB2 Web Services
????????????

• ???????????? ???? ?????? ?????????
• ????? ????????????????

10
??????? Knowledge Modules

• Generic SQL DB
• Oracle DB 9i
• Oracle DB 10g
• Oracle DB 10g XE
• IBM DB2/400
• IBM DB2/UDB
• IBM Informix SE
• IBM LDAP Server
• MS SQL Server 2000
• MS SQL Server 2005
• MS SQL Server 2005 SE
• MS Office Access 2000
• MS Office Excel 2000
• MS Active Directory
• Sybase ASA 8.x 9.x
• Sybase IQ 12.x
• Sonic MQ v7.0
• Teradata V2R5.x
• Teradata V2R6.x

• Netezza Performance Server 2.2.1
• Hyperion Essbase
• PostgresSQL 8.1
• MySQL 4.0
• MySQL 5.0
• Oracle BI Suite 10g
• Oracle BAM 10g
• Oracle Internet Directory 9i
• OpenLDAP 2.3
• Siebel CRM 7.8
• JD Edwards
• PeopleSoft
• SAP R/3
• Oracle EBusiness Suite
• Oracle AQ 10g
• Oracle SOA Suite
• Oracle ESB 10g
• SalesForce.com App Exchange
• Any JMS Standard Implementation

Out-of-Box Knowledge Modules
11
Declarative Design?????????????? ?????????????

• ???????????? ??????
• ??????????? ?????? ?????????? ?????? ??? ????????
  ETL ????????
• ????????? ??????????? ETL ??????
• ???????????? ?????? ?? ?????????? ? ?????????
• Declarative Set-based Design
• ??????????? ????? ?????
• ?????????????? ????????? ????????
• ????????????
• ???????????? ????????? ????????
• ?????????? ?????? ?????????
• ?????????? ????????? ??? ??-?? ?????????

12
Oracle Data Integrator??????????? ???????????
13
??????????? ???????????

• Master Data Management enabled
• ???????? ??????????????? ????????
• ?????????????? ???????? ????????????? ??????? ?
  ?????????????
• ?????????? ???????? ??????????? ??????
• Real-time enabled
• ?????? ?????????
• Message Oriented Integration (JMS)
• SOA enabled
• ?????? ??????? ? ??????
• ?????? ?????????????
• Extensibility
• Knowledge Modules Framework
• ????? ?????????
• Open Tools

14
MDM Canonical Format Design

• ?????????? ? ?????????? ????????????? ???????
• ????????????? ????????? ???????? ??? ??????????
  MDM ?????????? (entities, fields, relationships)
• ???????? ? ????????? ???????? ????????? ??????

Enterprise Service Bus
CRM
SCM
Legacy
ERP
15
MDM ?????????? ???????? ??????????? ??????

• ??????????? ??????????? (constraints) ?? ??????
  ??????
• ?????? ????????? ? ???????? ???????????
• ????????, ??????? ??? ????????? ?????????
  ??????????? ???????

Message Id Name City
Duplicated Record 001 John Doe New York
Duplicated Record 022 John Doe Boston
Invalid City Reference 230 Albert Fresh Maris
16
Real-time enabled Changed Data Capture

• ?????????? ? ???????? CDC Framework
• Database logs
• Triggers
• Third-tier solutions
• ????????? ??????????? ?????????? ?????????????
  ????????? ??????
• ???????? ??? ???????????? ????????
• ???????? Journalized Data Only
• ????????? ??????????????

CDC
17
Real-time enabled ?????????? ?????????? ??
??????????

• ???????????? ? ?????????? ?????????? ????????? ?
  ???????? ?? ??? (JMS)
• ?????????, ??? ??????????? ????????? ??
  ??????????
• ??????? ?????????????
• ?????????????? ??????? ???????? ?????????
  ???????, ?? ? ??????????
• ??????????? JMS Queues ??? ????????? ? ?????????

CDC
18
SOA Enabled Data Access Services

• ?????????? ? ?????????? ?????? ??????? ? ??????
• ???????? ?????? ??????? ? ??????
• ????????????? ??????
• ???????????? ?????? ??????? ? ?????? ? ????? SOA
  ??????????????

SOA Infrastructure
Business Processes
Services
Data Access
Transform
ESB
Business
19
SOA Enabled Data Flow Services

• ??????????? ???????? ??? Web Services
• ????????????? ??????????
• ?????????? ???????? ??? web-??????? ? ????? SOA
  ??????????????

SOA Infrastructure
Business Processes
Services
Data Access
Transform
ESB
Business
20
Knowledge Modules

• 120 KMs out-of-the-box
• ?????? ? best practices
• ????????? ?????????????????
• ?????????? ????????? ????????
• ??????????????? ? ??????????

KM Interpreter
21
Scripting Framework

• ??????????? ????? ?????????
• ?????????? ????? ?????????? ? ???? ??????
• SQL, PL/SQL, Transact SQL, etc.
• ??????????? OS shell ???????
• Win32 DOS, sh, ksh, csh, OS400 commands, JCL,
  etc.
• ??????????? ????? ??????????? ? Bean Scripting
  Framework Java, JavaScript, Jython (Java Python),
  Perl, etc.

22
Open Tool

• ?????????? ODI
• ?????????? ???? ??????????? ? ???????
• ?????????? OdiOpenToolAbstract Java ?????????
• ??????????????? Open Tool ? Designer
• ??????????? Open Tool ? ????? ??????????

23
Oracle Data Integrator6 ????? ? ?????????
24
6 ????? ? ?????????

1. ????????/???????? ??????????
2. ???????????? ?????????????
3. ????????? ???????? ??????????

1. ???????????? ????????
2. ?????????? ??????????
3. ???????????? ???????

Development
Production
Development Servers and Applications
Production Servers and Applications
Data Warehouse
Data Warehouse
CRM
CRM
Legacy
Legacy
ERP
ERP
ODI Design-Time Environment
ODI Runtime Environment
Agent Data Flow Conductor
Agent Data Flow Conductor
Operator
Metadata Navigator
25
????????/???????? ??????????
1
Design-Time Environment
Development Servers and Applications

• Reverse-engineer
• ??????????????
• ?????????????
• 40 ??????????
• ???????? ??????????
• ????????????????
• ??????? ??? ??????????? ??????

ODI Designer
ERP
Data Warehouse
Design-time Repositories
CRM
Files / XML
Legacy
26
???????????? ?????????????
2
1
?????????? ??? ?? ??????
Oracle Data Integrator Interface Declarative
Design
Bulk Load Changed Data Capture
Incremental Update Slowly Changing Dimension
27
????????? ???????? ??????????
3

• ?????????????????? ?????????????
• ODI ???????????
• Data Quality Processes
• Files/Archives Management
• Send/Receive Emails
• Web Services Invokation
• Event Detection
• ???????? ??????????? ???????????
• ???????????
• ?????
• ???????
• ????????? ??????

28
???????????? ????????
4

• ????????????? ???????? ??? ??????????
• ??????????? ?????????? ????????
• Advanced Version Management
• ?????????? ? Production

29
?????????? ??????????
5

• ???????? ?????????? ?????? ? ??????? ???????
• ???????? ????
• ????????? ??????????
• ?????????? ??????? ??????

30
???????????? ???????/???????????
6
?

• ????????? ???????? ????? ????????? ? ???????
  ????????
• ?????????? ?? Web ?????????? ?????????
• ????????? ???? ?????? ??????
• ???????? ?? ???? ??????
• Drill-down ? ??????????????

31
???????? ?????????????
32
E-LT ??? ???????? ??????

• ???????????? ????????? ? ????
• ??????????????? ????????
• ???????? ?????????? ???????????
• ??????????? ??????
• ?????? ????????? (CDC)
• ?????? ???????

33
Master Data Management(?????????? ?????????
???????)

• ???????????? ??? ?????????????? ??? ????????
  ???????????? ????
• ???????? ??????? ??????
• ?????? ????????? (CDC)
• ??????? ? ???????????? ??????
• ?????????? ????????? ??????
• ?????????? ??????????

34
????????

• ???????? ?????????? ?????? ? ????? ??????????
• ?????????????? ????????
• ????????????? ??????? ? ?????? ?????????? ?
  ?????? ??????????? ?????????????
• ???????????? ?????? ????????? (CDC)

35
????????????? ? SOA

• ????? ??????? ???????? ??? ??????????
• ???????? ????????
• ?????????? ????????

36
Oracle Data Integrator Roadmap

• Focus Areas for Next Major Release
• Deep Integration with Fusion Middleware
• Runtime, Design time, Security, Administration,
  Events
• Functional Integration with Oracle Warehouse
  Builder
• Runtime Integration, Metadata Sharing, Knowledge
  Module Sharing
• Deployment of ODI for Embedded Data Integration
• OracleBI Enterprise Edition, Data Hubs,
  Application Migrations
• Enhanced Usability and Debuggability
• Wizards, New Views, User-definable Debugging
• Improved Support for Native Oracle Database
  Features
• Oracle OLAP

37
?????????
38
Q

A
39
(No Transcript)
40
(No Transcript)
41
???????????? Oracle Data Integrator

• E-LT ???????????
• ???????? ?????????? (Active Integration)
• ?????? ?????? (Knowledge Modules)
• ?????? ? ?????????????? ?????????? ?? ??????
  ???????? (Declarative Design)

42
ODI ????????? ??????????? Oracle BI

• Oracle Business Intelligence Suite EE
• ?????? ??????
• ????????? ??????? ??????????
• ???????????????? ????????? ????????
• ??????????? ??????? ? ??????
• Oracle Data Integrator
• ?????????? ?????????????? ????????? ??????
• ??????????? ?????????????????? ETL ?????????

43
ODI Enhances Oracle SOA SuiteAdd Bulk Data
Transformation to BPEL Process

• Oracle SOA Suite
• BPEL Process Manager for Business Process
  Orchestration
• Oracle Data Integrator
• Efficient Bulk Data Processing as Part of
  Business Process
• Interact via Data Services and Transformation
  Services

44
ODI Enhances Oracle SOA SuitePopulate BAM Active
Data Cache Efficiently

• Oracle SOA Suite
• Business Activity Monitoring for Real-time
  Insight
• Oracle Data Integrator
• High Performance Loading of BAMs Active Data
  Cache
• Pre-built and Integrated