Title: ?????????? ?????????? ???????? ??????: Oracle Data Integrator
1?????????? ?????????? ???????? ??????Oracle
Data Integrator
2???? ???????????
ltInsert Picture Heregt
- 4 ???????? ????????????
- ??????????? ???????????
- 6 ????? ? ?????????
- ???????? ?????????????
3?????? ?????????? ???????
?????
?????
4Oracle Data Integrator
- ????????????? ? ??????????? ?????? ??
????????????? ?????????? ? ???????????? ????? - ???????? ??????????? E-LT
- ???????? ???????? ??????????
- ?????????????? ????????????? ??????
- ????????????? ?????? ??????
????????????
????????????? ???????????
5E-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
11Declarative Design?????????????? ?????????????
- ???????????? ??????
- ??????????? ?????? ?????????? ?????? ??? ????????
ETL ???????? - ????????? ??????????? ETL ??????
- ???????????? ?????? ?? ?????????? ? ?????????
- Declarative Set-based Design
- ??????????? ????? ?????
- ?????????????? ????????? ????????
- ????????????
- ???????????? ????????? ????????
- ?????????? ?????? ?????????
- ?????????? ????????? ??? ??-?? ?????????
12Oracle Data Integrator??????????? ???????????
13??????????? ???????????
- Master Data Management enabled
- ???????? ??????????????? ????????
- ?????????????? ???????? ????????????? ??????? ?
????????????? - ?????????? ???????? ??????????? ??????
- Real-time enabled
- ?????? ?????????
- Message Oriented Integration (JMS)
- SOA enabled
- ?????? ??????? ? ??????
- ?????? ?????????????
- Extensibility
- Knowledge Modules Framework
- ????? ?????????
- Open Tools
14MDM Canonical Format Design
- ?????????? ? ?????????? ????????????? ???????
- ????????????? ????????? ???????? ??? ??????????
MDM ?????????? (entities, fields, relationships) - ???????? ? ????????? ???????? ????????? ??????
Enterprise Service Bus
CRM
SCM
Legacy
ERP
15MDM ?????????? ???????? ??????????? ??????
- ??????????? ??????????? (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
16Real-time enabled Changed Data Capture
- ?????????? ? ???????? CDC Framework
- Database logs
- Triggers
- Third-tier solutions
- ????????? ??????????? ?????????? ?????????????
????????? ?????? - ???????? ??? ???????????? ????????
- ???????? Journalized Data Only
- ????????? ??????????????
CDC
17Real-time enabled ?????????? ?????????? ??
??????????
- ???????????? ? ?????????? ?????????? ????????? ?
???????? ?? ??? (JMS) - ?????????, ??? ??????????? ????????? ??
?????????? - ??????? ?????????????
- ?????????????? ??????? ???????? ?????????
???????, ?? ? ?????????? - ??????????? JMS Queues ??? ????????? ? ?????????
CDC
18SOA Enabled Data Access Services
- ?????????? ? ?????????? ?????? ??????? ? ??????
- ???????? ?????? ??????? ? ??????
- ????????????? ??????
- ???????????? ?????? ??????? ? ?????? ? ????? SOA
??????????????
SOA Infrastructure
Business Processes
Services
Data Access
Transform
ESB
Business
19SOA Enabled Data Flow Services
- ??????????? ???????? ??? Web Services
- ????????????? ??????????
- ?????????? ???????? ??? web-??????? ? ????? SOA
??????????????
SOA Infrastructure
Business Processes
Services
Data Access
Transform
ESB
Business
20Knowledge Modules
- 120 KMs out-of-the-box
- ?????? ? best practices
- ????????? ?????????????????
- ?????????? ????????? ????????
- ??????????????? ? ??????????
KM Interpreter
21Scripting 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.
22Open Tool
- ?????????? ODI
- ?????????? ???? ??????????? ? ???????
- ?????????? OdiOpenToolAbstract Java ?????????
- ??????????????? Open Tool ? Designer
- ??????????? Open Tool ? ????? ??????????
23Oracle Data Integrator6 ????? ? ?????????
246 ????? ? ?????????
- ????????/???????? ??????????
- ???????????? ?????????????
- ????????? ???????? ??????????
- ???????????? ????????
- ?????????? ??????????
- ???????????? ???????
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???????? ?????????????
32E-LT ??? ???????? ??????
- ???????????? ????????? ? ????
- ??????????????? ????????
- ???????? ?????????? ???????????
- ??????????? ??????
- ?????? ????????? (CDC)
- ?????? ???????
33Master Data Management(?????????? ?????????
???????)
- ???????????? ??? ?????????????? ??? ????????
???????????? ???? - ???????? ??????? ??????
- ?????? ????????? (CDC)
- ??????? ? ???????????? ??????
- ?????????? ????????? ??????
- ?????????? ??????????
34????????
- ???????? ?????????? ?????? ? ????? ??????????
- ?????????????? ????????
- ????????????? ??????? ? ?????? ?????????? ?
?????? ??????????? ????????????? - ???????????? ?????? ????????? (CDC)
35????????????? ? SOA
- ????? ??????? ???????? ??? ??????????
- ???????? ????????
- ?????????? ????????
36Oracle 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?????????
38Q
A
39(No Transcript)
40(No Transcript)
41???????????? Oracle Data Integrator
- E-LT ???????????
- ???????? ?????????? (Active Integration)
- ?????? ?????? (Knowledge Modules)
- ?????? ? ?????????????? ?????????? ?? ??????
???????? (Declarative Design)
42ODI ????????? ??????????? Oracle BI
- Oracle Business Intelligence Suite EE
- ?????? ??????
- ????????? ??????? ??????????
- ???????????????? ????????? ????????
- ??????????? ??????? ? ??????
- Oracle Data Integrator
- ?????????? ?????????????? ????????? ??????
- ??????????? ?????????????????? ETL ?????????
43ODI 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
44ODI 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