Go to main content
1/21
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.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
3.4
Roadmap for Setting Up a High Availability Topology
3.4.1
Reconfigure Agents
Part II Creating and Using Data Services
4
Setting Up Data Services
4.1
Setting Up Data Services
4.1.1
Configuring the Web Services Container
4.1.2
Setting up the Data Sources
4.1.3
Configuring the Model
5
Generating and Deploying Data Services
5.1
Generating and Deploying Data Services
5.2
Overview of Generated Services
5.3
Testing Data Services
Part III Running and Monitoring Integration Processes
6
Running Integration Processes
6.1
Understanding ODI Executions
6.2
Executing Mappings, Procedures, Packages and Model Operations
6.3
Executing a Scenario
6.3.1
Executing a Scenario from ODI Studio
6.3.2
Executing a Scenario from a Command Line
6.4
Restarting a Session
6.4.1
Restarting a Session from ODI Studio
6.4.2
Restarting a Session from a Command Line
6.5
Stopping a Session
6.5.1
Stopping a Session From ODI Studio
6.5.2
Stopping a Session From a Command Line
6.6
Executing a Load Plan
6.6.1
Executing a Load Plan from ODI Studio
6.6.2
Executing a Load Plan from a Command Line
6.7
Restarting a Load Plan Run
6.7.1
Restarting a Load Plan from ODI Studio
6.7.2
Restarting a Load Plan from a Command Line
6.8
Stopping a Load Plan Run
6.8.1
Stopping a Load Plan from ODI Studio
6.8.2
Stopping a Load Plan Run from a Command Line
6.9
Scheduling Scenarios and Load Plans
6.9.1
Scheduling a Scenario or a Load Plan with the Built-in Scheduler
6.9.1.1
Scheduling a Scenario or a Load Plan
6.9.1.2
Updating an Agent's Schedule
6.9.1.3
Displaying the Schedule
6.9.2
Scheduling a Scenario or a Load Plan with an External Scheduler
6.10
Simulating an Execution
6.11
Managing Executions Using Web Services
6.11.1
Introduction to Run-Time Web Services
6.11.2
Executing a Scenario Using a Web Service
6.11.3
Monitoring a Session Status Using a Web Service
6.11.4
Restarting a Session Using a Web Service
6.11.5
Executing a Load Plan Using a Web Service
6.11.6
Stopping a Load Plan Run Using a Web Service
6.11.7
Restarting a Load Plan Instance Using a Web Service
6.11.8
Monitoring a Load Plan Run Status Using a Web Service
6.11.9
Accessing the Web Service from a Command Line
6.11.10
Using the Run-Time Web Services with External Authentication
6.11.11
Using WS-Addressing
6.11.12
Using Asynchronous Web Services with Callback
7
Debugging Integration Processes
7.1
About Sessions and Blueprints
7.1.1
Blueprint Source and Target Code
7.2
Introduction to Debugging in the Session Editor
7.2.1
Icons
7.2.2
Differences between Debugging Packages, Mappings, and Procedures
7.3
Starting a Debugging Session
7.3.1
Connecting to a Running Debugging Session
7.3.1.1
Built-in Agents and External Agents
7.3.1.2
Debug Session Lifecycle
7.3.2
Debug Session Options
7.3.2.1
Suspend Before the First Task
7.3.2.2
Associate to Current Client
7.3.2.3
Delay Before Connect
7.3.2.4
Debug Descendant Sessions
7.3.2.5
Break On Error
7.4
Stepping through a Blueprint in the Session Editor
7.4.1
Steps and Tasks
7.5
Using the Debugging Cursor
7.5.1
Debug Actions
7.5.1.1
Step Into
7.5.1.2
Pause
7.5.1.3
Resume
7.5.1.4
Run to Task End
7.5.1.5
Run to Next Task
7.5.1.6
Run to Step End
7.5.1.7
Run to Next Step
7.5.2
Multiple Cursors
7.5.2.1
Special Behavior
7.5.3
Using Breakpoints
7.5.3.1
About the Debug Breakpoints Window
7.5.3.2
About Design vs. Runtime Breakpoints
7.5.3.3
Placing Breakpoints
7.5.3.4
Editing Breakpoints
7.5.3.5
Removing Breakpoints
7.5.3.6
Enabling and Disabling Breakpoints
7.5.3.7
Pass Count
7.5.4
Debugging Data
7.5.4.1
Get Data
7.5.4.2
Run SQL Code
7.5.5
Debugging Variables
7.5.5.1
Modifying Variables
7.5.6
Debugging Threads
7.5.6.1
Go To Source
7.6
Managing Debugging Sessions
7.6.1
Stop Normal and Stop Immediate
7.6.2
Restart Execution
8
Monitoring Integration Processes
8.1
Introduction to Monitoring
8.1.1
Introduction to Operator Navigator
8.1.2
Scenarios
8.1.3
Sessions
8.1.4
Load Plans
8.1.5
Load Plan Executions
8.1.6
Schedules
8.1.7
Log
8.1.8
Status
8.1.9
Task Types
8.2
Monitoring Executions Results
8.2.1
Monitoring Sessions
8.2.2
Monitoring Load Plan Runs
8.2.3
Handling Failed Sessions
8.2.4
Reviewing Successful Sessions
8.2.5
Handling Failed Load Plans
8.2.6
Reviewing Successful Load Plans
8.3
Managing your Executions
8.3.1
Managing Sessions
8.3.1.1
Cleaning Stale Sessions
8.3.1.2
Removing Temporary Objects
8.3.2
Managing Load Plan Executions
8.3.3
Managing the Log
8.3.3.1
Filtering Sessions
8.3.3.2
Purging the Log
8.3.3.3
Organizing the Log with Session Folders
8.3.3.4
Exporting and Importing Log Data
8.3.3.5
Runtime Logging for ODI components
8.3.4
Managing Scenarios and Load Plans
8.3.4.1
Load Plan and Scenario Folders
8.3.4.2
Importing Load Plans, Scenarios, and Solutions in Production
8.3.5
Managing Schedules
9
Using Oracle Data Integrator Console
9.1
Introduction to Oracle Data Integrator Console
9.1.1
Oracle Data Integrator Console Concepts
9.1.2
Oracle Data Integrator Console Interface
9.2
Using Oracle Data Integrator Console
9.2.1
Connecting to Oracle Data Integrator Console
9.2.2
Generic User Operations
9.2.3
Managing Scenarios and Sessions
9.2.4
Managing Load Plans
9.2.5
Purging the Log
9.2.6
Using Data Lineage and Flow Map
9.2.7
Performing Administrative Operations
9.3
ODI Domain
9.4
Oracle Enterprise Manager Fusion Middleware Control
9.4.1
Configuring Oracle Fusion Middleware Control with ODI Plug-in
9.4.2
Configuring Oracle Data Integrator Console
9.4.3
Managing Oracle Data Integrator
9.4.4
Configuring ODI Standalone Agents
9.4.5
Configuring Master Repository
9.4.6
Searching Sessions
9.4.7
Searching Load Plan Executions
9.5
Management Pack for Oracle Data Integrator
Part IV Managing Security Settings
10
Managing Security in Oracle Data Integrator
10.1
Introduction to Oracle Data Integrator Security
10.1.1
Objects, Instances, and Methods
10.1.2
Profiles
10.1.3
Users
10.1.4
Roles
10.2
User Management
10.2.1
Security Policy Approaches
10.2.2
Managing Profiles
10.2.2.1
Creating a New Profile
10.2.2.2
Duplicating a Profile
10.2.2.3
Deleting a Profile
10.2.3
Managing Users
10.2.3.1
Creating a New User in the Internal Repository
10.2.3.2
Assigning a Profile to a User
10.2.3.3
Removing a Profile from a User
10.2.3.4
Deleting a User from the Internal Repository
10.2.4
Managing Privileges
10.2.4.1
Granting a Profile Method or User Method
10.2.4.2
Revoking a Profile Method or User Method
10.2.4.3
Granting an Authorization by Object Instance
10.2.4.4
Revoking an Authorization by Object Instance
10.2.4.5
Cleaning up Unused Authorizations
10.3
Advanced Encryption Standard
10.4
Using a Password-Protected Wallet for Storing Login Credentials
10.4.1
Creating the Password-Protected Wallet
10.4.2
Permitting Repository Access to Other Users
10.4.3
Changing the Wallet Password
10.4.4
Customizing How Login Credentials Are Saved
10.5
Setting Up External Password Storage
10.5.1
Setting the Password Storage
10.5.2
Switching the Password Storage
10.5.3
Recovering the Password Storage
10.6
Managing the Authentication Mode
10.6.1
Setting the Authentication Mode in the Master Repository
10.7
Configuring External Authentication
10.7.1
Configuring Oracle Data Integrator Studio for External Authentication
10.7.1.1
Set Up the OPSS Configuration File
10.7.1.2
Create a Wallet File for an LDAP Bootstrap User
10.7.1.3
Set External Authentication when Creating the Master Repository
10.7.2
Switching an Existing Master Repository to External Authentication Mode
10.7.3
Reactivating Users After Switching to External Authentication
10.7.4
Configuring Standalone or Standalone Colocated Agents for External Authentication
10.7.5
Mapping Principals Defined in an Identity Store to Oracle Data Integrator Roles
10.7.5.1
How Enterprise Role Integration Works
10.7.5.2
Defining and Managing Oracle Data Integrator Roles
10.7.5.3
Using the Roles Editor
10.8
Enforcing Password Policies
10.9
Configuring Standalone or Standalone Colocated Agents to Use a Secure Transport
10.9.1
Creating an SSL Certificate
10.9.2
Configuring SSL for Standalone Agents or Standalone Colocated Agents
10.9.3
Configuring ODI Studio to Connect with an SSL-enabled Agent
10.9.4
Configuring Oracle Data Integrator Client Tools to Communicate with an SSL-enabled Agent
10.9.5
Encoding a Password
10.9.6
Disabling Weak Cipher Suites for an SSL-enabled Standalone Agent or Standalone Colocated Agent
10.10
Configuring Oracle Data Integrator with a Web Proxy Server
10.11
Configuring Single Sign-On (SSO) for Oracle Data Integrator Console and Enterprise Manager using Oracle Access Manager 11
g
10.12
Best Security Practices for Oracle Data Integrator
Scripting on this page enhances content navigation, but does not change the content in any way.