List of Figures

• A-1 Opening ODI Studio
• A-2 ODI Studio New Gallery
• A-3 ODI Studio New Gallery Create Master Repository
• A-4 ODI Studio Master Repository Creation Wizard
• A-5 ODI Studio Master Repository Successful Creation
• A-6 ODI Studio Master Repository Creation Password
• A-7 ODI Studio Master Repository Creation Finish
• A-8 ODI Studio Master Repository Creation Complete
• A-9 ODI Studio New Gallery ODI Repository Login
• A-10 ODI Studio Repository Connection Information
• A-11 ODI Studio Repository Connection Successful
• A-12 ODI Studio Connect to Repository
• A-13 Oracle Data Integrator Login
• A-14 Oracle Data Integrator NCC Master Repository Topology
• A-15 ODI Topology Navigator New Work Repository
• A-16 ODI Studio Create Work Repository Test Connection
• A-17 ODI Repository Create Work Repository Successful Connection
• A-18 ODI Studio Create ODI Work Repository Properties
• A-19 ODI Studio Create ODI Work Repository Starting ODI Action
• A-20 ODI Studio Create ODI Work Repository Create Login
• A-21 ODI Studio ODI Work Repository Enter Login Name
• A-22 ODI Studio ODI Work Repository Topology
• A-23 ODI Studio Disconnect from Master Repository
• A-24 ODI Studio Connect to Repository NCC Work Repository
• A-25 ODI Studio Oracle Data Integrator Login
• A-26 ODI Studio Designer Tab
• A-27 ODI Studio Import Master Repository
• A-28 ODI Studio Import Master Repository Mode and Options
• A-29 ODI Studio Open and Import Master Repository
• A-30 ODI Studio Import Master Repository Progress
• A-31 ODI Studio Import Master Repository Report
• A-32 ODI Studio Import Work Repository
• A-33 ODI Studio Import Work Repository from Zip File
• A-34 ODI Studio Open Work Repository
• A-35 ODI Studio Open and Import Work Repository Progress
• A-36 ODI Studio Import Work Repository Warning
• A-37 ODI Studio Import Work Repository Report
• A-38 ODI Studio Designer Tab Viewing Projects and Models
• A-39 ODI Studio Physical Data Servers
• A-40 ODI Studio Data Server Definition Dialog
• A-41 ODI Studio Data Server JDBC Tab
• A-42 ODI Studio Data Server Test Connection
• A-43 ODI Studio Physical Architecture Data Server Node
• A-44 ODI Studio Physical Schema Definition Tab
• A-45 ODI Studio Logical Architecture for Logical Data Server
• A-46 ODI Studio Logical Data Server Definition Tab for Logical Schema
• A-47 Changing Directory to the Oracle GoldenGate Installation Path
• A-48 Commands to Set Database Options for Oracle GoldenGate Configuration
• A-49 Configuring Oracle GoldenGate
• A-50 Oracle GoldenGate Configuration Running ddl_setup Script
• A-51 Oracle GoldenGate Configuration Values from ddl_setup Script
• A-52 Oracle GoldenGate Configuration with Script Complete ddl_setup Screen
• A-53 Oracle GoldenGate Configuration for Scripts: role_setup.sql,
• B-1 Opening ODI Studio
• B-2 ODI Studio New Gallery
• B-3 ODI Studio New Gallery Create Master Repository
• B-4 ODI Studio Master Repository Creation Wizard
• B-5 ODI Studio Master Repository Successful Creation
• B-6 ODI Studio Master Repository Creation Password
• B-7 ODI Studio Master Repository Creation Finish
• B-8 ODI Studio Master Repository Creation Complete
• B-9 ODI Studio New Gallery ODI Repository Login
• B-10 ODI Studio Repository Connection Information
• B-11 ODI Studio Repository Connection Successful
• B-12 ODI Studio Connect to Repository
• B-13 Oracle Data Integrator Login
• B-14 Oracle Data Integrator Master Repository Topology
• B-15 ODI Topology Navigator New Work Repository
• B-16 ODI Studio Create Work Repository Test Connection
• B-17 ODI Repository Create Work Repository Successful Connection
• B-18 ODI Studio Create ODI Work Repository Properties
• B-19 ODI Studio Create ODI Work Repository Starting ODI Action
• B-20 ODI Studio Create ODI Work Repository Create Login Name
• B-21 ODI Studio Create ODI Work Repository Create Login
• B-22 ODI Studio ODI Work Repository Topology
• B-23 ODI Studio Disconnect from Master Repository
• B-24 ODI Studio Connect to Work Repository
• B-25 ODI Studio Oracle Data Integrator Login
• B-26 ODI Studio Designer Tab
• B-27 ODI Studio Import Master Repository
• B-28 ODI Studio Import Master Repository Mode and Options
• B-29 Import Master Repository
• B-30 ODI Studio Import Master Repository Progress
• B-31 Import Repository Report
• B-32 ODI Studio Import Work Repository
• B-33 ODI Studio Import Work Repository from Zip File
• B-34 ODI Studio Import Work Repository from Zip File
• B-35 ODI Studio Open and Import Work Repository Progress
• B-36 ODI Studio Import Work Repository Warning
• B-37 ODI Studio Import Work Repository Report
• B-38 Shows the ODI Designer Navigator with Projects and Models
• B-39 ODI Studio Physical Data Servers
• B-40 ODI Studio Data Server Definition Dialog
• B-41 ODI Studio Data Server JDBC Tab
• B-42 ODI Studio Data Server Test Connection
• B-43 Test Connection Information Dialog
• B-44 ODI Studio Physical Architecture Data Server Node
• B-45 ODI Studio Physical Schema Definition Tab
• B-46 ODI Studio Logical Architecture for Logical Data Server
• B-47 ODI Studio Logical Data Server Definition Tab for Logical Schema
• B-48 ODI Studio Logical Data Server Context Tab
• B-49 Changing Directory to the Oracle Database Installation Path
• B-50 Changing Directory to the Oracle Database Installation Path
• B-51 ODI Studio Import Master Repository
• B-52 Reimport: Import From a Folder
• B-53 ODI Studio Open and Import Master Repository
• B-54 ODI Studio Import Master Repository Progress
• B-55 Reimport: Import Report Listing
• B-56 ODI Studio Import Work Repository
• B-57 ODI Studio Import Work Repository from Zip File
• B-58 ODI Studio Import Work Repository from Zip File
• B-59 ODI Studio Open and Import Work Repository Progress
• B-60 Reimport: Work Repository Warning Message Dialog
• B-61 Reimport: Work Repository Report
• B-62 Shows the ODI Designer Navigator with Projects and Models
• B-63 Troubleshooting BRM Adapter Problems
• B-64 Renumber Master Repository
• B-65 Renumber Repository Step 1
• B-66 Renumber Repository Step 2
• B-67 Check Repository ID
• B-68 Renumber Work Repository
• B-69 Renumber Work Repository Step 1
• B-70 Renumber Work Repository Step 2
• B-71 Renumber Work Repository Step 3
• B-72 Verify the Renumber Operation
• B-73 Verify the Changed Repository ID