Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Installation Overview for Oracle Data Integrator

• 1.1 Oracle Data Integrator Applications
• 1.2 ODI Installation Types
• 1.3 Installation Roadmap
• 1.4 Topology Summary of ODI
  • 1.4.1 Contents of the 11g Installation Directory
  • 1.4.2 Scripts and Tools

2 Installing Oracle Data Integrator

• 2.1 Verifying Your System and Network Environment
• 2.2 Installing a Database and Creating the ODI Database Schemas
  • 2.2.1 Installing and Configuring a Database
  • 2.2.2 Using RCU to Create the Database Schema
• 2.3 Installing an Application Server and Creating the Middleware Home
• 2.4 Installing Oracle Data Integrator
  • 2.4.1 Obtaining the Installer
  • 2.4.2 Starting the Installer
  • 2.4.3 Following the Installation Instructions
  • 2.4.4 Configuring a WebLogic Server Domain for Java EE Installations
• 2.5 Verifying the ODI Installation
  • 2.5.1 Reviewing Installation Log Files
  • 2.5.2 Checking the Directory Structure

3 Configuring Oracle Data Integrator

• 3.1 Manual Steps for Configuring ODI Studio, Repositories, and the Standalone Agent
  • 3.1.1 Adding Additional Drivers and Open Tools to the Standalone Agent and ODI Studio
  • 3.1.2 Using ODI Studio to Manually Create and Connect to the Repositories
  • 3.1.3 Changing the Language Used in ODI Studio
  • 3.1.4 Manually Configuring and Starting the Standalone Agent
    • 3.1.4.1 Manually Configuring the Standalone Agent
    • 3.1.4.2 Manually Starting the Standalone Agent
• 3.2 Configuring Java EE Components
  • 3.2.1 Configuring a WebLogic Domain or WebSphere Cell
    • 3.2.1.1 Starting the Configuration Wizard
    • 3.2.1.2 Configuring Your ODI Domain
  • 3.2.2 Starting the Servers
    • 3.2.2.1 Starting Node Manager
    • 3.2.2.2 Starting the Administration Server
    • 3.2.2.3 Starting the Managed Server
  • 3.2.3 Adding Credential Store Entries
    • 3.2.3.1 Adding Credential Store Entries for the Java EE Agent
    • 3.2.3.2 Adding Credential Store Entries for the Oracle Enterprise Manager
    • 3.2.3.3 Adding Credential Store Entries for IBM WebSphere Server
  • 3.2.4 Declaring the Java EE Agent in Topology
  • 3.2.5 Generating Java EE Agent Template
  • 3.2.6 Configuring ODI Console Connections
  • 3.2.7 Configuring Oracle Fusion Middleware Control with ODI Plugin
• 3.3 Integrating ODI with Oracle Access Manager 11g

4 Deinstalling Oracle Data Integrator

• 4.1 Performing Pre-Deinstallation Tasks
  • 4.1.1 Stopping Oracle Fusion Middleware
  • 4.1.2 Stopping a Standalone Agent
  • 4.1.3 Removing the Oracle Data Integrator Schemas
• 4.2 Deinstalling Oracle Data Integrator
  • 4.2.1 Starting the Deinstaller
  • 4.2.2 Removing the ODI Home
  • 4.2.3 Removing the Oracle Common Home
  • 4.2.4 Manually Removing Your Oracle Home Directories
  • 4.2.5 Removing the Program Groups (Windows Only)
• 4.3 Uninstalling Your Application Server
  • 4.3.1 Removing Oracle WebLogic Server
  • 4.3.2 Removing IBM WebSphere
• 4.4 Reinstallation

A Installation Screens for Oracle Data Integrator

• A.1 Flowchart of the Oracle Data Integrator Installation Screens
• A.2 Descriptions of the Oracle Data Integrator Installation Screens
  • A.2.1 Welcome
  • A.2.2 Install Software Updates
  • A.2.3 Select Installation Type
  • A.2.4 Prerequisite Checks
  • A.2.5 Specify Installation Location
  • A.2.6 Application Server
  • A.2.7 Repository Configuration
  • A.2.8 Master Repository
  • A.2.9 Supervisor User Details
  • A.2.10 Specify Work Repository Details
  • A.2.11 Specify Agent Details
  • A.2.12 Installation Summary
  • A.2.13 Installation Progress
  • A.2.14 Configuration Progress
  • A.2.15 Installation Completed

B Deinstallation Screens for Oracle Data Integrator

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

C Silent Installation and Deinstallation

• C.1 Understanding Silent Installation and Deinstallation
• C.2 Using the Oracle Data Integrator Response Files
• C.3 Oracle Data Integrator Installation Response File Parameters
• C.4 Oracle Data Integrator Deinstallation Response File Parameters

D Oracle Data Integrator Companion CD

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

E Creating Repositories with Oracle Data Integrator Studio

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

F Customizing the ODI Credential Map Name

• F.1 What is Stored in Credential Store?
• F.2 Modifying the Credential Map Name
• F.3 Updating WLST Scripts for Credential Map Creation

G OPMN Configuration for Standalone Agent

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

H Troubleshooting

• H.1 General Troubleshooting Tips
• H.2 Installation and Configuration Log Files
  • H.2.1 Installation Log Files
  • H.2.2 Configuration Log Files
• H.3 Keeping Track of Your JRE Location
• H.4 ODI Client and Repository Compatibility
• H.5 Need More Help?