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
• 2.3 Configure a WebLogic Domain
  • 2.3.1 Starting the Administration Server
  • 2.3.2 Starting the Managed Server
• 2.4 Manual Configuration Tasks for ODI Studio, Repositories, and Standalone Agent
  • 2.4.1 Add Additional Drivers and Open Tools
  • 2.4.2 Manually Create Repositories
  • 2.4.3 Manually Connect to Existing Repositories
  • 2.4.4 Manually Configure the Standalone Agent
  • 2.4.5 Starting the Standalone Agent
• 2.5 Manual Configuration Tasks for Java EE Components
  • 2.5.1 Declare the Java EE Agent in Topology
  • 2.5.2 Generate Java EE Agent Template
  • 2.5.3 Add Credential Store Entries
    • 2.5.3.1 Credential Store Entries for the Java EE Agent
    • 2.5.3.2 Credential Store Entries for the Oracle Enterprise Manager
  • 2.5.4 Configure Oracle Data Integrator Console Connections
  • 2.5.5 Configure Oracle Enterprise Manager

Part II Installing Oracle Data Profiling and Oracle Data Quality

3 Oracle Data Quality Installation Overview

• 3.1 Oracle Data Quality Components
• 3.2 Installation Roadmap

4 Installing Oracle Data Profiling and Oracle Data Quality

• 4.1 Preparing to Install
  • 4.1.1 Review System Requirements and Certification
  • 4.1.2 Define User Accounts
    • 4.1.2.1 Define an Oracle Data Quality Application Administrator
    • 4.1.2.2 Define Oracle Data Quality Loader Users
  • 4.1.3 Identify Available Ports
• 4.2 Installing Oracle Data Quality Products
  • 4.2.1 Starting the Installer
  • 4.2.2 Installation Log Files
  • 4.2.3 Installing on UNIX Operating Systems
  • 4.2.4 Installing on Windows Operating Systems
• 4.3 Installing Additional Postal Tables
  • 4.3.1 Postal Table Naming Conventions
  • 4.3.2 Postal Code Installation Locations
  • 4.3.3 Alternative Postal Code Installation Locations
  • 4.3.4 Removing a Postal Directory Definition
  • 4.3.5 Postal Code Installation Procedures
  • 4.3.6 Setting Up a Global Postal Service on UNIX Operating Systems
  • 4.3.7 Setting up a Global Postal Service on Windows Operating Systems
• 4.4 Post-Installation Configuration Tasks
  • 4.4.1 Start the Oracle Data Quality Scheduler
  • 4.4.2 Configure Environment Variables for UNIX Operating Systems
  • 4.4.3 Configure inetd.conf File

Part III 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 Oracle Data Profiling and Data Quality Installation Screens

• B.1 Welcome
• B.2 Select Components Screen (Windows Operating Systems Only)
• B.3 Prerequisite Checks
• B.4 Specify Installation Location
• B.5 Metabase Server Details
• B.6 Metabase Client Details (Windows Operating Systems Only)
• B.7 Installation Summary
• B.8 Configuration Progress
• B.9 Installation Completed

C Silent Installations

• C.1 About Silent Installation
• C.2 Oracle Data Integrator Response Files
• C.3 Oracle Data Quality Response Files

D Deinstalling Oracle Data Integrator and Oracle Data Quality

• D.1 Deinstallation Instructions
  • D.1.1 Stopping Oracle Fusion Middleware
  • D.1.2 Stopping a Standalone Agent
  • D.1.3 Removing the Oracle Data Integrator Schemas
  • D.1.4 Removing Oracle Data Integrator Components
    • D.1.4.1 Starting the Deinstaller
  • D.1.5 Removing Oracle Data Quality Components
    • D.1.5.1 Starting the Deinstaller
  • D.1.6 Removing the ODI Home and ODQ Home
  • D.1.7 Removing the Oracle Common Home
  • D.1.8 Removing Oracle WebLogic Server
  • D.1.9 Removing the Program Groups (Windows Only)
  • D.1.10 Removing Entries from Services File on UNIX Operating Systems
  • D.1.11 Removing Entries from inetd.conf File on UNIX Operating Systems
• D.2 Reinstallation

E Oracle Data Integrator Deinstallation Screens

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

F Oracle Data Integrator Companion CD

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

G Creating Repositories with Oracle Data Integrator Studio

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

H Customizing the ODI Credential Map Name

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

I OPMN Configuration for Standalone Agent

• I.1 Add a Standalone Agent to OPMN
• I.2 Stopping the Agent
• I.3 Starting the Agent and Agent Components
• I.4 Determining the status of Oracle HTTP Server

Index