Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Installing Oracle Data Integrator

1 Oracle Data Integrator Installation Overview

• 1.1 Oracle Data Integrator Components
• 1.2 Installation Roadmap
• 1.3 Oracle Data Integrator Directory Structure
  • 1.3.1 Contents of the 11g Installation Directory
  • 1.3.2 Scripts and Tools

2 Installing Oracle Data Integrator

• 2.1 Preparing to Install
  • 2.1.1 Review System Requirements and Certification
  • 2.1.2 Understand Oracle Fusion Middleware Support of 64-bit JDK
  • 2.1.3 Install a Supported Database
  • 2.1.4 Create ODI Repositories with the Repository Creation Utility (RCU)
  • 2.1.5 Install Oracle WebLogic Server and Create the Middleware Home
• 2.2 ODI Installation Instructions
  • 2.2.1 Starting the Installer
  • 2.2.2 Installation Log Files
  • 2.2.3 Installation Types
  • 2.2.4 Installation Instructions for "Developer" Install Type
  • 2.2.5 Installation Instructions for "Standalone" Install Type
  • 2.2.6 Installation Instructions for "Java EE" Install Type

3 Configuring Oracle Data Integrator

• 3.1 Configure a WebLogic Domain
  • 3.1.1 Starting the Administration Server
  • 3.1.2 Starting the Managed Server
• 3.2 Configure ODI Studio, Repositories, and the Standalone Agent
  • 3.2.1 Add Additional Drivers and Open Tools
  • 3.2.2 Manually Create Repositories
  • 3.2.3 Manually Connect to Existing Repositories
  • 3.2.4 Manually Configure the Standalone Agent
  • 3.2.5 Starting the Standalone Agent
• 3.3 Configure Java EE Components
  • 3.3.1 Declare the Java EE Agent in Topology
  • 3.3.2 Generate Java EE Agent Template
  • 3.3.3 Add Credential Store Entries
    • 3.3.3.1 Credential Store Entries for the Java EE Agent
    • 3.3.3.2 Credential Store Entries for the Oracle Enterprise Manager
  • 3.3.4 Configure Oracle Data Integrator Console Connections
  • 3.3.5 Configure Oracle Enterprise Manager

Part II Appendices

A Oracle Data Integrator Installation Screens

• A.1 Welcome Screen
• A.2 Select Installation Type Screen
• A.3 Prerequisite Checks Screen
• A.4 Specify Installation Location Screen
• A.5 Repository Configuration Screen
• A.6 Master Repository Screens
• A.7 Supervisor User Details Screen
• A.8 Specify Work Repository Details Screen
• A.9 Specify Agent Details Screen
• A.10 Specify Security Updates Screen
• A.11 Installation Summary Screen
• A.12 Installation Progress Screen
• A.13 Configuration Progress Screen
• A.14 Installation Completed Screen

B Silent Installations

• B.1 About Silent Installation
• B.2 Oracle Data Integrator Response Files

C Deinstalling Oracle Data Integrator

• C.1 Deinstallation Instructions
  • C.1.1 Stopping Oracle Fusion Middleware
  • C.1.2 Stopping a Standalone Agent
  • C.1.3 Removing the Oracle Data Integrator Schemas
  • C.1.4 Removing Oracle Data Integrator Components
    • C.1.4.1 Starting the Deinstaller
  • C.1.5 Removing the ODI Home
  • C.1.6 Removing the Oracle Common Home
  • C.1.7 Removing Oracle WebLogic Server
  • C.1.8 Removing the Program Groups (Windows Only)
• C.2 Reinstallation

D Oracle Data Integrator Deinstallation Screens

• D.1 Welcome Screen
• D.2 Deinstall Oracle Home Screen
• D.3 Deinstallation Progress Screen
• D.4 Deinstallation Complete Screen

E Oracle Data Integrator Companion CD

• E.1 Oracle Data Integrator Companion Disk Components
• E.2 Manual Installation and Configuration Steps
  • E.2.1 Standalone Agent
  • E.2.2 ODI Studio and XML Reference
  • E.2.3 Demonstration Environment
• E.3 Installing the Java Standalone Agent on iSeries

F Creating Repositories with Oracle Data Integrator Studio

• F.1 Introduction to Oracle Data Integrator Repositories
• F.2 Creating Repository Storage Spaces
• F.3 Creating the Master Repository
• F.4 Connecting to the Master Repository
• F.5 Creating a Work Repository
• F.6 Connecting to a Work Repository

G Customizing the ODI Credential Map Name

• G.1 What is stored in Credential Store?
• G.2 Executing the updateCredMapInEar Script
• G.3 Updating WLST Scripts for Credential Map Creation

H OPMN Configuration for Standalone Agent

• H.1 Adding a Standalone Agent to OPMN
• H.2 Stopping the Agent
• H.3 Starting the Agent and Agent Components
• H.4 Determining the Status of Oracle HTTP Server
• H.5 Deleting the Agent

Index