Go to main content
1/34
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
What's New In Oracle Data Integrator?
Part I Introduction to Developing with Oracle Data Integrator
1
Overview of an Integration Project
Oracle Data Integrator Project Quick Start List
2
Overview of Oracle Data Integrator Topology
Introduction to the Oracle Data Integrator Topology
Physical Architecture
Contexts
Logical Architecture
Agents
Languages
Repositories
Part II Managing and Reverse-Engineering Metadata
3
Creating and Using Data Models and Datastores
Introduction to Models
Datastores
Data Integrity
Reverse-engineering
Changed Data Capture
Creating and Reverse-Engineering a Model
Creating a Model
Creating a Model and Topology Objects
Reverse-engineering a Model
Creating and Reverse-Engineering a Datastore
Creating a Datastore
Reverse-Engineering File Datastores
Reverse-Engineering Fixed Files
Reverse-Engineering Delimited Files
Reverse-Engineering COBOL Files
Adding and Deleting Datastore Attributes
Adding and Deleting Constraints and Filters
Keys
References
Conditions
Mandatory Attributes
Filter
Editing and Viewing a Datastore's Data
Using Partitioning
Manually Defining Partitions and Sub-Partitions of Model Datastores
Checking Data Quality in a Model
Introduction to Data Integrity
Checking a Constraint
Perform a Static Check on a Model, Sub-Model or Datastore
Reviewing Erroneous Records
4
Using Journalizing
Introduction to Changed Data Capture
The Journalizing Components
Simple vs. Consistent Set Journalizing
Setting up Journalizing
Setting up and Starting Journalizing
Journalizing Infrastructure Details
Journalizing Status
Using Changed Data
Viewing Changed Data
Using Changed Data: Simple Journalizing
Using Changed Data: Consistent Set Journalizing
Journalizing Tools
Package Templates for Using Journalizing
5
Creating Data Models with Common Format Designer
Introduction to Common Format Designer
What is a Diagram?
Why assemble datastores and attributes from other models?
Graphical Synonyms
Using the Diagram
Creating a New Diagram
Create Datastores and Attributes
Creating Graphical Synonyms
Creating and Editing Constraints and Filters
Printing a Diagram
Generating DDL scripts
Generating Mapping IN/OUT
Part III Developing Integration Projects
6
Creating an Integration Project
Introduction to Integration Projects
Oracle Data Integrator Project Components
Oracle Data Integrator Project Components
Global Components
Project Life Cycle
Creating a New Project
Managing Knowledge Modules
Project and Global Knowledge Modules
Knowledge Module Naming Conventions
Choosing the Right Knowledge Modules
Importing and Replacing Knowledge Modules
Encrypting and Decrypting a Knowledge Module
Organizing the Project with Folders
7
Creating and Using Packages
Introduction to Packages
Introduction to Steps
Introduction to Creating Packages
Introduction to the Package editor
Creating a new Package
Working with Steps
Adding a Step
Adding a Mapping step
Adding a Procedure step
Variable Steps
Adding Oracle Data Integrator Tool Steps
Adding a Model, Sub-Model or Datastore
Deleting a Step
Duplicating a Step
Running a Step
Editing a Step's Linked Object
Arranging the Steps Layout
Defining the Sequence of Steps
Running a Package
8
Creating and Using Mappings
Introduction to Mappings
Parts of a Mapping
Navigating the Mapping Editor
Creating a Mapping
Creating a New Mapping
Adding and Removing Components
Connecting and Configuring Components
Attribute Matching
Connector Points and Connector Ports
Defining New Attributes
Defining Expressions and Conditions
Defining a Physical Configuration
Running Mappings
Using Mapping Components
The Expression Editor
Source and Target Datastores
Creating Multiple Targets
Specifying Target Order
Adding a Reusable Mapping
Creating Aggregates
Creating Distincts
Creating Expressions
Creating Filters
Creating Joins and Lookups
Creating Pivots
Example: Pivoting Sales Data
The Row Locator
Using the Pivot Component
Creating Sets
Creating Sorts
Creating Splits
Creating Subquery Filters
Creating Table Functions
Creating Unpivots
Example: Unpivoting Sales Data
The Row Locator
Using the Unpivot Component
Creating Flatten Components
Using a Flatten Component in a Mapping
Considerations for using Flatten component with JSON Source
Creating Jagged Components
Creating a Mapping Using a Dataset
Differences Between Flow and Dataset Modeling
Creating a Dataset in a Mapping
Converting a Dataset to Flow-Based Mapping
Physical Design
About the Physical Mapping Diagram
Selecting LKMs, IKMs and CKMs
Configuring Execution Locations
Moving Physical Nodes
Moving Expressions
Defining New Execution Units
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
Creating a Reusable Mapping
Editing Mappings Using the Property Inspector and the Structure Panel
Adding and Removing Components
Adding Components
Removing Components
Editing a Component
Customizing Tables
Using Keyboard Navigation for Common Tasks
Flow Control and Static Control
Setting up Flow Control
Setting up Static Control
Defining the Update Key
Designing E-LT and ETL-Style Mappings
9
Creating and Using Dimensions and Cubes
Overview of Dimensional Objects
Overview of Dimensions
Overview of Cubes
Understanding Measure (Fact)
Cube Implementation
Creating Dimensional Objects through ODI
Dimension and Cube Accordion
Using Dimensions in ODI
Using Cubes in ODI
Generic Properties
Cube Measures
Creating New Dimensional Models
Creating and Editing Dimensional Objects using the Editor
Using Dimension Editor
Using the Cube Editor
Using Dimensional Components in Mappings
Using Dimension Component in Mapping
Dimension Component Properties Editor
Using Cube Component in Mappings
Cube Component Properties Editor
Expanding Dimensional Components
Expanding Dimension Component
Expanding Cube Component
10
Using Compatibility Mode
About Compatibility Mode
Creating Compatible Mappings
Creating Mappings using Upgrade Assistant
Creating Mappings with the 11
g
SDK in ODI 12
c
About Internal Identifiers (IDs)
Renumbering Repositories
11
Creating and Using Procedures, Variables, Sequences, and User Functions
Working with Procedures
Introduction to Procedures
Creating Procedures
Create a New Procedure
Define the Procedure's Options
Create and Manage the Procedure's Tasks
Using Procedures
Executing the Procedure
Using a Procedure in a Package
Generating a Scenario for a Procedure
Encrypting and Decrypting 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
Introduction to Sequences
Creating Sequences
Creating Standard Sequences
Creating Specific Sequences
Creating Native Sequences
Using Sequences and Identity Columns
Tips for Using Standard and Specific Sequences
Identity Columns
Sequence Enhancements
Working with User Functions
Introduction to User Functions
Creating User Functions
Using User Functions
12
Using Scenarios
Introduction to Scenarios
Generating a Scenario
Regenerating a Scenario
Generating a Group of Scenarios
Controlling Concurrent Execution of Scenarios and Load Plans
Exporting Scenarios
Importing Scenarios in Production
Import Scenarios
Replace a Scenario
Working with a Scenario from a Different Repository
Encrypting and Decrypting a Scenario
13
Using Load Plans
Introduction to Load Plans
Load Plan Execution Lifecycle
Differences between Packages, Scenarios, and Load Plans
Load Plan Structure
Introduction to the Load Plan Editor
Creating a Load Plan
Creating a New Load Plan
Defining the Load Plan Step Sequence
Adding Load Plan Steps
Editing Load Plan Steps
Deleting a Step
Duplicating a Step
Working with Variables in Load Plans
Declaring Load Plan Variables
Setting Variable Values in a Step
Handling Load Plan Exceptions and Restartability
Defining Exceptions Flows
Using Exception Handling
Defining the Restart Behavior
Running Load Plans
Using Load Plans in Production
Scheduling and Running Load Plans in Production
Exporting, Importing and Versioning Load Plans
Exporting Load Plans
Importing Load Plans
Versioning 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
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
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
15
Using Shortcuts
Introduction to Shortcuts
Shortcutting Concepts
Shortcut Objects
Introduction to the Shortcut Editor
Creating a Shortcut
Working with Shortcuts in your Projects
Duplicating a Selection with Shortcuts
Jump to the Reference Shortcut
Jump to the Base Object
Executing Shortcuts
Materializing Shortcuts
Exporting and Importing Shortcuts
Using Release Tags
Advanced Actions
16
Using Groovy Scripting
Introduction to Groovy
Introduction to the Groovy Editor
Using the Groovy Editor
Create a Groovy Script
Open and Edit an Existing Groovy Script
Save a Groovy Script
Execute a Groovy Script
Stop the Execution of a Groovy Script
Perform Advanced Actions
Automating Development Tasks - Examples
Part IV Managing Integration Projects
17
Exchanging Global ODI Objects
Using the Check for Updates Wizard
18
Organizing and Documenting Integration Projects
Organizing Projects with Folders
Creating a New Folder
Arranging Project Folders
Organizing Models with Folders
Creating a New Model Folder
Arranging Model Folders
Creating and Organizing Sub-Models
Using Cross-References
Browsing Cross-References
Resolving Missing References
Using Markers and Memos
Markers
Memos
Handling Concurrent Changes
Concurrent Editing Check
Object Locking
Creating PDF Reports
Generating a Topology Report
Generating a Report for the Version Comparison Results
Generating a Report for an Oracle Data Integrator Object
Generating a Diagram Report
19
Using Version Control (Legacy Mode)
Working with Object Flags
Working with Versions
Working with the Version Comparison Tool
Viewing the Differences between two Versions
Using Comparison Filters
Generating and Printing a Report of your Comparison Results
Working with Labels
Working with Elements in a Label
Synchronizing Labels
Restoring and Checking in a Label
Importing and Exporting Labels
20
Integrating ODI with Version Control Systems
Introduction to ODI-VCS integration
Selecting the VCS to use with ODI
Creating an SVN Connection
HTTP Basic Authentication Options
Subversion Basic Authentication Options
SSH Authentication Options
SSL Authentication Options
File Based Authentication Options
Editing an SVN Connection
Configuring Subversion Settings
Subversion Settings
Configuring Subversion Repository with ODI
Options to Configure Subversion Repository with ODI
Creating a Default Subversion Project Structure
Populating a New ODI Repository from a Subversion Branch/Trunk
Populating a Restored ODI Repository from a Subversion Branch/Trunk
Understanding Generic Profiles in ODI
Creating a Full Tag in the Subversion Repository
Creating a Partial Tag in the Subversion Repository
Create Partial Tag Options
Creating a Branch from a Tag
Create Branch from Tag Options
Unlocking the ODI Repository
Adding Non-versioned ODI Objects to the Subversion Repository
Adding a Single Non-versioned ODI Object to the Subversion Repository
Creating versions of a version controlled ODI Object
Restoring a Version Controlled ODI Object from its Previous Version
Restore Object from Subversion Options
Restoring a Version Controlled ODI Object Deleted in ODI Repository
Viewing the Version History of a Version Controlled ODI Object
Version Search Criteria
Comparing Versions of an ODI Object from the Version History Dialog
Icons on the Version Compare Results dialog
Viewing Version Tree of a Version Controlled ODI Object
Comparing Versions of an ODI Object from the Version Tree Editor
Performing a Merge
Performing a Branch Merge
Viewing Merge Summary
21
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
22
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
23
Exporting and Importing
Import and Export Concepts
Global Identifiers (GUIDs)
Export Keys
Relationships between Objects
Import Modes
Tips for Import/Export
Exporting and Importing Objects
Exporting an Object with its Child Components
Exporting an Object without its Child Components
Partial Export/Import
Exporting one ODI Object
Export Multiple ODI Objects
Importing Objects
Smart Export and Import
Performing a Smart Export
Performing a Smart Import
Repository-Level Export/Import
Exporting and Importing the Master Repository
Export/Import Topology and Security Settings
Exporting and Importing a Work Repository
Exporting the Technical Environment
Exporting and Importing the Log
Scripting on this page enhances content navigation, but does not change the content in any way.