Go to main content
1/22
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?
New and Changed Features for Release 12
c
(12.2.1.1)
New and Changed Features for Release 12
c
(12.2.1)
New and Changed Features for Release 12
c
(12.1.3.0.1)
New and Changed Features for Release 12
c
(12.1.3)
New and Changed Features for Release 12
c
(12.1.2)
1
Introduction to Oracle Data Integrator
1.1
What is Oracle Data Integrator?
1.2
Oracle Data Integrator Components
1.3
Basic Tasks for Configuring and Managing Oracle Data Integrator
Part I Administering Oracle Data Integrator Architecture
2
Administering Repositories
2.1
Introduction to Oracle Data Integrator Repositories
2.2
Creating Repository Storage Spaces
2.3
Creating the Master Repository
2.4
Connecting to the Master Repository
2.5
Creating a Work Repository
2.6
Connecting to a Work Repository
2.7
Changing a Work Repository Password
2.8
Advanced Actions for Administering Repositories
2.8.1
Attaching and Detaching (Deleting) a Work Repository
2.8.2
Erasing a Work Repository
2.8.3
Configuring Repository Connections
3
Setting Up a Topology
3.1
Setting Up the Topology
3.1.1
Creating a Context
3.1.2
Creating a Data Server
3.1.2.1
Pre-requisites and Guidelines
3.1.2.2
Creating a Data Server
3.1.2.3
Creating a Data Server (Advanced Settings)
3.1.2.4
Testing a Data Server Connection
3.1.3
Creating a Physical Schema
3.1.4
Creating a Logical Schema
3.1.5
Creating a Physical Agent
3.1.6
Creating a Logical Agent
3.2
Working with Big Data
3.3
Managing Agents
3.3.1
Standalone Agent
3.3.1.1
Configuring a Standalone Agent
3.3.1.2
Launching a Standalone Agent
3.3.1.3
Stopping an Agent
3.3.2
Standalone Colocated Agent
3.3.2.1
Configuring a Standalone Colocated Agent
3.3.2.2
Launching a Standalone Colocated Agent
3.3.2.3
Stopping an Agent
3.3.3
Java EE Agent
3.3.3.1
Deploying an Agent in a Java EE Application Server
3.3.3.2
Creating a Server Template for a Java EE Agent
3.3.3.3
Deploying Datasources from Oracle Data Integrator in an application server for an Agent
3.3.4
Load Balancing Agents
3.3.4.1
Delegating Sessions
3.3.4.2
Agent Unavailable
3.3.4.3
Setting Up Load Balancing
4
High Availability for Oracle Data Integrator
4.1
Oracle Data Integrator Single Instance Characteristics
4.1.1
Oracle Data Integrator Sessions Lifecycle and Recovery
4.1.1.1
Sessions Interruption
4.1.1.2
Recovering Sessions
4.1.2
Agent Startup and Shutdown Cycle
4.1.3
Oracle Data Integrator External Dependencies
4.1.4
Oracle Data Integrator Startup and Shutdown Process
4.1.5
Oracle Data Integrator Configuration Artifacts
4.1.5.1
Agent Configuration
4.1.5.2
Oracle Data Integrator Console Configuration
4.1.5.3
Oracle Data Integrator Log Locations and Configuration
4.2
Oracle Data Integrator High Availability and Failover Considerations
4.2.1
Oracle Data Integrator Clustered Deployment
4.2.2
Oracle Data Integrator Protection from Failure and Expected Behavior
4.2.2.1
WebLogic Server or Standalone Agent Crash
4.2.2.2
Repository Database Failure
4.2.2.3
Scheduler Node Failure
4.3
Roadmap for Setting Up a High Availability Topology
4.3.1
Reconfigure Agents
Part II Creating and Using Data Services
5
Setting Up Data Services
5.1
Setting Up Data Services
5.1.1
Configuring the Web Services Container
5.1.2
Setting up the Data Sources
5.1.3
Configuring the Model
6
Generating and Deploying Data Services
6.1
Generating and Deploying Data Services
6.2
Overview of Generated Services
6.3
Testing Data Services
Part III Running and Monitoring Integration Processes
7
Running Integration Processes
7.1
Understanding ODI Executions
7.2
Executing Mappings, Procedures, Packages and Model Operations
7.3
Executing a Scenario
7.3.1
Executing a Scenario from ODI Studio
7.3.2
Executing a Scenario from a Command Line
7.4
Restarting a Session
7.4.1
Restarting a Session from ODI Studio
7.4.2
Restarting a Session from a Command Line
7.5
Stopping a Session
7.5.1
Stopping a Session From ODI Studio
7.5.2
Stopping a Session From a Command Line
7.6
Executing a Load Plan
7.6.1
Executing a Load Plan from ODI Studio
7.6.2
Executing a Load Plan from a Command Line
7.7
Restarting a Load Plan Run
7.7.1
Restarting a Load Plan from ODI Studio
7.7.2
Restarting a Load Plan from a Command Line
7.8
Stopping a Load Plan Run
7.8.1
Stopping a Load Plan from ODI Studio
7.8.2
Stopping a Load Plan Run from a Command Line
7.9
Scheduling Scenarios and Load Plans
7.9.1
Scheduling a Scenario or a Load Plan with the Built-in Scheduler
7.9.1.1
Scheduling a Scenario or a Load Plan
7.9.1.2
Updating an Agent's Schedule
7.9.1.3
Displaying the Schedule
7.9.2
Scheduling a Scenario or a Load Plan with an External Scheduler
7.10
Simulating an Execution
7.11
Managing Executions Using Web Services
7.11.1
Introduction to Run-Time Web Services
7.11.2
Executing a Scenario Using a Web Service
7.11.3
Monitoring a Session Status Using a Web Service
7.11.4
Restarting a Session Using a Web Service
7.11.5
Executing a Load Plan Using a Web Service
7.11.6
Stopping a Load Plan Run Using a Web Service
7.11.7
Restarting a Load Plan Instance Using a Web Service
7.11.8
Monitoring a Load Plan Run Status Using a Web Service
7.11.9
Accessing the Web Service from a Command Line
7.11.10
Using the Run-Time Web Services with External Authentication
7.11.11
Using WS-Addressing
7.11.12
Using Asynchronous Web Services with Callback
8
Debugging Integration Processes
8.1
About Sessions and Blueprints
8.1.1
Blueprint Source and Target Code
8.2
Introduction to Debugging in the Session Editor
8.2.1
Icons
8.2.2
Differences between Debugging Packages, Mappings, and Procedures
8.3
Starting a Debugging Session
8.3.1
Connecting to a Running Debugging Session
8.3.1.1
Built-in Agents and External Agents
8.3.1.2
Debug Session Lifecycle
8.3.2
Debug Session Options
8.3.2.1
Suspend Before the First Task
8.3.2.2
Associate to Current Client
8.3.2.3
Delay Before Connect
8.3.2.4
Debug Descendant Sessions
8.3.2.5
Break On Error
8.4
Stepping through a Blueprint in the Session Editor
8.4.1
Steps and Tasks
8.5
Using the Debugging Cursor
8.5.1
Debug Actions
8.5.1.1
Step Into
8.5.1.2
Pause
8.5.1.3
Resume
8.5.1.4
Run to Task End
8.5.1.5
Run to Next Task
8.5.1.6
Run to Step End
8.5.1.7
Run to Next Step
8.5.2
Multiple Cursors
8.5.2.1
Special Behavior
8.5.3
Using Breakpoints
8.5.3.1
About the Debug Breakpoints Window
8.5.3.2
About Design vs. Runtime Breakpoints
8.5.3.3
Placing Breakpoints
8.5.3.4
Editing Breakpoints
8.5.3.5
Removing Breakpoints
8.5.3.6
Enabling and Disabling Breakpoints
8.5.3.7
Pass Count
8.5.4
Debugging Data
8.5.4.1
Get Data
8.5.4.2
Run SQL Code
8.5.5
Debugging Variables
8.5.5.1
Modifying Variables
8.5.6
Debugging Threads
8.5.6.1
Go To Source
8.6
Managing Debugging Sessions
8.6.1
Stop Normal and Stop Immediate
8.6.2
Restart Execution
9
Monitoring Integration Processes
9.1
Introduction to Monitoring
9.1.1
Introduction to Operator Navigator
9.1.2
Scenarios
9.1.3
Sessions
9.1.4
Load Plans
9.1.5
Load Plan Executions
9.1.6
Schedules
9.1.7
Log
9.1.8
Status
9.1.9
Task Types
9.2
Monitoring Executions Results
9.2.1
Monitoring Sessions
9.2.2
Monitoring Load Plan Runs
9.2.3
Handling Failed Sessions
9.2.4
Reviewing Successful Sessions
9.2.5
Handling Failed Load Plans
9.2.6
Reviewing Successful Load Plans
9.3
Managing your Executions
9.3.1
Managing Sessions
9.3.1.1
Cleaning Stale Sessions
9.3.1.2
Removing Temporary Objects
9.3.2
Managing Load Plan Executions
9.3.3
Managing the Log
9.3.3.1
Filtering Sessions
9.3.3.2
Purging the Log
9.3.3.3
Organizing the Log with Session Folders
9.3.3.4
Exporting and Importing Log Data
9.3.3.5
Runtime Logging for ODI components
9.3.4
Managing Scenarios and Load Plans
9.3.4.1
Load Plan and Scenario Folders
9.3.4.2
Importing Load Plans, Scenarios, and Solutions in Production
9.3.5
Managing Schedules
10
Using Oracle Data Integrator Console
10.1
Introduction to Oracle Data Integrator Console
10.1.1
Oracle Data Integrator Console Concepts
10.1.2
Oracle Data Integrator Console Interface
10.2
Using Oracle Data Integrator Console
10.2.1
Connecting to Oracle Data Integrator Console
10.2.2
Generic User Operations
10.2.3
Managing Scenarios and Sessions
10.2.4
Managing Load Plans
10.2.5
Purging the Log
10.2.6
Using Data Lineage and Flow Map
10.2.7
Performing Administrative Operations
10.3
ODI Domain
10.4
Oracle Enterprise Manager Fusion Middleware Control
10.4.1
Configuring Oracle Fusion Middleware Control with ODI Plug-in
10.4.2
Configuring Oracle Data Integrator Console
10.4.3
Managing Oracle Data Integrator
10.4.4
Configuring ODI Standalone Agents
10.4.5
Configuring Master Repository
10.4.6
Searching Sessions
10.4.7
Searching Load Plan Executions
10.5
Management Pack for Oracle Data Integrator
Part IV Managing Security Settings
11
Managing Security in Oracle Data Integrator
11.1
Introduction to Oracle Data Integrator Security
11.1.1
Objects, Instances, and Methods
11.1.2
Profiles
11.1.3
Users
11.1.4
Roles
11.2
User Management
11.2.1
Security Policy Approaches
11.2.2
Managing Profiles
11.2.2.1
Creating a New Profile
11.2.2.2
Duplicating a Profile
11.2.2.3
Deleting a Profile
11.2.3
Managing Users
11.2.3.1
Creating a New User in the Internal Repository
11.2.3.2
Assigning a Profile to a User
11.2.3.3
Removing a Profile from a User
11.2.3.4
Deleting a User from the Internal Repository
11.2.3.5
Viewing User Connection Information
11.2.4
Managing Privileges
11.2.4.1
Granting a Profile Method or User Method
11.2.4.2
Revoking a Profile Method or User Method
11.2.4.3
Granting an Authorization by Object Instance
11.2.4.4
Revoking an Authorization by Object Instance
11.2.4.5
Cleaning up Unused Authorizations
11.3
Advanced Encryption Standard
11.4
Using a Password-Protected Wallet for Storing Login Credentials
11.4.1
Creating the Password-Protected Wallet
11.4.2
Permitting Repository Access to Other Users
11.4.3
Changing the Wallet Password
11.4.4
Customizing How Login Credentials Are Saved
11.5
Setting Up External Password Storage
11.5.1
Setting the Password Storage
11.5.2
Switching the Password Storage
11.5.3
Recovering the Password Storage
11.6
Managing the Authentication Mode
11.6.1
Setting the Authentication Mode in the Master Repository
11.7
Configuring External Authentication
11.7.1
Configuring Oracle Data Integrator Studio for External Authentication
11.7.1.1
Set Up the OPSS Configuration File
11.7.1.2
Create a Wallet File for an LDAP Bootstrap User
11.7.1.3
Set External Authentication when Creating the Master Repository
11.7.2
Switching an Existing Master Repository to External Authentication Mode
11.7.3
Reactivating Users After Switching to External Authentication
11.7.4
Configuring Standalone or Standalone Colocated Agents for External Authentication
11.7.5
Mapping Principals Defined in an Identity Store to Oracle Data Integrator Roles
11.7.5.1
How Enterprise Role Integration Works
11.7.5.2
Defining and Managing Oracle Data Integrator Roles
11.7.5.3
Using the Roles Editor
11.8
Configuring OWSM Policies for JRF-ODI Asynchronous Web Services with Callback
11.9
Enforcing Password Policies
11.10
Configuring Standalone or Standalone Colocated Agents to Use a Secure Transport
11.10.1
Creating an SSL Certificate
11.10.2
Configuring SSL for Standalone Agents or Standalone Colocated Agents
11.10.3
Configuring ODI Studio to Connect with an SSL-enabled Agent
11.10.4
Configuring Oracle Data Integrator Client Tools to Communicate with an SSL-enabled Agent
11.10.5
Encoding a Password
11.10.6
Disabling Weak Cipher Suites for an SSL-enabled Standalone Agent or Standalone Colocated Agent
11.11
Configuring Oracle Data Integrator with a Web Proxy Server
11.12
Configuring Single Sign-On (SSO) for Oracle Data Integrator Console and Enterprise Manager using Oracle Access Manager 11
g
11.13
Best Security Practices for Oracle Data Integrator
Scripting on this page enhances content navigation, but does not change the content in any way.