Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Publications
• Conventions

1 Installation Overview and Requirements

• Warehouse Builder Architecture and Components
  • Design Center
  • Target Schema
  • Warehouse Builder Repository
  • Repository Browser
  • Control Center Service
  • Implementation Strategies
• General Steps for Installing Warehouse Builder
• Understanding the Installation Requirements
• Preparing the Server
  • Preparing UNIX Servers
  • Preparing Microsoft Windows Servers
• Preparing the Oracle Database
  • Configuration Settings for the Warehouse Builder Repository
    • Parameters for the Design Repository Database Instance
    • Parameters for the Runtime Repository Database Instance
    • Configuring the Target Data File Path for Flat File Targets
  • Hosting the Repository on Oracle Database Standard Edition
• Preparing Client Machines
• About the Oracle Universal Installer
  • Installing the Warehouse Builder Software
    • Checklist: Before You Launch the Universal Installer
    • For Windows Users
    • For UNIX Users
  • Launching Warehouse Builder Components
• Steps for Installing Warehouse Builder in RAC Environments
  • Installing Warehouse Builder on Each Node of a Cluster
    • Checklist: Before Using the Universal Installer in a RAC Environment
    • For Windows Users
    • For UNIX Users
  • Ensuring the Availability of Service Names for RAC Nodes

2 Installing an Oracle Warehouse Builder Repository

• Using the Repository Assistant
• Options for Installing a Warehouse Builder Repository
  • Basic Installation
  • Advanced Setup
• Connecting to the Oracle Database
  • Defining a User and an Owner in the Basic Installation
    • Guidelines for User Names and Passwords
• Installing a Repository using the Advanced Setup Options
  • Managing the Warehouse Builder Repository Owner
    • Selecting the Default Tablespaces
    • Selecting the Base Language
    • Adding Display Languages
    • Dropping Repository Owners
  • Managing Warehouse Builder Repository Users
    • Selecting Repository Users
    • Deleting Repository Users
• Implementing a Remote Runtime (Optional)
  • Remote Runtime Scenarios
  • Steps for Installing and Testing Remote Runtime
• Setting the Security Policy for the Repository (Optional)

3 Upgrading to Oracle Warehouse Builder 10g Release 2 (10.2)

• General Steps for Upgrading to Warehouse Builder 10g Release 2 (10.2)
• Migrating An Oracle Database Environment
  • Migrating a Complete Database
  • Selectively Migrating a Warehouse Builder Environment to a New Database
    • Exporting Target Schemas from the Existing Runtime Environment
    • Creating the Target Schemas in the New Database
    • Copying External Directory References to the New Database Instance
    • Importing Target Schemas to the New Database
    • Registering the Users from the Previous Warehouse Builder Environment
• Upgrading a Design Repository
  • Upgrading Design Metadata to Warehouse Builder 10g Release 2 (10.2)
    • Exporting Design Metadata from a Prior Release of Warehouse Builder
    • Importing Design Metadata to Warehouse Builder 10g Release 2
• Upgrading a Runtime Repository to a Control Center
  • Using the Control Center Upgrade Assistant
  • Connecting to a New Control Center
  • Connecting to an Existing Runtime Repository
  • Choosing An Upgrade Operation
    • Move
    • Upgrade
    • Upgrade Operation: Location Details
    • Generate
  • Reviewing Selections in the Upgrade Assistant
  • Upgrading Locations in the Design Repository
• Reusing and Redeploying Specific Objects
  • Redeploying Dimensions and Cubes
  • Reusing Advanced Queues
  • Redeploying Process Flows
  • Updating Mapping Configuration to Benefit from New Features
  • Reusing Flat Files and External Directories from a Different Database Instance

4 Deinstalling Oracle Warehouse Builder

• General Steps for Deinstalling Warehouse Builder
• Deleting the Repository Users
• Deleting the Repository Owner
• Deinstalling the Oracle Warehouse Builder Software
• Deleting the Schema Objects

5 Installing Optional Components

• Enabling Integration with Oracle E-Business Suite
• Configuring Repository Browser Environments
• Installing Third-Party Name and Address Data
• Configuring Oracle Enterprise Manager
  • Creating the Enterprise Manager Repository
  • Creating a Windows User
  • Configuring Preferred Credentials
  • Configuring Enterprise Manager for the Oracle Developer Suite
• Installing Oracle Workflow
  • Installing the Oracle Workflow Server
  • Installing the Workflow Client (Optional)

6 Diagnosing and Debugging an Installation

• Debugging
  • Log File Locations
  • Not Able to Launch any of the Warehouse Builder clients or other Oracle products
  • Warehouse Builder Freezes or Hangs
  • Additional Error Logging for Errors and Other Unexpected Behavior
  • Checking Java Virtual Machine (JVM)
  • Detecting Database Server Issues When Installing on HP-UX
• Diagnostics

7 Implementing Security in Warehouse Builder

• About Metadata Security in Warehouse Builder
  • About the Security Interface
• Metadata Security Strategies
  • Minimal Metadata Security Strategy (Default)
  • Multi-user Security Strategy
  • Full Metadata Security Strategy
• Registering Database Users as Warehouse Builder Users
  • Selecting Existing or Creating New Database Users
    • Creating an Oracle Database User in Warehouse Builder
    • Changing Database Default Roles
  • User Schema as Target Option
• Editing User Profiles
  • Roles
  • Default Object Privilege
    • Object Privileges
  • System Privileges
• Defining Security Roles
  • Everyone Role
  • Administrator Role
• Editing Role Profiles
  • Users
• Applying Security Properties on Specific Metadata Objects
  • Security Tab
    • Example: Using Security Properties to Freeze a Project Design
• Security Enforcement
• Managing Passwords in Warehouse Builder
  • Changing Passwords
  • Encrypting Passwords to Warehouse Builder Locations
    • Limited Password Security in Oracle Database Standard Edition
• Support for a Multiple-user Environment
  • Read/Write Mode
  • Read-Only Mode

Index