Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Conventions
• Related Publications

1 Installation Overview and Requirements

• Warehouse Builder Architecture and Components
  • Design Center
  • Target Schema
  • Warehouse Builder Repository
  • Repository Browser
  • Control Center Service
  • Implementation Strategies
    • Basic Implementation
    • Traditional Client/ Server Implementation
    • Repository on Oracle Database 10g Release 2
    • Separate Design and Runtime Environments Implementation
    • Remote Runtime Environment Implementation
• General Steps for Installing Warehouse Builder
• Understanding the Installation Requirements
• Preparing the Server
  • UNIX Servers Hosting a Warehouse Builder Repository on Oracle 10g Release 2
  • Windows Servers Hosting a Warehouse Builder Repository on Oracle 10g Release 2
• Preparing the Oracle Database
  • Database Configuration Settings for the Warehouse Builder Repository
  • Configuring the Target Data File Path for Flat File Targets
  • Configuring Oracle 10g Databases for Design and Runtime Repositories (Optional)
    • Parameters for the Design Repository Database Instance
    • Parameters for the Runtime Repository Database Instance
• Preparing Client Computers
• Downloading and Installing the Standalone Warehouse Builder Software
  • About the Oracle Universal Installer
  • Installing the Warehouse Builder Software
    • Checklist: Before You Start the Universal Installer
    • Running the Oracle Universal Installer for Warehouse Builder on Windows
    • Running the Oracle Universal Installer for Warehouse Builder on UNIX
  • Launching Warehouse Builder Components
• Hosting the Repository on Oracle Database 10g Release 2
  • Running Scripts to Create a Warehouse Builder Repository Schema
  • Enabling Access to Workspaces Hosted on Oracle 10g Databases
• Steps for Installing Warehouse Builder in Oracle RAC Environments
  • Installing Warehouse Builder on Each Node of a Cluster
    • Checklist: Before Using the Universal Installer in an Oracle RAC Environment
    • For Windows Users Installing in an Oracle RAC Environment
    • For UNIX Users Installing in an Oracle RAC Environment
  • Ensuring the Availability of Service Names for Oracle RAC Nodes

2 Managing Workspaces and Workspace Users

• Using the Repository Assistant
• Connecting to the Oracle Database
  • Defining Workspace Users
    • Guidelines for User Names and Passwords
• Choosing Workspace Operations
  • Managing Workspaces
    • Dropping Workspaces
    • Selecting the Default Tablespaces
  • Selecting the Base Language for the Repository
    • Adding Display Languages
  • Managing Workspace Users
    • Selecting Workspace Users
    • Deleting Workspace 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 11g Release 1 (11.1)

• General Steps for Upgrading to Warehouse Builder 11g Release 1 (11.1)
• Migrating An Oracle Database Environment
  • Migrating a Complete Database
  • Migrating an Oracle Workflow Schema
  • Selectively Migrating a Warehouse Builder Environment to a New Database
    • Exporting Target Schemas from the Existing Runtime Environment
    • Creating the Target Schemas and Users in the New Database
    • Copying External Directory References to the New Database Instance
    • Importing Target Schemas to the New Database
• Upgrading a Design Repository
  • Migrating All Design Metadata from Warehouse Builder 10g Release 2 (10.2)
    • Exporting All Design Metadata from Warehouse Builder 10g Release 2 (10.2)
    • Importing All Design Metadata into the Current Release
  • Selectively Migrating Design Metadata
    • Exporting Design Metadata from a Prior Release of Warehouse Builder
    • Importing Design Metadata to Warehouse Builder
• Upgrading Existing Control Centers or Runtime Repositories
  • Using the Control Center Upgrade Assistant
  • Connecting to a New Control Center
    • Choose a Workspace
  • Connecting to an Existing Runtime Repository Or Control Center
  • 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
  • Reusing Oracle Workflow Locations
  • Reusing Process Flows and Schedules
  • Reusing Flat Files and External Directories from a Different Database Instance
  • Reusing Data Profiles

4 Deinstalling Oracle Warehouse Builder

• General Steps for Deinstalling Oracle Warehouse Builder
• Deleting the Workspace Users
• Deleting the Workspace Owner
• Deinstalling the Oracle Warehouse Builder Software
• Deleting the Schema Objects
• Deleting a Repository from an Oracle 10g Database

5 Installing and Enabling Optional Components

• Enabling Integration with Oracle E-Business Suite
• Configuring Repository Browser Environments
• Installing Third-Party Name and Address Data
• Enabling Integration with Oracle Workflow

6 Troubleshooting a Warehouse Builder Installation

• General Steps for Troubleshooting Warehouse Builder
• Error Messages Related to Installation
• Troubleshooting Installation Problems That Do Not Display Error Messages
• Reviewing Log Files
  • Log File Locations
  • Additional Error Logging for Errors and Other Unexpected Behavior
• Checking Java Virtual Machine (JVM)

7 Implementing Security in Warehouse Builder

• About Metadata Security
  • About the Security Interface
• Metadata Security Strategies
  • Minimal Metadata Security Strategy (Default)
  • Multiuser Security Strategy
  • Full Metadata Security Strategy
• Registering Database Users
  • Selecting Existing or Creating New Database Users
    • Creating an Oracle Database User
    • Changing Database Default Roles
• 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 that Access Warehouse Builder
  • Encrypting Passwords to Warehouse Builder Locations
• Support for a Multiple-user Environment
  • Read/Write Mode
  • Read-Only Mode

Index