Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Upgrading Oracle Data Integrator

1 Oracle Data Integrator Upgrade Overview

• 1.1 Flowchart of the Oracle Data Integrator Upgrade Process
• 1.2 Steps in the Oracle Data Integrator Upgrade Process

2 Oracle Data Integrator 11g for 10g Users

• 2.1 Components of the Oracle Data Integrator Installation
• 2.2 Important Changes for Oracle Data Integrator 10g Users
  • 2.2.1 Upgrade Considerations
  • 2.2.2 Changes in the Run-Time Agent
  • 2.2.3 Other Changes

3 Upgrading Your Oracle Data Integrator Environment

• 3.1 Task 1: Understand the Starting Points for Oracle Data Integrator
  • 3.1.1 Starting Points When Upgrading the Middle Tier Instance
  • 3.1.2 Starting Points When Upgrading the Oracle Data Integrator Repositories
• 3.2 Task 2: Plan the Oracle Data Integrator Component Architecture
• 3.3 Task 3: If Necessary, Upgrade the Database that Contains the ODI Repository
• 3.4 Task 4: Copy (Clone) Existing 10g Master and Work Repositories
  • 3.4.1 Schema Cloning Process for Oracle Database
  • 3.4.2 Schema Cloning Process for Microsoft SQL Server Database
  • 3.4.3 Schema Cloning Process for PostgreSQL Database
  • 3.4.4 Schema Cloning Process for IBM DB2 Universal Database
    • 3.4.4.1 Same Host Cloning Process for ODI 10g Master and Work Schemas
    • 3.4.4.2 Different Host Cloning Process for ODI 10g Master and Work Schemas
  • 3.4.5 Schema Cloning Process for IBM DB2 AS/400 Database
  • 3.4.6 Schema Cloning Process for Sybase AS Enterprise 15+
  • 3.4.7 Schema Cloning Process for Hypersonic SQL 1.7.3.3
• 3.5 Task 5: Create a Backup of the ODI Repositories to be Upgraded
• 3.6 Task 6: Install and Configure Oracle Data Integrator 11g
• 3.7 Task 7: Run Upgrade Assistant to Upgrade ODI Middle Tier and Repositories
  • 3.7.1 Task 7a: Run the Upgrade Assistant for Oracle Data Integrator
  • 3.7.2 Task 7b: Upgrade the Middle Tier Instance
  • 3.7.3 Task 7c: Upgrade the Oracle Data Integrator Repositories
• 3.8 Task 8: Perform Any Required Post-Upgrade Manual Steps

4 Oracle Data Integrator Post-Upgrade Tasks

• 4.1 Redistributing Centralized Repositories After Upgrade
• 4.2 Updating the Work Repository Connection Parameters
• 4.3 Updating Topology and Security Metadata
• 4.4 Re-applying ODI 10g Modifications to the ODI 11g Topology and Security Metadata
• 4.5 Replacing KMs with Mandatory Updates

Part II Upgrading Oracle Data Profiling and Oracle Data Quality

5 Oracle Data Profiling and Oracle Data Quality Upgrade Overview

• 5.1 Steps in the Oracle Data Profiling and Data Quality Upgrade Process

6 Oracle Data Profiling and Data Quality for 10g Users

• 6.1 Components of the Oracle Data Quality 11g Release 1 Installation

7 Upgrading Your Oracle Data Profiling and Quality Environment

• 7.1 Preparing to Upgrade
  • 7.1.1 Understand the Supported Upgrade Starting Points
  • 7.1.2 Backup the Existing Repository
  • 7.1.3 Install Oracle Data Profiling and Oracle Data Quality for Data Integrator
  • 7.1.4 Copy the Existing Repository to the Oracle Data Quality Server
  • 7.1.5 Remove User-Defined Metabases and Users
• 7.2 Oracle Data Quality Upgrade Instructions

8 Oracle Data Profiling and Quality Post-Upgrade Tasks

• 8.1 Update Metabase Connections
• 8.2 Validate the Upgrade Operation

A Oracle Data Integrator Upgrade Screens

• A.1 Welcome
• A.2 Specify Operation
• A.3 Specify Source Home
• A.4 Prerequisites
• A.5 Target Database
• A.6 Specify Work Repositories
• A.7 Examine
• A.8 Upgrade Summary
• A.9 Upgrade Progress
• A.10 End of Upgrade

Index