odi 12c getting started guide
DESCRIPTION
ODI first steps.Oracle data integrator.This manual describes how to get started with Oracle Data Integrator. It provides generalbackground information and detailed examples to help you learn how to use Oracle DataIntegrator.TRANSCRIPT
-
7/13/2019 Odi 12c Getting Started Guide
1/114
Oracle Fusion Middleware
Getting Started with Oracle Data Integrator 12c
July 2014
-
7/13/2019 Odi 12c Getting Started Guide
2/114
O F M G S O D I, 12
C 2010, 2014, O / . A . P
A: ODI P MT . E , , , , , , , , , ,, , , , , . R , , , , .
T . I , .
I U.S. G U.S. G, :
U.S. GOVERNMENT RIGHTS P, , , U.S. G " " " " F A R . A , , , , ,
G , , G , FAR 52.22719, C C S L (D 2007). OA, I., 500 O P, R C, CA 94065.
T . I , . I , , , , . OC .
O J O / . O .
I I X I C. A SPARC SPARC I, I. AMD, O, AMD, AMD O A M D. UNIX T O G.
T , , . O C , , . O C , , , , .
-
7/13/2019 Odi 12c Getting Started Guide
3/114
Contents
Preface ........................................................................................................................... 6A 6
D A .................................................................................................................................. 6
R D .................................................................................................................................................. 6
C .............................................................................................................................................................. 7
1 Oracle Data Integrator Overview ............................................................................ 81.1 Introduction to Oracle Data Integrator ................................................................. 8
1.1.1 T B P ........................................................................................................................ 8
1.1.2 A U S .............................................................................................................................. 8
1.2 ODI Component Architecture ............................................................................... 9
1.2.1 R ....................................................................................................................................... 10
1.2.2 ODI S U I ...................................................................................................... 10
1.2.3 RT A................................................................................................................................ 11
1.2.4 M P O D I .............................................................................. 12
1.2.5 O D I C ...................................................................................................... 12
1.2.6 O E M F M C ............................................................ 12
1.3 Get Started with Oracle Data Integrator ............................................................ 12
2 Installing Oracle Data Integrator and the Demonstration Environment ........... 13
2.1 Preparing to Install.............................................................................................. 13
2.1.1 R S R C .......................................................................... 13
2.2 Installing Oracle Data Integrator ........................................................................ 14
2.2.1 D I D E ............................................................. 14
2.2.2 S I ......................................................................................................................... 14
2.2.3 I T.............................................................................................................................. 15
2.2.4 I I ................................................................................................................... 15
2.3 Oracle Data Integrator Studio ............................................................................ 17
2.3.1 S O D I S .......................................................................................... 17
2.4 Create the ODI Repository .................................................................................. 18
2.4.1 R R ................................................................................................................ 18
2.4.2 C M R .......................................................................................................... 19
2.5 Connecting to the Master Repository ................................................................ 22
2.6 Creating the Work Repository ............................................................................ 23
-
7/13/2019 Odi 12c Getting Started Guide
4/114
2.7 Installing the Demonstration Environment ....................................................... 25
2.7.1 D C ODI D ...................................................................... 25
2.7.2 C S T L S D .............................................................................. 26
2.7.3 C ODI W R ............................................................................................ 26
2.7.4 I ODI O .................................................................................................................... 27
3 Working with the ETL Project ............................................................................... 30
3.1 The Example Environment ................................................................................. 30
3.2 The Data Models ................................................................................................. 31
3.2.1 O A ........................................................................................................................... 31
3.2.2 P ......................................................................................................................................... 31
3.2.3 S A O ......................................................................................................... 32
3.3 Integration Challenges ....................................................................................... 33
4 Introduction to Using Oracle Data Integrator Studio ......................................... 34
4.1 Using the ODI Studio Navigators ....................................................................... 34
4.1.1 S O D I S .......................................................................................... 34
4.2 Designer Navigator ............................................................................................. 35
4.3 Operator Navigator ............................................................................................. 37
5 Working with Mappings ........................................................................................ 38
5.1 Load TRG_CUSTOMER Mapping Example ....................................................... 38
5.1.1 P I R ......................................................................................... 38
5.1.2 M D .......................................................................................................................... 39
5.1.3 C M ...................................................................................................................... 41
5.2 Load TRG_SALES Mapping Example ................................................................ 54
5.2.1 P I R ......................................................................................... 54
5.2.2 M D .......................................................................................................................... 55
5.2.3 C M ...................................................................................................................... 56
6 Implementing Data Quality Control ..................................................................... 64
6.1 Introduction to Data Integrity Control ................................................................ 64
6.2 SRC_CUSTOMER Control Example ................................................................... 65
6.2.1 O............................................................................................................................................. 656.2.2 I P ................................................................................................................. 66
6.2.3 C C......................................................................................................................... 66
6.2.4 R S C ...................................................................................................................... 69
6.2.5 F E C O N ...................................................... 70
6.2.6 I R O N ........................................................................... 71
7 Working with Packages ........................................................................................ 74
7.1 Introduction ......................................................................................................... 74
-
7/13/2019 Odi 12c Getting Started Guide
5/114
7.1.1 A D I F .............................................................................................. 74
7.1.2 P ............................................................................................................................................. 74
7.2 Load Sales Administration Package Example .................................................. 757.2.1 P............................................................................................................................................... 75
7.2.2 M P O D I ........................................................................ 75
7.2.3 P A .............................................................................................................................. 76
7.2.4 C P ........................................................................................................................ 77
8 Executing Your Developments and Reviewing the Results .............................. 80
8.1 Executing the Load Sales Administration Package .......................................... 80
8.1.1 R P ................................................................................................................................ 80
8.1.2 F E P O N ..................................................... 80
8.1.3 I R L TRGCUSTOMER S S ...................................... 81
9 Deploying Integrated Applications ...................................................................... 84
9.1 Introduction ......................................................................................................... 84
9.2 Scenario Creation ............................................................................................... 84
9.3 Run the Scenario ................................................................................................ 85
9.3.1 E S ODI S .......................................................................................... 86
9.4 Follow the Execution of the Scenario ................................................................ 86
10 Using Oracle Data Integrator with Oracle GoldenGate ..................................... 87
10.1 Introduction ......................................................................................................... 87
10.1.1 C ODI W R ............................................................................................ 88
10.2 Reviewing the Oracle GoldenGate JAgent configuration in ODI Studio ......... 91
10.3 Initial load ............................................................................................................ 92
10.3.1 S ODI OGG D C ........... .......... ........... .......... ........... .......... ........... .......... ... 92
10.3.2 R M .......... .......... ........... .......... ........... .......... ........... ........... .......... ........... .......... . 93
10.4 Setting up Changed Data Capture ..................................................................... 97
10.5 Synchronizing the changed data ..................................................................... 104
10.5.1 L TRGCUSTOMER M .......... ........... .......... ........... .......... ........... .......... ........... .......... . 104
10.5.2 S D P ........... .......... ........... .......... ........... .......... ........... ........... .......... ........... .......... ...... 107
11 Going Further with Oracle Data Integrator ........................................................ 110
11.1 Summary ........................................................................................................... 110
11.1.1 G S T S ................................................................................................. 110
11.2 What else can you do with Oracle Data Integrator? ....................................... 112
11.3 Learn More ........................................................................................................ 113
-
7/13/2019 Odi 12c Getting Started Guide
6/114
6
Preface
T O D I. I O DI.
T :
A
D A
R D
C
Audience
T O D
I .
Documentation Accessibility
F O' , OA P http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc .
Access to Oracle Support
O M O S. F
, http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs .
Related Documents
F , O :
F D D
F D
F D
F C D
F D' D
D 12 D 12 , D 12
,
-
7/13/2019 Odi 12c Getting Started Guide
7/114
7
Conventions
T :
Convention Meaning
B , .
I , , .
monospace M , URL, , , .
-
7/13/2019 Odi 12c Getting Started Guide
8/114
8
1 Oracle Data Integrator Overview
T O D I, ,
G S .T :
S 1.1, "I O D I"
S 1.2, "O D I C A"
S 1.3, "G S O D I"
1.1 Introduction to Oracle Data Integrator
A , O D I , . B E
(E ), O D I .
O D I .
1.1.1 The Business ProblemI ' , ; . P , .
1.1.2 A Unique SolutionO D I , . O DI ELT (E L T) ETL , RDBMS . T , .
H O D I :
: T . T , ( "") ( "").
: O D I . T , O D I.
-
7/13/2019 Odi 12c Getting Started Guide
9/114
9
: (ETL) , . B ELT , RDBMS SQL, , .
: ELT ETL S . I , .
: O D I , OS .
: O D I RDBMS D W O, E, T, IBM DB2, N B D, , ERP, LDAP, XML.
: ETL S ETL . T
, .
1.2 ODI Component Architecture
T O D I F M . O D I J EE , OWL A S. O D I ES D, , , . F11 ODI .
Figure 11 Oracle Data Integrator Component Architecture
-
7/13/2019 Odi 12c Getting Started Guide
10/114
10
1.2.1 RepositoriesT O D I R. I IT , , ,, . M IT, D, A, A, . T
( : D, T, M P ).T .
T O D I R . O .
T :
S , ODI
T , , , , .
V .
T . S ODI ( , ). A W R :
M, , , , , , .
P, , , , , K M, .
S , , .
W W R ( ), E R.
1.2.2 ODI Studio and User InterfacesA, D O O D I S . T ( ), , , , .
ODI S N ODI :
D :
o A
o G
o V
o A
o C
-
7/13/2019 Odi 12c Getting Started Guide
11/114
11
. I IT . T O N, , .
' . T T N , , , , , . T , , O DI .
O DI. T S N , (, , ) ( , , ), (S 1, S 2, ).
O D I J API . T D D (D) J .
1.2.3 Run-Time AgentA , . T RTA. T .I , , R.
T A :
J E E (J EE) A O WL S HA . J EE A O EM.
S A J V M.
C S A . T O E M O WL . C S A O WL A S
T . T A
O D I, . I J API .
T J EE C S A ODIC, O D I O EM C C O F M C C.
-
7/13/2019 Odi 12c Getting Started Guide
12/114
12
1.2.4 Management Pack for Oracle Data IntegratorT M P O D I O E M CC , O D I E E.
F M P O D I, : http://www.oracle.com/us/products/middleware/data-integration/management-pack-for-odi/overview/index.html
1.2.5 Oracle Data Integrator ConsoleB ( , ), , UI D C. T OWL S.
1.2.6 Oracle Enterprise Manager Fusion Middleware ControlF M C
, W , , , ,, . T F M C W .
1.3 Get Started with Oracle Data Integrator
T 11 .
Table 11 Content Summary
This chapter Describes how to...
Chapter 2, "Installing Oracle Data Integrator and the
Demonstration Environment"
Install Oracle Data Integrator and the demonstration
environmentChapter 3, "Working with the ETL Project" Provides an introduction to the demonstration
environment delivered with Oracle DataIntegrator Studio
Chapter 4, "Introduction to Using Oracle Data IntegratorStudio"
Start the demonstration environment and Oracle DataIntegrator Studio
Chapter 5, "Working with Mappings Create and work with Mappings in Oracle DataIntegrator
Chapter 6, "Implementing Data Quality Control Implement data quality controlChapter 7, "Working with Packages" Create and work with Packages in Oracle Data
IntegratorChapter 8, "Executing Your Developments andReviewing the Results"
Execute your developments, follow the execution, andinterpret the execution results
Chapter 9, "Deploying Integrated Applications" Run an ODI Package automatically in a productionenvironment
Chapter 10, "Going Further with Oracle Data Integrator" Perform advanced tasks with Oracle Data Integrator
-
7/13/2019 Odi 12c Getting Started Guide
13/114
13
2 Installing Oracle Data Integrator and theDemonstration Environment
T O D I
. T GS O D I S.
A,
. B .
/ B
. F , :
://../////.
,
C 3.
T :
S 2.1, "P I"
S 2.2, "I O D I"
S 2.3, "I D E"
:O D I S
G
S .
2.1 Preparing to Install
R :
R S R C
C ODI R
2.1.1 Review System Requirements and CertificationB O D I (ODI) , . B OT N (OTN).
T , , , , :
://..////// .
T , , ,, JDK, :
://../////
100350.
-
7/13/2019 Odi 12c Getting Started Guide
14/114
14
2.2 Installing Oracle Data Integrator
T O D IS. T O D I S.
F , F D .
T :
D I D E
S I
I T
I I
2.2.1 Downloading the Installer and the Demo EnvironmentT O T N(OTN).
1. T ODI , O D I D OTN
:
://../////.
2. T ODI G S , O D I
O OTN :
://../////
2032252.
2.2.2 Starting the InstallerT ODI 12 ( ):
12.1.3.0.0D111.
T ODI (12.1.3.0.0.) .F .
T , :
O U W :
java jar fmw_12.1.3.0.0_odi.jar
Note: T JDK O D I JDK 7. R
O F M C JDK :
://../////
100350.
-
7/13/2019 Odi 12c Getting Started Guide
15/114
15
2.2.3 Installation TypesT :
ODI S
S A
T S ODI 12.1.3.0.0 .
2.2.4 Installation InstructionsF O D I S:
Note: I , F D .
1. I I I S S, O .
F :C:\Oracle\oraInventory
F U, /home/Oracle/oraInventory
2. I W S, C .
3. I I L , O ( ODIHOME).
F W:C:\Oracle\Middleware\Oracle_HOME
F U, ODI H
/home/Oracle/Middleware/Oracle_Home
Note: T O D I .
-
7/13/2019 Odi 12c Getting Started Guide
16/114
16
21
4. I I T S, S I. N
A .
22
5. C .6. I P C S, .
-
7/13/2019 Odi 12c Getting Started Guide
17/114
17
23
7. I I S S, I .
8. I I P S, .
9. I I C S, .
T ODI
.
2.3 Oracle Data Integrator Studio
2.3.1 Starting Oracle Data Integrator Studio .
T ODI S:
O U :
ODIHOME///.
O W :
ODIHOME\\\.
Note: O W, ODI S
O , A > > > .
-
7/13/2019 Odi 12c Getting Started Guide
18/114
18
U S , I P
. P .
T ODI S F 24.
24 12
2.4 Create the ODI Repository
T O D I
ODI ( ,
, .). ODI ODI
, , . F
, .
T ODI R (RCU)
ODI S . F G S , ODI S
.
2.4.1 Repository RequirementsT O D I R . T
O RDBMS
. T , .
T G S (
), ODI M W R.
:
:
I SQL P, :
SQL> ;
-
7/13/2019 Odi 12c Getting Started Guide
19/114
19
D ,
.
A . T
ODI T M
.
:
:
I SQL P, :
SQL> ;
2.4.2 Create the Master RepositoryC ODI M R. F
M R .
1. S ODI S
2. S N S
25
3. S C N M R
-
7/13/2019 Odi 12c Getting Started Guide
20/114
20
26
4. E 27
5. C ODI S . F
UID: , P: .
C
-
7/13/2019 Odi 12c Getting Started Guide
21/114
21
28
6. C
29
T ,
.
-
7/13/2019 Odi 12c Getting Started Guide
22/114
22
210
2.5 Connecting to the Master RepositoryO , O D
I M R S .
1. S O D I S
2. S D C (M R) :
U: prod_odi_repo
T ID/ (, ) ODI
P:
D L: S DBC D .T DBMS . TD N URL D.
D N: oracle.jdbc.OracleDriver
URL: jdbc:oracle:thin:@localhost:1521:ORCL
T URL JDBC . N URL , .
-
7/13/2019 Odi 12c Getting Started Guide
23/114
23
211
C T .
3. C , T ODI S D .
2.6 Creating the Work RepositoryT O D I W .
1. S ODI S M R, .
2. S T T .
212
3. C . W R
.
-
7/13/2019 Odi 12c Getting Started Guide
24/114
24
4. E JDBC . V
213
5. F C
214
6. WORKREP, SUPERVISOR .
-
7/13/2019 Odi 12c Getting Started Guide
25/114
25
215
7. C, .
8. C .
216
9. F ODI M, C . A , ODI
.
217
2.7 Installing the Demonstration Environment
2.7.1 Download and Copy the ODI Demonstration files
T O D I G S O D I D O T N (OTN)
http://www.oracle.com/technetwork/middleware/data-
integrator/downloads/index.html
T G S 2032252. file.
Note: T ODI S .
-
7/13/2019 Odi 12c Getting Started Guide
26/114
26
T G S , :
U 2032252. ODI_HOME/demo.
F , :
/////
T O D I
D
F
2.7.2 Create Sample Tables and Load Sample DataT
.
1. U , .
E .
CREATESRCORACLE.
CREATETRGORACLE.
A , , SQL P
//O/M///
E
>@AA.
2. E D L .
>@AAAAA.
2.7.3 Connect to the ODI Work Repository1. S ODI S.
2. S C R .
218
3. C .
-
7/13/2019 Odi 12c Getting Started Guide
27/114
27
219
4. S WORKREP
5. C . T ODI S D . A
, ODI ODI
D (, , .)
220
2.7.4 Import the ODI ObjectsT O D I (, , ) ODI S E . T
.
1. S ODI S D.
2. C C N .
-
7/13/2019 Odi 12c Getting Started Guide
28/114
28
221
3. S I S .
222
4. N , . S 12.,
W 1 E K :
223
-
7/13/2019 Odi 12c Getting Started Guide
29/114
29
T I A ,
224
O D I O . E M
.
-
7/13/2019 Odi 12c Getting Started Guide
30/114
30
3 Working with the ETL Project
T E (E T L) O D I S.
T :
S 3.1, "T E E"
S 3.2, "T D M"
S 3.3, "I C"
3.1 The Example Environment
T D .
T . F 31 .
31
T :
: T R .
A: A , O ( "" ).
: F (ASCII) .
-
7/13/2019 Odi 12c Getting Started Guide
31/114
A: T , O ( "" ). T .
3.2 The Data Models
T ODI :
O A
P
S A
T .
3.2.1 Orders ApplicationT A O RDBMS
:
SRCCITY
SRCCUSTOMER
SRCORDERS
SRCORDERLINES
SRCPRODUCT
SRCREGION
F 32 .
N , .
32
3.2.2 ParametersT F :
SRCSALES PERSON
SRCAGEGROUP
-
7/13/2019 Odi 12c Getting Started Guide
32/114
F 33 .
Figure 33 Parameters Schema Diagram
3.2.3 Sales Administration OracleT A O RDBMS :
TRGCITY
TRGCOUNTRY
TRGCUSTOMER
TRGPRODUCT
TRGPRODFAMILY TRGREGION
TRGSALES
F 34 .
34
-
7/13/2019 Odi 12c Getting Started Guide
33/114
3.3 Integration Challenges
T :
A
A V
T . D , :
T O A P S A .
A T G S O DI . T A .
Y L S A L TRGCUSTOMER L TRGSALES .
Y L S A .
B , O D I . T A .
Note: I , ETL. W , (, ) . F , O D I .
N D P , I ODI S.
-
7/13/2019 Odi 12c Getting Started Guide
34/114
4 Introduction to Using Oracle Data Integrator Studio
T O D I S.
4.1 Using the ODI Studio Navigators
ODI S N ODI :
D N
O N
T N
S N
T D N ( ) O N ( ). T N . S F D D T S N.
4.1.1 Starting Oracle Data Integrator Studio .
4.2 .
T ODI S:
O U :
ODIHOME///.
O W :
ODIHOME\\\.
Note: O W, ODI S
O , A > > > .
U S , I P
. P .
-
7/13/2019 Odi 12c Getting Started Guide
35/114
T ODI S . C C R
L N ODI G S OK.
41 12
4.2 Designer Navigator
D N , , .
T D N .
T
(, , , , , .)
T
(, , , .)
T D N F 42.
42
-
7/13/2019 Odi 12c Getting Started Guide
36/114
T D N :
P T P D N.
M T M
.
L P S T L P S
.
G O T G O G U
F, V, M, S.
S T S S
-
7/13/2019 Odi 12c Getting Started Guide
37/114
T G S:
I M , A, A .
I P , D A . Y .
T K M (KM) D P:
LKM SQL SQL (BI)
CKM O
IKM O I U
4.3 Operator Navigator
O N . I IT .T O N, , .
T O N :
.
T S L , , ,
, .
T H S
.
T L P E L P
R L P
T S
.
T S
T S S
.
-
7/13/2019 Odi 12c Getting Started Guide
38/114
5 Working with Mappings
T O D I. T . I :
L TRGCUSTOMER: T SRCCUSTOMER A TRG CUSTOMER A .
L TRGSALES: T SRC ORDERS SRCORDERLINES A TRGSALES A .
T :
S 5.1, "L TRGCUSTOMER M E"
S 5.2, "L TRGSALES M E"
5.1 Load TRG_CUSTOMER Mapping Example
T :
P I R
M D
C M
5.1.1 Purpose and Integration RequirementsT LTRGCUSTOMER .
T L TRGCUSTOMER SRCCUSTOMER A TRGCUSTOMER A .
H, SRCCUSTOMER . T :
T (AGERANGE) SRCAGEGROUP AGE .
T . (LASTNAME FIRST NAME) SRCSALESPERSON ID (SALESPERSID) .
-
7/13/2019 Odi 12c Getting Started Guide
39/114
T (0, 1, 2) DEAR (M, M, M).
T .T . F , .I , :
C 21 ( AGE > 21)
T (CITYID) TRG CITY ( FKCUSTCITY)
T S 5.1.3, "C M".
5.1.2 Mapping DefinitionT L TRGCUSTOMER . S S 5.1.3, "C M" .
T L TRGCUSTOMER :
O . T 51 .
51
S A TRGCUSTOMER O T
T . T 52 .
52
O
A
SRCCUSTOMER C
O
P SRCAGEGROUP A F
P SRCSALESPERSON S F
-
7/13/2019 Odi 12c Getting Started Guide
40/114
O . T 53 .
Table 53 Joins used in Load TRG_CUSTOMER
S R
C
J SRCSALES
PERSON SRC
CUSTOMER
SRCCUSTOMER.SALESPERSID =
SRCSALESPERSON.SALESPERSID
O . T 54 .
Table 54 Lookups used in Load TRG_CUSTOMER
S . T 55 .
Table 55 Transformation Rules used in Load TRG_CUSTOMER
C
T '
SRCCUSTOMER.AGE SRCAGE
GROUP.AGEMIN SRCAGE GROUP.AGEMAX
()
CUSTID SRC CUSTOMER.CUSTID SRC CUSTOMER.CUSTIDDEAR I SRCCUSTOMER.DEAR = 0
'MR'
I SRC CUSTOMER.DEAR = 1
'MRS' 'MS'
CASE
WHEN CUSTOMER.DEAR=0 THEN 'M'
WHEN CUSTOMER.DEAR=1 THEN 'M'
ELSE 'M'
END
CUSTNAME C SRC
CUSTOMER.FIRSTNAME SRC
CUSTOMER.LASTNAME
SRCCUSTOMER.FIRSTNAME ' '
UPPER(SRCCUSTOMER.LASTNAME)
ADDRESS SRCCUSTOMER.ADDDRESS SRCCUSTOMER.ADDRESS
CITYID SRCCUSTOMER.CITYID SRCCUSTOMER.CITYID
PHONE SRCCUSTOMER.PHONE SRCCUSTOMER.PHONE
AGE SRCCUSTOMER.AGE SRCCUSTOMER.AGE
AGERANGE SRCAGE GROUP.AGERANGE SRCAGE GROUP.AGERANGE
SALESPERS C
SRCSALESPERSON.FIRSTNAME
SRCSALESPERSON.LASTNAME
SRCSALESPERSON.FIRSTNAME ' '
UPPER(SRCSALESPERSON.LASTNAME)
-
7/13/2019 Odi 12c Getting Started Guide
41/114
5.1.3 Creating the MappingT L TRGCUSTOMER . T L TRGCUSTOMER :
1. I N M
2. D T D
3. D S D
4. D L T
5. D J S D
6. D M
7. D D L S (LKM)
8. D D I S (IKM)
9. D D C S
5.1.3.1 Insert a New MappingT :
1. I D N, D P .
2. E S A .
3. I S A , M F 51.
51
T M E .
4. E (L TRGCUSTOMER) N
F 52.
CREDATE T SYSDATE
UPDDATE T SYSDATE
-
7/13/2019 Odi 12c Getting Started Guide
42/114
52
E C E D .
5.1.3.2 Define the TargetT .
:
1. V L M E.2. I D N, M A .
3. S TRGCUSTOMER A F 53.
53
-
7/13/2019 Odi 12c Getting Started Guide
43/114
5.1.3.3 Define the SourceT . T : . T
A .
:
1. U , S D:
SRCCUSTOMER A
SRCSALESPERSON
2. T M F 54.
54
5.1.3.4 Define the LookupT ' .
A ( ) .
L L C.
:
1. F C , F 55 .
-
7/13/2019 Odi 12c Getting Started Guide
44/114
55
2. F P , SRCAGEGROUP M. TSRCAGEGROUP .
3. D L: A SRCCUSTOMER AGEMIN SRCAGEGROUP AGEMAX SRCAGEGROUP
56
-
7/13/2019 Odi 12c Getting Started Guide
45/114
4. S LOOKUP, LOOKUP P F 57.
57
5. M C = . Y L C
SRCCUSTOMER.AGE SRCAGEGROUP.AGEMIN
SRCAGEGROUP.AGEMAX
T SRCCUSTOMER SRCAGE GROUP
'
.
58
6. C .
-
7/13/2019 Odi 12c Getting Started Guide
46/114
5.1.3.5 Define the Join between the Source DatastoresT . T
T 59:
1. D JOIN .
2. I , SALESPERSID SRC CUSTOMER JOIN.
3. I , SALESPERSID SRCSALESPERSON .
59
510
-
7/13/2019 Odi 12c Getting Started Guide
47/114
5.1.3.6 Define the Target ExpressionsT : CUSTID, DEAR, CUST NAME,AGERANGE, SALESPERS, CREDATE UPDDATE.
T A M , .
1. F JOIN , , . A A , .
511
, , .
F .
C TRGCUSTOMER .
512
-
7/13/2019 Odi 12c Getting Started Guide
48/114
T CUSTID SRCCUSTOMER.CUSTID TRGCUSTOMER.CUSTID . N 2
, .
T CUSTID :
1. I SRCCUSTOMER , CUSTID .
2. D CUSTID T D F 513.
513
3. S , CUSTID T D P I.
A
T ' DEAR () (0 >'MR', 1 >'MRS', 2 >'MS').
T DEAR :
1. I T D, DEAR
P I.
2. I E , :
CASE
WHEN SRCCUSTOMER.DEAR = 0 THEN 'M'
WHEN SRCCUSTOMER.DEAR = 1 THEN 'M'
ELSE 'M'
END
-
7/13/2019 Odi 12c Getting Started Guide
49/114
: Y , SRC CUSTOMER.DEAR , E . Y E E.
A T .
T CUSTNAME :
1. I T D, CUSTNAME P I.
2. I E , :
SRCCUSTOMER.FIRSTNAME ' ' UPPER(SRCCUSTOMER.LASTNAME)
Tip: U E E . B E E, .
AA
T SRCAGEGROUP.AGERANGE TRGCUSTOMER.AGERANGE .
1. I T D, AGERANGE P I.
2. I E , :
SRC_AGE_GROUP.AGE_RANGE
:A ODI S. I E, SRC
, F 515.
515
Y AGERANGE SRCAGEGROUP
AGERANGE TRGCUSTOMER.
A
T .
T SALESPERS :
-
7/13/2019 Odi 12c Getting Started Guide
50/114
1. I T D, SALESPERS P I.
2. I E , :
SRC_SALES_PERSON.FIRST_NAME || ' ' ||
UPPER(SRC_SALES_PERSON.LAST_NAME)
A
T CREDATE :
1. I T D, CREDATE P I.
2. I E , : SYSDATE
3. V A .
4.U . T I.
5. T P I CREDATE F 516.
516
A
T UPDDATE :
1. I T D, UPDDATE P I.
2. I E , : SYSDATE
3. V A .4. U . T U.
T E E E . I . T E E E.
-
7/13/2019 Odi 12c Getting Started Guide
51/114
I E H , E E .
Y T D A F 517.
517
F TRGCUSTOMER M P
T I T I U
5.1.3.7 Define the Data Loading Strategies (LKM)
T P M E. OD I ' . I KM . T P KM .
L K M (LKM) IK M (IKM) .
Y SRCAGEGROUP, SRCSALESPERSON SRCCUSTOMER .
T :
1. I P M E, SRCAGEGROUP, SRCSALESPERSON . I ,
SRCAGEGROUPAP SRCSALESPERSONAP. T P I .
2. I P I, () L K M S F 518.
-
7/13/2019 Odi 12c Getting Started Guide
52/114
518
5.1.3.8 Define the Data Integration Strategies (IKM)A , .
T :
1. I P M E, TRGCUSTOMER
TARGETGROUP . T P I .
2. I P I, IKM S . I IKM , T I T I U L .
3. I , . T P I F 519.
-
7/13/2019 Odi 12c Getting Started Guide
53/114
519
Note: O K M P KM S . T K M . Y KM P.
F KM P, "I KM" F D' D .
5.1.3.9 Define the Data Control StrategyI S 5.1.3.7, "D D L S (LKM)" S 5.1.3.8, "D D I S (IKM)" . Y (CKM) .
T :
1. I M P TRGCUSTOMER P, C
K M, C K M.
2. I L , TRGCUSTOMER C
. S true.
-
7/13/2019 Odi 12c Getting Started Guide
54/114
PKTRGCUSTOMER
FKCUSTCITY
T C F 520
520
3. F , .
T L TRGCUSTOMER .
5.2 Load TRG_SALES Mapping Example
T :
P I R
M D
C M
5.2.1 Purpose and Integration Requirements
T LTRGSALES .
T SRCORDERS SRCORDERLINES A TRGSALES A . T . O CLO .
H, . F , . W . I , :
T (PRODUCTID) TRGPRODUCT ( FKSALESPROD
T (CUSTID) TRG
CUSTOMER ( FKSALESCUST
T S 5.2.3,
"C M".
-
7/13/2019 Odi 12c Getting Started Guide
55/114
5.2.2 Mapping DefinitionT L TRGSALES .S S 5.2.3, "C M" .
T L TRGSALES :
O . T 57 .
57
S A TRGSALES T S
A S
O
T . T 58 .
58
O
A
SRCORDERS O
O
O
A
SRCORDERLINES O
O . T 59 .
59
C O
J SRCORDERS
SRCORDER
LINES
SRCORDERS.ORDER ID =
SRCORDER LINES.ORDERID
O . T 510 .
510
O
(CLOSED)
SRCORDERS.STATUS = 'CLO'
O A O
-
7/13/2019 Odi 12c Getting Started Guide
56/114
S . T 511 .
Table 511 Transformation Rules used in Load TRG_SALES
()
CUSTID SRC ORDERS SRCORDERS.CUST ID
PRODUCTID
SRCORDERLINES
SRCORDER LINES.PRODUCTID
S ORDERID MIN(SRC ORDERS.ORDERID)A S ORDERDATE
SRCORDERSMIN(SRC ORDERS.ORDER DATE)
A L ORDERID MAX(SRC ORDERS.ORDERID)AA L ORDERDATE
SRCORDERSMAX(SRC ORDERS.ORDER DATE)
S QTY
SUM(SRCORDER LINES.QTY)
A S
SUM(SRCORDER LINES.AMOUNT)
A A AVG(SRCORDER LINES.AMOUNT)
5.2.3 Creating the MappingT L TRGSALES . T LTRGSALES :
1. I M
2. D T D
3. D S D
4. D J S D
5. D O F
6. D T R
7. D D L S (LKM)
8. D D I S (IKM)
9. D D C S
5.2.3.1 Insert a New MappingT :
1. I D N, D P .2. E S A .
3. I S A , M
.
4. E (L TRGSALES) N . C E
D .
-
7/13/2019 Odi 12c Getting Started Guide
57/114
5.2.3.2 Define the Target DatastoreT L TRGSALES :
1. G L M E.2. I D N, M A.
3. S TRGSALES A .
5.2.3.3 Define the Source DatastoresT L TRGSALES A .
T L TRGSALES :
1. I M , S D:
SRCORDERS A
SRCORDERLINES A
521
5.2.3.4 Define the Order FilterI , . A SRCORDERS .
:
1. I , STATUS SRCORDERS S D.
2. T F 522.
-
7/13/2019 Odi 12c Getting Started Guide
58/114
522
3. S S D P I.
4. I C P I, :SRC_ORDERS.STATUS = 'CLO'
5.2.3.5 Define Joins between the Source DatastoresT . T
T 59:
1. D JOIN C
2. D ORDERID SRCORDERS JOIN.
3. D ORDERID SRCORDERLINES JOIN.
A . T . T
:
SRCORDERS.ORDERID=SRCORDERLINES.ORDERID
5.2.3.6 Define the Transformation RulesM . T
AGGREGATE C.
1. F C , AGGREGATE .
2. D AGGREGATE TRGSALES .
T A, OK AGGREGATE
T .
-
7/13/2019 Odi 12c Getting Started Guide
59/114
3. D .
D A :
: D SRCORDERS.CUSTID CUSTID A C. T CUSTID SRCORDERS CUSTID .
: D SRCORDERLINES.PRODUCTID PRODUCTID A C. T PRODUCTID SRCORDERLINES PRODUCTID .
: D SRCORDERS.ORDERID E . E I :
MIN(SRC_ORDERS.ORDER_ID)
T ORDERID SRCORDERS FIRSTORDID .
A: D SRCORDERS.ORDERDATE I . E E :
MIN(SRC_ORDERS.ORDER_DATE)
T ORDERDATE SRCORDERS FIRSTORDDATE .
A: D SRCORDERS.ORDERID E . E I :
MAX(SRC_ORDERS.ORDER_ID)
T ORDERID SRCORDERS LASTORDID .
AA: D SRCORDERS.ORDERDATE E . E I :
-
7/13/2019 Odi 12c Getting Started Guide
60/114
MAX(SRC_ORDERS.ORDER_DATE)
T ORDERDATE SRCORDERS LASTORDDATE
.
: E I :
SUM(SRC_ORDER_LINES.QTY)
T QTY .
A: E E :
SUM(SRC_ORDER_LINES.AMOUNT)
T AMOUNT .
A: D SRCORDERLINES.AMOUNT E . E I :
AVG(SRC_ORDER_LINES.AMOUNT)
T PRODAVGPRICE .
R A F 523 .
N , : O D I , SQL .
523
-
7/13/2019 Odi 12c Getting Started Guide
61/114
524
:
C TRGSALES , P T I T I U.
5.2.3.7 Define the Data Loading Strategies (LKM)I P , O D I .
I P L K M (LKM).
T :1. I P M E, ' . I , AGGREGATEAP ODIDEMOTRGUNIT.
2. I P I, LKM ().A LKM S F 526.
525
526 ,
-
7/13/2019 Odi 12c Getting Started Guide
62/114
5.2.3.8 Define the Data Integration Strategies (IKM)A , .
T :
1. I P M E, T ( A). T
P I .
2. I P I, IKM IKM
S . I IKM , T
I T I U L .
3. I , .
5.2.3.9 Define the Data Control StrategyI S 5.2.3.7, "D D L S (LKM)" S 5.2.3.8, "D D I S (IKM)" . Y (CKM) .
T :
1. I P M E T,
.
Figure 527 Load TRG_SALES Mapping
-
7/13/2019 Odi 12c Getting Started Guide
63/114
2. I L TRGSALES, C. S
:
PKTRGSALES
FKSALESCUST FKSALESPROD
528
3. F , .
T A .
-
7/13/2019 Odi 12c Getting Started Guide
64/114
6 Implementing Data Quality Control
T . A .
T :
S 6.1, "I D I C"
S 6.2, "SRCCUSTOMER C E"
6.1 Introduction to Data Integrity Control
D .
A . Y , , , , .
O D I .
T : C F C. W .
S C . S ( ) ( , , .)
W O D I, , . T .
T . T '
. T "M" .
-
7/13/2019 Odi 12c Getting Started Guide
65/114
T :
. B ' . C .
' . T . T . M .
. E . I, . T , . I ,
( , , ) .
6.2 SRC_CUSTOMER Control Example
T (S C).
T A . T .
T :
O
I P
C C
R S C
F E C O N
I R O N
6.2.1 ObjectiveS . T . I
SRCCUSTOMER :
21 . H .
. H .
W .
-
7/13/2019 Odi 12c Getting Started Guide
66/114
6.2.2 Interpreting the ProblemE ( ), SRCCITY SRC CUSTOMER
.
6.2.3 Creating ConstraintsT :
A C
R C
6.2.3.1 Age ConstraintC . T
:
1. I M D N, A .
2. E SRCCUSTOMER .
3. R C F 61.
61
4. I D C E:
I N , . F : AGE > 21.
F T , .
I W , SQL :SRC_CUSTOMER.AGE > 21
Note:
Y W E E. T E E W .
T O D I . T R.
-
7/13/2019 Odi 12c Getting Started Guide
67/114
I M , :
Customer age is not over 21!
F 62 C E.
62
5. F F , .
6.2.3.2 Reference ConstraintT CITYID
SRCCUSTOMER SRCCITY .
T SRCCITY .
T :
1. I M D N, A .
2. E SRCCUSTOMER .
3. R C F 63.
-
7/13/2019 Odi 12c Getting Started Guide
68/114
63
4. I D R E:
F T , .
F M P M/T , A. T .
F T , . T .
F 64 R E.
64
5. I R E, A .
6. O C , A F 65.
-
7/13/2019 Odi 12c Getting Started Guide
69/114
Figure 65 Columns tab of the Reference Editor
A .
7. I :
C . T
. F C (F T) , .
F C (P T) , .
F 66 C R E .
66
N F T SRCCUSTOMER P T SRCCITY. N F T P T . I .
8. S > .
Tip: Y [CTRL S E.
6.2.4 Run the Static ControlR . Y SRCCUSTOMER S 6.2.3,"C C".
T :
1. I M D N, SRCCUSTOMER.
-
7/13/2019 Odi 12c Getting Started Guide
70/114
2. S > .
3. T E F 67.
67
4. C E .
5. T I D F 68.
68
6. C I D.
O D I .
6.2.5 Follow the Execution of the Control in Operator NavigatorT O N, .
T :
1. I S L O N, A E .
T S L , , , , .
2. R O N.
-
7/13/2019 Odi 12c Getting Started Guide
71/114
T F 69.
69
T 3 :
S ( , , )
S ( , , )
T ( , )
6.2.6 Interpreting the Results in Operator NavigatorT . T .
T :
D N I R
R I R
6.2.6.1 Determining the Number of Invalid RecordsT :
1. I S L O N, A E SRCCUSTOMER .
2. D SRCCUSTOMER S S E.
-
7/13/2019 Odi 12c Getting Started Guide
72/114
3. T R S .T , , , , .
F 610 S S E SRCCUSTOMER .
610
T N. E . N
SRCCUSTOMER 6 . T
. S S 6.2.6.2, "R I R"
.
6.2.6.2 Reviewing the Invalid RecordsY > ...
T SRCCUSTOMER :
1. I D N, A .
2. R SRCCUSTOMER .
3. S > ...
4. T E T E F 611.
-
7/13/2019 Odi 12c Getting Started Guide
73/114
611
T :
5 AGE > 21 ( 21 , AGE ).
1 FKCITYCUSTOMER (T CITYID SRCCITY ).
Y E. T , CITYID .
N AGE > 21 S 6.2.3.1, "A C".
N , .
-
7/13/2019 Odi 12c Getting Started Guide
74/114
7 Working with Packages
T P O D I. T A . A P .
T :
S 7.1, "I"
S 7.2, "L S A P E"
7.1 Introduction
T O D I.
7.1.1 Automating Data Integration FlowsT (, , ) .
T . H C 9, "D IA".
7.1.2 PackagesA .P . T , , :
S
S
D
D D
I G S , A . S , . F , TRGCUSTOMER TRGCITY .
I S 7.2, "L S A P E", D C 5, "W M".
-
7/13/2019 Odi 12c Getting Started Guide
75/114
7.1.2.1 ScenariosA (, , , ) . A (SQL, , )
.
O , W . A .
Note: O , ' , / . I .
S "W S" F D' D .
I C 9, "D I A", ADAEADA O DI S.
7.2 Load Sales Administration Package Example
T :
P
D P O D I
P A
C P
7.2.1 PurposeT L S A
S A .
7.2.2 Mappings Provided with Oracle Data IntegratorT M. T D F 71:
:
: TRGCITY . T .
: TRGCOUNTRY .T .
: TRGCUSTOMER . T S 5.1, "L TRGCUSTOMER M E".
-
7/13/2019 Odi 12c Getting Started Guide
76/114
: TRGPRODUCT . T .
A: TRGPROD FAMILY. T .
: TRGREGION . T .
A: TRGSALES . T S 5.2, "L TRGSALES M E".
:
T A. T D .
71
7.2.3 Problem AnalysisI A ( ), :
1. E S A D T 2. L TRGCOUNTRY L TRGCOUNTRY
3. L TRGREGION L TRGREGION
4. L TRGCITY L TRGCITY
5. L TRGPRODFAMILY L TRGPRODFAMILY
6. L TRGPRODUCT L TRGPRODUCT
7. L TRGCUSTOMER L TRGCUSTOMER
-
7/13/2019 Odi 12c Getting Started Guide
77/114
8. L TRGSALES L TRGSALES
S O D I P.
7.2.4 Creating the PackageT L S A P. T L S A P :
1. C N P
2. I S P
3. D S S P
7.2.4.1 Create a New PackageT P:
1. I D N, D P .
2. E S A .
3. I S A , P F 72.
72
T P E .
4. E P L S A N .
7.2.4.2 Insert the Steps in the PackageT L S A P:
1. S P :
D T (P)
L TRGCOUNTRY
L TRGREGION
L TRGCITY
L TRGCUSTOMER
-
7/13/2019 Odi 12c Getting Started Guide
78/114
L TRGPRODFAMILY
L TRGPRODUCT
L TRGSALEST P . N .
7.2.4.3 Define the Sequence of Steps in the PackageO , . T :
I F .
E : S F.
A ,
P. I , .
A P , F S, . T
L S A P S.
T L S A P:
Note: I P S 7.2.4.2, "I S P", D T ' . I , .
1. S D .
2. S . A
.
T :
1. I P , .
2. S D T .
3. K ( L TRGCOUNTRY ) .
A , .
4. R . T :
-
7/13/2019 Odi 12c Getting Started Guide
79/114
D T (F S)
L TRGCOUNTRY
L TRGREGION L TRGCITY
L TRGCUSTOMER
L TRGPRODFAMILY
L TRGPRODUCT
L TRGSALES
T P F 73.
73
5. F F , . T .
-
7/13/2019 Odi 12c Getting Started Guide
80/114
8 Executing Your Developments and Reviewing theResults
T L S A P
C 7, "W P" L TRGCUSTOMER
L TRGSALES C 5, "W M". T
.
T :
S 8.1, "E L S A P"
S 8.2, "E L TRGSALES M"
8.1 Executing the Load Sales Administration Package
T :
R P
F E P O N
I R L TRGCUSTOMER S S
8.1.1 Run the PackageT L S A P:
1. I D N, P S A .
2. S L S A P.
3. R .
4. I R D, .
5. T S S I D . C .
O D I .
8.1.2 Follow the Execution of the Package in Operator NavigatorT O N, .
T L S A P:
-
7/13/2019 Odi 12c Getting Started Guide
81/114
1. I S L O N, A E .
2. R O N .
T R :
3. T L S A P
F 81.
81
8.1.3 Interpreting the Results of the Load TRG_CUSTOMER Session StepT L TRGCUSTOMER . T L TRGCUSTOMER .
T :
D N P R
V R D
R I R I D
C I D
R P R
8.1.3.1 Determining the Number of Processed RecordsT L TRGCUSTOMER ( , , , ):
1. I S L O N, A E .
2. R O N .
-
7/13/2019 Odi 12c Getting Started Guide
82/114
3. E L S A P S S S E L TRGCUSTOMER . T 4.
4. O D S S E, R S
TRGCUSTOMER 31 2 .
:Y . T .
F 82 R S S S E:
82
8.1.3.2 Viewing the Resulting DataI , 31 TRGCUSTOMER .
T :
1. I D N, M A .
2. S TRGCUSTOMER .
3. R .N ... . T V
D E F 83.
83
-
7/13/2019 Odi 12c Getting Started Guide
83/114
8.1.3.3 Reviewing the Invalid Records and Incorrect Data
Y > ...
T TRGCUSTOMER :
1. I D N, A .
2. S TRGCUSTOMER .
3. R > ...
4. T E T E F 84.
84
T 2 .
I , :
R FKCUSTCITY ( , CITYID
TRGCITY ).
Y ODICHECKDATE
.
T .
-
7/13/2019 Odi 12c Getting Started Guide
84/114
9 Deploying Integrated Applications
T L S A P .
T :
S 9.1, "I"
S 9.2, "S C"
S 9.3, "R S"
S 9.4, "F E S"
9.1 Introduction
T (, , ) .
C 7, "W P" : P.
T : L S A P .
9.2 Scenario CreationT LOADSALESADMINISTRATION L SA P:
1. I P , S A P.
2. R L S A T NS F 91.
-
7/13/2019 Odi 12c Getting Started Guide
85/114
91
3. T N V S . L .
4. O D I . T S P E D P F 92.
92
9.3 Run the Scenario
S :
E S ODI S
E S C L E S W S.
T G S ODI S. S "E S" F D' D .
-
7/13/2019 Odi 12c Getting Started Guide
86/114
9.3.1 Executing a Scenario from ODI StudioY O D I S D ON.
T LOADSALESADMINISTRATION O D IS:
1. S LOADSALESADMINISTRATION P (D N) L P S ( D ON).
2. R, .
3. I E D, .
4. T S S I D . C . T
.
9.4 Follow the Execution of the ScenarioY O N, S 8.1.1, "R P".
I D N.
T LOADSALESADMINISTRATION D N:
1. I P D N, S L S A .
2. R D N .
3. T LOADSALESADMINISTRATION F 93.
Figure 93 LOAD_SALES_ADMINISTRATION Scenario Session Log
-
7/13/2019 Odi 12c Getting Started Guide
87/114
10 Using Oracle Data Integratorwith Oracle GoldenGate
T C D C (CDC) O
GG O D I.
T ODI G S VB :
://../////.
T :
S 10.1, "I"
S 10.2, "R O GG JA ODI S"
S 10.3, "I "
S 10.4, "S C D C"
S 10.5, S
10.1Introduction
T G S O GG 12. A A A. O GG ODI .
101
I O GG ODI S J K M: JKM O O C(OGG O).
-
7/13/2019 Odi 12c Getting Started Guide
88/114
P C D GG K M .
T D D C D C ODI.
10.1.1Connect to the ODI Work Repository1. O ODI S.
2. I , D D
.
3. C C L N D
.
102 12
T D N F 103.
-
7/13/2019 Odi 12c Getting Started Guide
89/114
103
T OD I O GG :
I M , A, , A :
o T A CE
O GG.o T A
CE CE A. T O GG CE A.T CE ODI GG.
-
7/13/2019 Odi 12c Getting Started Guide
90/114
I P , D D D .
o T M CE A
10 4
o T D M CE CE ODI CE ODI GG.T P D D I GG .
105
T K M (KM) D D:
IKM O I U
IKM O I
IKM SQL C A LKM O O P (DB L)
LKM SQL SQL (BI)
CKM O
JKM O O C (OGG O)
-
7/13/2019 Odi 12c Getting Started Guide
91/114
10.2Reviewing the Oracle GoldenGate JAgent configuration in ODI Studio
O D I 12 O GG GG
JA. T JA ODI D S T. I GG
JA () GG JA ().
W :
1. O T N A
.
2. S .
106
3. D . I F 10 7
ODI JA
GG .
T ODI JA
GG .
-
7/13/2019 Odi 12c Getting Started Guide
92/114
107
T JA
GG D T
.
10.3Initial load
B
(OGGCUSTOMER O A ), (OGGCUSTOMER S
A ) (TRGCUSTOMER O A ) .
10.3.1 Starting the ODI and OGG Demo Client
1. G VB
2. D D D C L .
108
T ODI GG
. O S
-
7/13/2019 Odi 12c Getting Started Guide
93/114
T . W
.
N: I S T C
P ODI S. S
.
10.3.2 Running the Mappings
W ODI GG
(CE A) D I
(CE A).
1. G D, .
T M
CE A CE
A
2. R
109
-
7/13/2019 Odi 12c Getting Started Guide
94/114
L
.
3. G D D C
S 1010
W CE A.
1. G D
2. L CE C
E . I
A C 7
: ADEFEECEDAA. Y
:
-
7/13/2019 Odi 12c Getting Started Guide
95/114
1011
R
.
3. N D . T M
CE
CE A CE
4. R CE
-
7/13/2019 Odi 12c Getting Started Guide
96/114
1012
L , B D
S
.
-
7/13/2019 Odi 12c Getting Started Guide
97/114
5. G ODI OGG
T
1013
N: I CE
. P ADEFEECEDAA
S #2 CE.
N GG ,
ODI CDC
CE A CE A .
10.4Setting up Changed Data Capture
T ODI CDC O GG C D
M D.
1. I ODI S D .
2. D A
.
1014
T J C D C
ODI . I O GG
, C (
-
7/13/2019 Odi 12c Getting Started Guide
98/114
)J K M.
T JKM ODI CDC
GG .
T GG
C D ODI S . I
C D .
3. Y T A,
CA P S
.
1015
N GG .
F ODI CDC GG 10.1 .
-
7/13/2019 Odi 12c Getting Started Guide
99/114
4. G VB
5. S GG C D S .
I M JA GG .
1016
6. W ODI S
T C
.
1017
T ,
.
T GG , .
1. G D
2. R A C D C A
CDC. T ODI
C D C . C .
-
7/13/2019 Odi 12c Getting Started Guide
100/114
1018
3. N S ODI CDC . A
. S
.
E
.
R A C D C
-
7/13/2019 Odi 12c Getting Started Guide
101/114
1019
I () ODIDEMO A
+ ODIDEMO . C OK .
1020
-
7/13/2019 Odi 12c Getting Started Guide
102/114
C .
4. A S , O
F 1022 . C R .
1021
5. G D A C
D C
-
7/13/2019 Odi 12c Getting Started Guide
103/114
1022
L
.
W S O,
F 1023
-
7/13/2019 Odi 12c Getting Started Guide
104/114
1023
S T ( ) S 1
A ( ).
10.5Synchronizing the changed dataN ODI CDC GG ,
M GG
TRGCUSTOMER.
10.5.1 Load TRG_CUSTOMER Mapping
1. I D,
2. E D
3. O CEM, L
CE.I CE M A . I
GG ( A).
ODI J
M. I P , J
-
7/13/2019 Odi 12c Getting Started Guide
105/114
1024
A D F ODIDEMO S ODI CDC .
4. C P M
-
7/13/2019 Odi 12c Getting Started Guide
106/114
1025
5. T .
B TRGCUSTOMER
.
F TRGCUSTOMER
O GG.
6. C F P D.
7. C CE DDE P. T
D ODI
CDC GG
.
1026
-
7/13/2019 Odi 12c Getting Started Guide
107/114
T M
:
. A CE A CE
ODI. T IKM C A
B
. A
CE A CE
A GG
CE CE,
A. T IKM
F
10.5.2 Sync Data Package
A CEM
. B M P
M CDC .
1. E D
2. O DP
1027
T O GG
D I.
T ODI T C CDC
OWFLD,
GG. O M E
ODIDEMO .
-
7/13/2019 Odi 12c Getting Started Guide
108/114
T M CE F
ODIDEMO S 10.3.3.
O M M ODIDEMO S.
F P S. I
P S . T
P
.
3. R DP
1028
L
.
4. G O S . E
D, S D
1029
-
7/13/2019 Odi 12c Getting Started Guide
109/114
T P C . W
D D
C.
5. G D D C
. Y
GG S S
D I S T. T
F 1029 .
1030
6. Y O CDAA S
.
7. O, S O. R
S R ( P ) .
C .
1031
Y O D I
O GG.
-
7/13/2019 Odi 12c Getting Started Guide
110/114
11 Going Further with Oracle Data Integrator
T O D I. T
:
S 11.1, "S"
S 11.2, "W O D I?"
S 11.3, "L M"
11.1Summary
C! Y ETL O D I. Y ODI C DC O GG.
I G S , :
C A A (C 5, "W M")
D A (C 6,
"I D Q C")
S (C 7, "W P")
P (C 9, "D IA")
U O D I O GG (C 10,U O D I O GG)
11.1.1Getting Started Tutorial SolutionF ETL P, ODIS E OTN. T S E , XML .
1. T ODI .://../////122047298.
2. C ODI G S S I C
N
-
7/13/2019 Odi 12c Getting Started Guide
111/114
111
3. S S I S I ,
12.
112
4. W 1 E K
5. C ODI G S
D .
P ODI D .://../////.
-
7/13/2019 Odi 12c Getting Started Guide
112/114
11.2What else can you do with Oracle Data Integrator?
Y O D I D W. B O D I , , :
D M
P D I
D R
F, G S O D I . O D I , B D H, S HB, ERP
CRM, , , LDAP , XML , .
O D I , , . I I S, , .
S O D I :
: O D I , .T IT : , .
: O D I, , . W , .
, : O D I, . T .
: O D I ETL, D M, M , B A
M (BAM), B P M (BPM), B P R(BPR), W S D,E, S .
-
7/13/2019 Odi 12c Getting Started Guide
113/114
11.3Learn More
Y O D
I T 101.
Table 111 Oracle Data Integrator Documentation
Document Description
Oracle Fusion Middleware Installation Guide for Oracle DataIntegrator
Provides Oracle Data Integrator installationinformation including pre-installation requirementsand troubleshooting.
Oracle Fusion Middleware Upgrade Guide for Oracle DataIntegrator
Provides 12c upgrade information for Oracle DataIntegrator.
Oracle Fusion Middleware Developer's Guide for Oracle DataIntegrator
Provides guidelines for developers interested in usingOracle Data Integrator for integration projects.
Oracle Fusion Middleware Connectivity and KnowledgeModules Guide for Oracle Data Integrator
Describes Oracle Data Integrator Knowledge Modulesand technologies and how to use them in integrationprojects.
Oracle Fusion Middleware Knowledge Module Developer'sGuide for Oracle Data Integrator
Describes how to develop your own KnowledgeModules for Oracle Data Integrator.
I , G SD E, :
://..//////
T O D I O T N O D I:
://../////.
V E D. T O E (OBE)
OD I S.
Y O D I O D I O T N, :
://../////.
T O DI 12, "W' N O D I?" F D' D R N.
T O D I
-
7/13/2019 Odi 12c Getting Started Guide
114/114
Oracle Corporation
World Headquarters
500 Oracle Parkway
Redwood Shores, CA 94065
U.S.A.
World ide Inq iries
Copyright 2014, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only and
the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other
warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or
fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are
formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any
means, electronic or mechanical, for any purpose, without our prior written permission.