Table of Contents
- Title and Copyright Information
- Preface
- What's New In Oracle Data Integrator?
- Part I Introduction to Developing with Oracle Data Integrator
-
Part II Managing and Reverse-Engineering Metadata
- 3 Creating and Using Data Models and Datastores
- 4 Using Journalizing
- 5 Creating Data Models with Common Format Designer
-
Part III Developing Integration Projects
- 6 Creating an Integration Project
- 7 Creating and Using Packages
-
8
Creating and Using Mappings
- Introduction to Mappings
- Creating a Mapping
-
Using Mapping Components
- The Expression Editor
- Source and Target Datastores
- Creating Multiple Targets
- Adding a Reusable Mapping
- Creating Aggregates
- Creating Distincts
- Creating Expressions
- Creating Filters
- Creating Joins and Lookups
- Creating Pivots
- Creating Sets
- Creating Sorts
- Creating Splits
- Creating Subquery Filters
- Creating Table Functions
- Creating Unpivots
- Creating Flatten Components
- Creating Jagged Components
- Creating a Mapping Using a Dataset
-
Physical Design
- About the Physical Mapping Diagram
- Selecting LKMs, IKMs and CKMs
- Configuring Execution Locations
- Adding Commands to be Executed Before and After a Mapping
- Configuring In-Session Parallelism
- Configuring Parallel Target Table Load
- Configuring Temporary Indexes
- Configuring Journalizing
- Configuring Extraction Options
- Creating and Managing Physical Mapping Designs
- Reusable Mappings
- Editing Mappings Using the Property Inspector and the Structure Panel
- Flow Control and Static Control
- Designing E-LT and ETL-Style Mappings
-
9
Creating and Using Dimensions and Cubes
- Overview of Dimensional Objects
- Orphan Management
- Creating Dimensional Objects through ODI
- Using Dimensional Components in Mappings
- Expanding Dimensional Components
- 10 Using Compatibility Mode
-
11
Creating and Using Procedures, Variables, Sequences, and User Functions
- Working with Procedures
-
Working with Variables
- Introduction to Variables
- Creating Variables
-
Using Variables
- Using Variables in Packages
- Using Variables in Mappings
- Using Variables in Object Properties
- Using Variables in Procedures
- Using Variables within Variables
- Using Variables in the Resource Name of a Datastore
- Using Variables in a Server URL
- Using Variables in On Connect/Disconnect Commands
- Passing a Variable to a Scenario
- Generating a Scenario for a Variable
- Tracking Variables and Sequences
- Working with Sequences
- Working with User Functions
- 12 Using Scenarios
- 13 Using Load Plans
-
14
Using Web Services
- Introduction to Web Services in Oracle Data Integrator
- Oracle Data Integrator Run-Time Services and Data Services
-
Invoking Third-Party Web Services
- Introduction to Web Service Invocation
- Creating a SOAP Web Service Data Server
- Creating a New Physical Schema for a SOAP Web Service Data Server
- Creating a REST Service Data Server
- Creating a New Physical Schema for a REST Service Data Server
- Creating Logical Schema for a REST Service Data Server
-
Using HTTP Analyzer
- Using HTTP Analyzer: Main Steps
- What Happens When You Run the HTTP Analyzer
- How to Specify HTTP Analyzer Settings
- How to Use the Log Window
- How to Use the Test Window
- How to Use the Instances Window
- How to Use Multiple Instances
- How to Configure External Web Browsers
- Using Credentials With HTTP Analyzer
- Using SSL With HTTP Analyzer
- How to Debug Web Pages Using the HTTP Analyzer
- How to Use Rules to Determine Behavior
- How to Set Rules
- Reference: Troubleshooting the HTTP Analyzer
- Using the OdiInvokeWebService Tool
- Using the odiInvokeRESTfulService tool
- 15 Using Shortcuts
- 16 Using Groovy Scripting
- 17 Using Component KMs
- 18 Using Flexfields
-
Part IV Managing Integration Projects
- 19 Exchanging Global ODI Objects
- 20 Organizing and Documenting Integration Projects
- 21 Using Version Control (Legacy Mode)
-
22
Integrating ODI with Version Control Systems
- Introduction to ODI-VCS integration
- Understanding Generic Profiles in ODI
-
Setting up a Version Control System
- Switching Between Different Versioning Applications
- Creating or Editing a VCS Connection
- Cloning Remote Git Repository in Local Directory
- Configuring Subversion Settings
- Configuring ODI Repository with VCS
- Reconfiguring ODI Repository with VCS Repository
- Creating a Default Subversion Project Structure
- Erasing/Detaching Existing Work Repository from Master Repository
- Populating an ODI Repository from a VCS Branch/Trunk or Tag
- Managing Tags
- Unlocking the ODI Repository
-
Managing Versions
- Adding Non-versioned ODI Objects to the VCS Repository
- Adding Non-versioned Child Objects under a Versioned Container to the VCS Repository
- Adding a Single Non-versioned ODI Object to the VCS Repository
- Deleting, Moving, and Renaming a Version Controlled ODI Object in the VCS Repository
- Creating Versions of a Version Controlled ODI Object
- Restoring a Version Controlled ODI Object to its Previous Version
- Restoring a Version Controlled ODI Object Deleted in ODI Repository
- Viewing Pending Changes from ODI Repository
- Viewing the Version History of a Version Controlled ODI Object
- Comparing Versions of an ODI Object from the Version History Window
- Viewing Version Tree of a Version Controlled ODI Object
- Comparing Versions of an ODI Object from the Version Tree Editor
- Performing a Merge
-
23
Release Management
- Managing ODI Releases
- Types of Deployment Archives
- Creating a Deployment Archive from a VCS Label
- Creating an Initial Deployment Archive from the ODI Repository
- Creating a Patch Deployment Archive from the ODI Repository
- Viewing Available Deployment Archives
- Initializing an ODI Repository Using an Initial Deployment Archive
- Updating an ODI Repository Using a Patch Deployment Archive
- Viewing Deployment Archives Applied in an ODI Repository
- Rolling Back a Patch Deployment Archive
-
24
Life Cycle Management Guidelines
- Guidelines for Choosing the Authentication Type
- General Branching Guidelines
- General Tagging Guidelines
- Branching Guidelines for Single Development Team
- Branching Guidelines for Parallel Development Teams
- Guidelines for Release Branches for Parallel Development Teams
- Guidelines for Versioning During Development
- Guidelines for Deployment in Testing and Production Environments
- Guidelines for Initial Deployment and Patching
- 25 Exporting and Importing
- A Accessibility Features in ODI