< >
Agenda Oracle Data Integrator Oracle Data Integrator Oracle Data Integrator 2
Agenda Oracle Data Integrator Oracle Data Integrator Oracle Data Integrator 3
NEED Business Intelligence Corporate Performance Management Business Process Management Business Activity Monitoring / --- --- --- --- HAVE --- --- --- --- ------ --- --- --- --- --- --- --- ------ ------ --- --- ERP CRM 4
ETL ETL Extract / Transform / Load E: T: L : RDBMS E: T: L: 5
6
Agenda Oracle Data Integrator Oracle Data Integrator Oracle Data Integrator 7
Oracle Data Integrator Oracle Data Integrator SOA ETL Oracle Data Integrator (ODI) SOA 8
DB E-LT 9
DB DB ETL ETL 1 CSV Oracle Database 2 Oracle SQL Loader etc. 1 3 3 Oracle SQL*Loader Script PL/SQL Script Oracle SQLetc. 2 : 10
GUI GUI & 11
DB - - PG - DBSQL - - - Oracle Oracle Merge SQL Server SQL*Loader Oracle Web Triggers TPump/ Services Check MS Multiload Excel Siebel EIM JMS QueuesSchema Oracle DBLink DB2 Web DB2 Exp/Imp Services Check Sybase SAP/R3 Type II SCD Siebel DB2 Journals Log Miner / Oracle Database WS WS WS CDC IBM DB2 IBM DB2 IBM Journal Oracle SQL*Loader Oracle PL/SQL Oracle MERGE Web Service DB 12
Knowledge Modules KMs KM LKM IKM CKM RKM JKM SKM Loading) Integrate) Check) (Reverse) (Journal) (Service) Web Pluggable Knowledge Modules Architecture Reverse Engineer Metadata 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 WS WS WS Staging Tables CDC Target Tables Sources Error Tables 13
Knowledge Modules KM KM KM / <%=snpref %>ODI Designer(GUI)/ 14
OS/ ODI ODI/ JDBC, FTP, HTTP / XML Message-Oriented Middleware ERP, CRM, LDAP OLAP JDBC Oracle Btrieve DB2/UDB DB2/MVS DB2/400 dbase Hypersonic SQL Informix Ingres Interbase Microsoft SQL Server MySQL Netezza Paradox Progress Sybase ASE Sybase IQ Sybase ASA Teradata CSV Microsoft Access Excel JDBC ISAM COBOL DL/I IDS/II Datacom Adabas Read UpdateDTD XSD ) JMS Oracle ESB/BPEL IBM Websphere MQ SwiftMQ Sonic MQ JCA SAP Oracle Applications Siebel/BI JDBC JDBC/ODBC Essbase Teradata 15
Oracle Data Integrator SOA 16
CDC CDC / / ETLCDC CDC ETL CDC ETL 17
ODI CDC CDCKM CDCDB Insert/Update/Delete CDCETL CDC CDC ETL DB ETL 18
ODI CDC ODI GUI CDC Trigger ODI Agent 19
ODI CDC ODI GUI CDC REDO Streams LogMiner LGWR REDO Streams LogMiner ODI Agent 20
SOA ODI Web Web - Web Web - ODI Web Web ) Oracle BPEL Process Manager ODI ODI ODI Web CALL BPEL ODI Web BPEL 21
E-LT ODI ODI ODI Agent Java process ODI DB ODI DB ODI Agent Web PC ODI ODI Agent ODI SQL* Loader File Excel ODI Agent : Data Flow : / 22
1 ODI Agent / 3 ODI Agent 3 SQL* Loader ODI SQL OS API ( Agent ) PC SQL* Loader 23
Agenda Oracle Data Integrator Oracle Data Integrator Oracle Data Integrator 24
Oracle Data Integrator ODI TOPOLOGY ODI DESIGNER ODI OPERATOR ODI METADATA NAVIGATOR ODI SECURITY Agent JMS JCA JDBC JDBC JDBC/OS JNDI JDBC/OS MOM ERP/ CRM DWH DBMS OLAP LDAP Directory XML 25
ODI 1. 2. Reverse-engineering 3. Topology Designer 4. 5. Designer Operator Operator 26
ODI Designer ODI ( Knowledge Module ) ODI ODI API OS ODI Designer 27
Join JOIN SQL Where DB 28
LKM IKM 29
ODIOperator : : : : : : SQL Operator 30
Agenda Oracle Data Integrator Oracle Data Integrator Oracle Data Integrator 31
/ 32
KM 2 PDF / 33
ODI PDF 34
PDF 35
Operator ODI API / ( ) Operator OdiPurgeLog 36
: ODI / GUI () / ( ) 37
- http://www.oracle.com/lang/jp/products/middleware/oracle-data-integrator.html - http://www.oracle.com/technology/products/oracle-dataintegrator/10.1.3/htdocs/documentation/odi_certification.xls OTN Oracle Technology Network - http://www.oracle.com/technology/global/jp/products/oracle-data-integrator/index.html Oracle Data Integrator - http://otndnld.oracle.co.jp/document/products/odi/10135/doc_cd/index.htm Oracle Data Integrator ETL - http://otndnld.oracle.co.jp/document/products/odi/10135/doc_cd/oracledi/doc/webhelp/ja/p rintable/gs_etl.pdf Oracle University Oracle Data Integrator - http://education.oracle.com/pls/web_prod-plqdad/show_desc.redirect?dc=d48459jp30&p_org_id=70&lang=ja 38
Oracle Direct Seminar 100 Wendy2010 11 12 2!! a.b.c.d. a,b,c,d http://www.oracle.com/technology/global/jp/membership/index.html ORD_SEMINAR_JP@ORACLE.COM 2009 11 12 Oracle Direct 39
OTN!! Oracle Technology Network(OTN) http://otn.oracle.co.jp/forum/index.jspa?categoryid=2 OTN OTN Oracle100% 40
Oracle University Live Virtual Class Oracle University LVC15% OFF Oracle University Live Virtual Class (Oracle University LVC) Oracle University LVC Oracle University LVC Data Warehouse 11/2 11/12 11/13 http://education.oracle.co.jp/lvc_session_0911/ Oracle E-Business Suite Siebel PeopleSoft JD Edwords Agile 11/20 11/27 12/3 12/4 http://education.oracle.co.jp/lvc_session_0912/ Copyright Oracle Corporation Japan, 2009. All rights reserved. 41
IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Database Oracle Database 42
Oracle Direct Oracle Direct IT / Web 0120 155 096 ~ 9:00~12:00 13:00~18:00 43
Oracle PeopleSoft JD Edwards Siebel 44