Go to main content
1/29
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
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
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
10
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
11
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
12
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
13
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
14
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
15
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
16
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
17
Using Version Control
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 Solutions
Working with Elements in a Solution
Synchronizing Solutions
Restoring and Checking in a Solution
Importing and Exporting Solutions
18
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.