Table of Contents
- Title and Copyright Information
- Preface
- Part I Introduction to Developing with Oracle Data Integrator
-
Part II Managing and Reverse-Engineering Metadata
-
3
Creating and Using Data Models and Datastores
- 3.1 Introduction to Models
- 3.2 Creating and Reverse-Engineering a Model
- 3.3 Creating and Reverse-Engineering a Datastore
- 3.4 Editing and Viewing a Datastore's Data
- 3.5 Using Partitioning
- 3.6 Checking Data Quality in a Model
- 4 Using Journalizing
- 5 Creating Data Models with Common Format Designer
-
3
Creating and Using Data Models and Datastores
-
Part III Developing Integration Projects
- 6 Creating an Integration Project
- 7 Creating and Using Packages
-
8
Creating and Using Mappings
- 8.1 Introduction to Mappings
- 8.2 Creating a Mapping
-
8.3
Using Mapping Components
- 8.3.1 The Expression Editor
- 8.3.2 Source and Target Datastores
- 8.3.3 Creating Multiple Targets
- 8.3.4 Adding a Reusable Mapping
- 8.3.5 Creating Aggregates
- 8.3.6 Creating Distincts
- 8.3.7 Creating Expressions
- 8.3.8 Creating Filters
- 8.3.9 Creating Joins and Lookups
- 8.3.10 Creating Pivots
- 8.3.11 Creating Sets
- 8.3.12 Creating Sorts
- 8.3.13 Creating Splits
- 8.3.14 Creating Subquery Filters
- 8.3.15 Creating Table Functions
- 8.3.16 Creating Unpivots
- 8.3.17 Creating Flatten Components
- 8.3.18 Creating Jagged Components
- 8.4 Creating a Mapping Using a Dataset
-
8.5
Physical Design
- 8.5.1 About the Physical Mapping Diagram
- 8.5.2 Selecting LKMs, IKMs and CKMs
- 8.5.3 Configuring Execution Locations
- 8.5.4 Adding Commands to be Executed Before and After a Mapping
- 8.5.5 Configuring In-Session Parallelism
- 8.5.6 Configuring Parallel Target Table Load
- 8.5.7 Configuring Temporary Indexes
- 8.5.8 Configuring Journalizing
- 8.5.9 Configuring Extraction Options
- 8.5.10 Creating and Managing Physical Mapping Designs
- 8.6 Reusable Mappings
- 8.7 Editing Mappings Using the Property Inspector and the Structure Panel
- 8.8 Flow Control and Static Control
- 8.9 Designing E-LT and ETL-Style Mappings
-
9
Creating and Using Dimensions and Cubes
- 9.1 Overview of Dimensional Objects
- 9.2 Orphan Management
- 9.3 Creating Dimensional Objects through ODI
- 9.4 Using Dimensional Components in Mappings
- 9.5 Expanding Dimensional Components
- 10 Using Compatibility Mode
-
11
Creating and Using Procedures, Variables, Sequences, and User Functions
- 11.1 Working with Procedures
-
11.2
Working with Variables
- 11.2.1 Introduction to Variables
- 11.2.2 Creating Variables
-
11.2.3
Using Variables
- 11.2.3.1 Using Variables in Packages
- 11.2.3.2 Using Variables in Mappings
- 11.2.3.3 Using Variables in Object Properties
- 11.2.3.4 Using Variables in Procedures
- 11.2.3.5 Using Variables within Variables
- 11.2.3.6 Using Variables in the Resource Name of a Datastore
- 11.2.3.7 Using Variables in a Server URL
- 11.2.3.8 Using Variables in On Connect/Disconnect Commands
- 11.2.3.9 Passing a Variable to a Scenario
- 11.2.3.10 Generating a Scenario for a Variable
- 11.2.3.11 Tracking Variables and Sequences
- 11.3 Working with Sequences
- 11.4 Working with User Functions
- 12 Using Scenarios
- 13 Using Load Plans
-
14
Using Web Services
- 14.1 Introduction to Web Services in Oracle Data Integrator
- 14.2 Oracle Data Integrator Run-Time Services and Data Services
-
14.3
Invoking Third-Party Web Services
- 14.3.1 Introduction to Web Service Invocation
- 14.3.2 Creating a SOAP Web Service Data Server
- 14.3.3 Creating a New Physical Schema for a SOAP Web Service Data Server
- 14.3.4 Creating a REST Service Data Server
- 14.3.5 Creating a New Physical Schema for a REST Service Data Server
- 14.3.6 Creating Logical Schema for a REST Service Data Server
-
14.3.7
Using HTTP Analyzer
- 14.3.7.1 Using HTTP Analyzer: Main Steps
- 14.3.7.2 What Happens When You Run the HTTP Analyzer
- 14.3.7.3 How to Specify HTTP Analyzer Settings
- 14.3.7.4 How to Use the Log Window
- 14.3.7.5 How to Use the Test Window
- 14.3.7.6 How to Use the Instances Window
- 14.3.7.7 How to Use Multiple Instances
- 14.3.7.8 How to Configure External Web Browsers
- 14.3.7.9 Using Credentials With HTTP Analyzer
- 14.3.7.10 Using SSL With HTTP Analyzer
- 14.3.7.11 How to Debug Web Pages Using the HTTP Analyzer
- 14.3.7.12 How to Use Rules to Determine Behavior
- 14.3.7.13 How to Set Rules
- 14.3.7.14 Reference: Troubleshooting the HTTP Analyzer
- 14.3.8 Using the OdiInvokeWebService Tool
- 14.3.9 Using the odiInvokeRESTfulService tool
- 15 Using Shortcuts
- 16 Using Groovy Scripting
- 17 Using Component KMs
-
Part IV Managing Integration Projects
- 18 Exchanging Global ODI Objects
- 19 Organizing and Documenting Integration Projects
- 20 Using Version Control (Legacy Mode)
-
21
Integrating ODI with Version Control Systems
- 21.1 Introduction to ODI VCS integration
- 21.2 Understanding Generic Profiles in ODI
-
21.3
Setting up a Version Control System
- 21.3.1 Switching Between Different Versioning Applications
- 21.3.2 Creating or Editing a VCS Connection
- 21.3.3 Cloning Remote Git Repository in Local Directory
- 21.3.4 Configuring Subversion Settings
- 21.3.5 Configuring ODI Repository with VCS
- 21.3.6 Reconfiguring ODI Repository with VCS Repository
- 21.3.7 Creating a Default Subversion Project Structure
- 21.4 Erasing/Detaching Existing Work Repository from Master Repository
- 21.5 Populating an ODI Repository from a VCS Branch/Trunk or Tag
- 21.6 Managing Tags
- 21.7 Unlocking the ODI Repository
-
21.8
Managing Versions
- 21.8.1 Adding Non-versioned ODI Objects to the VCS Repository
- 21.8.2 Adding Non-versioned Child Objects under a Versioned Container to the VCS Repository
- 21.8.3 Adding a Single Non-versioned ODI Object to the VCS Repository
- 21.8.4 Deleting, Moving, and Renaming a Version Controlled ODI Object in the VCS Repository
- 21.8.5 Creating Versions of a Version Controlled ODI Object
- 21.8.6 Restoring a Version Controlled ODI Object to its Previous Version
- 21.8.7 Restoring a Deleted Version Controlled ODI Object in ODI Repository
- 21.8.8 Viewing Pending Changes from ODI Repository
- 21.8.9 Viewing the Version History of a Version Controlled ODI Object
- 21.8.10 Comparing Versions of an ODI Object from the Version History Window
- 21.8.11 Viewing Version Tree of a Version Controlled ODI Object
- 21.8.12 Comparing Versions of an ODI Object from the Version Tree Editor
- 21.9 Performing Pull/Push
- 21.10 Performing a Merge
- 21.11 Working with Object Flags
-
22
Release Management
- 22.1 Managing ODI Releases
- 22.2 Types of Deployment Archives
- 22.3 Creating a Deployment Archive from a VCS Label
- 22.4 Creating an Initial Deployment Archive from the ODI Repository
- 22.5 Creating a Patch Deployment Archive from the ODI Repository
- 22.6 Viewing Available Deployment Archives
- 22.7 Initializing an ODI Repository Using an Initial Deployment Archive
- 22.8 Updating an ODI Repository Using a Patch Deployment Archive
- 22.9 Viewing Deployment Archives Applied in an ODI Repository
- 22.10 Rolling Back a Patch Deployment Archive
-
23
Life Cycle Management Guidelines
- 23.1 Guidelines for Choosing the Authentication Type
- 23.2 General Branching Guidelines
- 23.3 General Tagging Guidelines
- 23.4 Branching Guidelines for Single Development Team
- 23.5 Branching Guidelines for Parallel Development Teams
- 23.6 Guidelines for Release Branches for Parallel Development Teams
- 23.7 Guidelines for Versioning During Development
- 23.8 Guidelines for Deployment in Testing and Production Environments
- 23.9 Guidelines for Initial Deployment and Patching
-
24
Exporting and Importing
- 24.1 Import and Export Concepts
- 24.2 Exporting and Importing Objects
- 24.3 Repository-Level Export/Import
- 24.4 Exporting the Technical Environment
- 24.5 Exporting and Importing the Log
- A Accessibility Features in ODI