Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Planning the Oracle Data Integrator Installation

• 1.1 Introduction to Oracle Data Integrator
• 1.2 About Oracle Data Integrator Installation
  • 1.2.1 Using the Standard Installation Topology as a Starting Point
  • 1.2.2 Using this Document in an Upgrade Scenario
  • 1.2.3 Using this Document to Create a Domain
• 1.3 About Oracle Data Integrator Run-Time Agents
• 1.4 About Oracle Data Integrator Studio
• 1.5 About the Oracle Data Integrator Topology
• 1.6 Understanding the Oracle Data Integrator Standard Installation Topologies
  • 1.6.1 About the Oracle Data Integrator Java EE Agent Standard Installation Topology
  • 1.6.2 About the Oracle Data Integrator Standalone Agent Standard Installation Topology
  • 1.6.3 About the Oracle Data Integrator Standalone Collocated Agent Standard Installation Topology
• 1.7 Roadmap for Installing and Configuring a Standard Installation Topology
• 1.8 Obtaining the Necessary Product Distributions

2 Installing Oracle Data Integrator

• 2.1 Starting the Installation Program
• 2.2 Navigating the Installation Screens to Install Oracle Data Integrator
• 2.3 Verifying the ODI Installation
  • 2.3.1 Reviewing Installation Log Files
  • 2.3.2 Checking the Directory Structure
• 2.4 Installing Oracle Data Integrator in Silent Mode

3 Creating the Master and Work Repository Schemas

• 3.1 Configuring a Certified Database
• 3.2 Starting the Repository Creation Utility
• 3.3 Navigating the Repository Creation Utility Screens to Create the Schema

4 Configuring Oracle Data Integrator Studio

• 4.1 About Oracle Data Integrator Studio
• 4.2 Creating the Database Schemas
• 4.3 Setting the Same Time Zone for the Agent and Repository
• 4.4 Adding Libraries to ODI Studio
• 4.5 Setting Java Home for ODI Studio
• 4.6 Starting ODI Studio
• 4.7 Connecting to the Master Repository
• 4.8 Creating an Agent in the Master Repository with ODI Studio
• 4.9 Starting the New Agent
• 4.10 Performing Next Steps

5 Configuring the Domain for a Java EE Agent

• 5.1 Creating the Database Schema
• 5.2 Generating a Template for a Java EE Agent
• 5.3 Creating a Java EE Agent with Oracle Data Integrator Studio
• 5.4 Configuring the Domain for a Java EE Agent
  • 5.4.1 Starting the Configuration Wizard
  • 5.4.2 Navigating the Configuration Wizard Screens to Configure the Domain
• 5.5 Adding Libraries to a Java EE Agent
• 5.6 Starting a Java EE Agent
  • 5.6.1 Starting Node Manager
  • 5.6.2 Starting the Administration Server
  • 5.6.3 Starting the ODI Managed Server
• 5.7 Performing Next Steps

6 Configuring the Domain for a Standalone Agent

• 6.1 Creating the Database Schema
• 6.2 Creating a Standalone Agent in the Master Repository with ODI Studio
• 6.3 Configuring the Standalone Domain for the Standalone Agent
  • 6.3.1 Starting the WebLogic Server Configuration Wizard
  • 6.3.2 Navigating the Configuration Wizard Screen to Create the Domain
• 6.4 Adding Libraries to a Standalone or Standalone Collocated Agent
• 6.5 Starting a Standalone or Standalone Collocated Agent Using Node Manager
  • 6.5.1 Starting Node Manager
  • 6.5.2 Starting a Standalone or Standalone Collocated Agent
• 6.6 Starting a Standalone or Standalone Collocated Agent Without Node Manager
• 6.7 Performing Next Steps

7 Configuring the Domain for a Standalone Collocated Agent

• 7.1 Creating the Database Schema
• 7.2 Creating a Standalone Agent in the Master Repository Using Oracle Data Integrator Studio
• 7.3 Configuring Your WebLogic Domain for Your Standalone Collocated Agent
  • 7.3.1 Starting the Configuration Wizard
  • 7.3.2 Navigating the Configuration Wizard Screens to Configure the Domain
• 7.4 Adding Libraries to a Standalone or Standalone Collocated Agent
• 7.5 Starting a Standalone Collocated Agent with Node Manager
  • 7.5.1 Starting Node Manager
  • 7.5.2 Starting the Standalone Collocated Agent
• 7.6 Starting a Standalone Collocated Agent Without Node Manager
• 7.7 Performing Next Steps

8 Configuring an Oracle Data Integrator New Domain

• 8.1 Performing Basic Administrative Tasks
• 8.2 Performing Additional Domain Configuration Tasks
• 8.3 Preparing Oracle Data Integrator for Development
• 8.4 Preparing Your Environment For High Availability

9 Uninstalling Oracle Data Integrator

• 9.1 Understanding Product Uninstallation
• 9.2 Stopping Agents and Oracle Fusion Middleware
  • 9.2.1 Stopping the Oracle Data Integrator Agents
  • 9.2.2 Stopping the Oracle Fusion Middleware Environment
• 9.3 Removing Database Schemas
• 9.4 Uninstalling the Software
  • 9.4.1 Starting the Uninstaller
  • 9.4.2 Navigating the Uninstallation Screens
• 9.5 Removing the Oracle Home Directory Manually
• 9.6 Removing the Program Shortcuts on Windows Operating Systems
• 9.7 Removing Your Domain and Application Data
• 9.8 Removing Oracle Data Integrator Wallet Information
• 9.9 Uninstalling Oracle Fusion Middleware Infrastructure
• 9.10 Reinstalling the Software

A Understanding Oracle Data Integrator Distribution

• A.1 Oracle Data Integrator Components

B Troubleshooting Oracle Data Integrator

• B.1 General Troubleshooting Tips
• B.2 Troubleshooting Using Installation and Configuration Log Files
• B.3 Verifying ODI Client and Repository Compatibility
• B.4 Need More Help?

C About the Secondary Topologies for Oracle Data Integrator

• C.1 Oracle Data Integrator Topology with the Oracle Data Integrator Console
• C.2 Using the Oracle Data Integrator Console