Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Conventions
• Getting Help
• Related Publications

1 Connecting to Sources and Targets in Oracle Warehouse Builder

• Supported Sources and Targets
• Connecting to an Oracle Database
• Oracle Database Heterogeneous Services
  • Connecting Through Oracle Database Gateways
  • Connecting Through JDBC
  • Choosing JDBC or Gateways Connectivity
  • Connecting Through ODBC
• Connecting To Enterprise Applications
• Choosing a Connection Technology
• Flexible Code Templates for Data Movement

2 Connecting to Data Sources and Importing Metadata

• About Source Data and Metadata
• General Steps for Importing Metadata from Sources
  • About Locations
    • Creating Locations
    • Granting Privileges to a Target Location
    • Registering and Unregistering Locations
    • Deleting Locations
    • Locations Registered in Multiple Control Centers
  • About DB Connectors and Directories
  • About Modules
    • Creating Modules
    • Creating User Folders
• Using the Import Metadata Wizard
• Importing Metadata Definitions from Oracle Database
  • Edit Oracle Database Location Dialog Box
  • Importing Metadata Definitions
  • Filter Information Page
  • Object Selection Page
  • Summary and Import Page
  • Import Results Page
• Reimporting Definitions
  • Advanced Import Options
    • Advanced Import Options for Views and External Tables
    • Advanced Import Options for Tables
    • Advanced Import Options for Object Types
  • Updating Source Module Definitions

3 Using Flat Files as Sources or Targets

• About Flat Files
  • About Metadata for Flat Files
  • About Flat File Modules and Locations
  • Working with Flat Files as Sources or Targets
  • Flat Files as Sources
    • Defining Character Data Files
    • About External Tables
    • Choosing Between External Table and Flat File Operators
  • Flat Files as Targets
  • Creating Flat File Modules
    • Describing the Flat File Module
    • Defining Locations for Flat File Modules
    • Connection Information Page
    • Edit File System Location Dialog Box
• Using the Create Flat File Wizard
  • Describing a Flat File
  • Defining File Properties for a Flat File
    • Record Organization
    • Logical Record Definition
    • Number of Rows to Skip
    • Field Format
  • Defining the Record Type for a Flat File
  • Defining Field Properties for a Flat File
    • SQL*Loader Properties
    • SQL Properties
• Importing Definitions from Flat Files Using Sampling
  • Using the Flat File Sample Wizard
    • Flat File Wizard for Simple Flat Files
    • Describing the Flat File
    • Specifying the Record Organization
    • Specifying Field Properties
    • Flat File Wizard For Complex Flat Files
    • Describing the Flat File
    • Selecting the Record Organization
    • Selecting the File Format
    • Selecting the File Layout
    • Selecting Record Types (Multiple Record Type Files Only)
    • Specifying Field Lengths (Fixed-Length Files Only)
    • Specifying Field Properties
• Importing Metadata Definitions from COBOL Copybooks
  • Understanding Data Hierarchy in COBOL Applications
    • COBOL Data Types
    • Arrays Defined on Fields
  • Multiple Definitions
    • Defining Multiple Records
    • Defining Group Fields
    • Redefining Fields and Groups
    • COBOL File Formats
  • Reinterpreting COBOL Data Structures Into Relational Data Structures
  • Importing Metadata
    • Import Cobol Session Options
  • Example: Extracting Data from a Single Record Type Varying Array COBOL File
    • Importing The COBOL Copybook
    • Defining the File Properties
    • Creating a Mapping to Load Data
    • Configuring The Mapping
    • Specifying the Data File
    • Executing the Mapping
• Viewing and Editing a File Definition
  • Name Tab
  • General Tab
  • Record Tab
  • Structure Tab
• Using External Tables
  • Creating a New External Table Definition
    • Name Page
    • File Selection Page
    • Locations Page
  • Importing an External Table
  • Editing External Table Definitions
    • Name Tab
    • Columns Tab
    • File Tab
    • Locations Tab
    • Data Rules Tab
    • Access Parameters Tab
  • Synchronizing an External Table Definition with a Record in a File
  • Configuring External Tables
    • Access Specification
    • Reject
    • Parallel
    • Data Characteristics
    • Field Editing
    • Identification
    • Data Files

4 Connecting to Non-Oracle Data Sources Through Gateways

• Connecting to a DB2 Database
  • Creating a DB2 Module
    • Edit Non-Oracle Location Dialog Box
• Connecting to a SQL Server Database
  • Creating a SQL Server Module
    • Edit Non-Oracle Location Dialog Box
• Connecting to an ODBC Data Source
  • Setting up ODBC Connectivity
    • Installing ODBC Driver
    • Creating a System DSN
    • Configuring the Database
  • Creating an ODBC Module
    • Edit Non-Oracle Location Dialog Box
• Importing Database Objects

5 Connecting to Microsoft Data Sources Through ODBC Connection

• Connecting to Excel Spreadsheets Through ODBC
  • Case Study
  • Troubleshooting
• Connecting to SQL Server Database Through ODBC
  • Creating an ODBC Data Source
  • Configuring the Oracle Database Server
    • Creating a Heterogeneous Service Configuration File
    • Editing the listener.ora file
  • Adding the SQL Server as a Source in Warehouse Builder
  • Troubleshooting

6 Connecting to Data Sources Through JDBC

• Generic Connection Using JDBC
• Connecting to DB2 Database
  • Creating a DB2 Module
  • Importing Metadata into a DB2 Module
• Connecting to SQL Server Database
  • Creating a SQL Server Module
  • Importing Metadata into a SQL Server Module
• Importing Metadata from Other Databases Using JDBC

7 Extracting Data from SAP Applications

• Why SAP Connector
• Supported SAP Versions
• Overview of SAP Objects
  • SAP Object Types
  • SAP Business Domains
• Overview of the Interaction Between Warehouse Builder and SAP
  • SAP Function Modules
  • Data Retrieval Mechanisms
• Implementing the SAP Data Retrieval Mechanism
• Connecting to the SAP System
  • Required Files for SAP Connector
  • Troubleshooting Connection Errors
  • Creating SAP Module Definitions
    • Connecting to the SAP System
• Importing Metadata from SAP Tables
  • Importing SAP Metadata Definitions
    • Filtering SAP Metadata
    • Selecting Objects for Metadata Import
    • Reviewing Import Summary
    • Reimporting SAP Tables
  • Analyzing Metadata Details
• Creating SAP Extraction Mappings
  • Defining the SAP Extraction Mapping
    • Adding SAP Tables to the Mapping
    • Setting the Loading Type
    • Setting Configuration Properties for the Mapping
    • Setting the Join Rank
• Retrieving Data from the SAP System
  • Automated System
  • Semi-Automated System
  • Manual System

8 Importing Metadata from Oracle Enterprise Applications

• Importing Metadata from Oracle E-Business Suite Applications
  • Importing E-Business Suite Metadata Definitions
    • Creating an E-Business Suite Module
    • Edit Non-Oracle Location Dialog Box
    • Importing E-Business Suite Metadata
    • Filtering E-Business Suite Metadata
    • Selecting the Objects
    • Reviewing Import Summary
• Importing Metadata from PeopleSoft Applications
  • Importing PeopleSoft Metadata Definitions
    • Creating a PeopleSoft Module
    • Importing PeopleSoft Metadata
    • Filtering PeopleSoft Metadata
    • Selecting the Objects
    • Reviewing Import Summary
• Importing Metadata from Siebel Applications
  • Importing Siebel Metadata Definitions
    • Creating a Siebel Source Module
    • Importing Siebel Metadata
• Importing Metadata from Applications Implemented on non-Oracle Databases
  • Connecting to a PeopleSoft Application Implemented on SQL Server

9 Importing Warehouse Builder Data into Business Intelligence Applications

• Creating Business Definitions for Oracle BI Discoverer
  • Creating Oracle Discoverer Module
    • Naming the Oracle Discoverer Module
    • Setting the Connection Information
    • Reviewing the Summary Information
  • About Item Folders
  • Editing an Item Folder
    • Name Editor
    • Source Items Editor
    • Items Editor
    • Joins Editor
    • Conditions Editor
    • Composition Editor
    • General Properties of an Item Folder
  • Creating an Item Folder
    • Using the Create Item Folder Wizard
    • Naming and Describing the Item Folder
    • Selecting Source Items
    • Selecting the Join
    • Reviewing the Summary
    • Using the Graphical Navigator to Create Item Folders
    • Adding Joins Using the Graphical Navigator
    • Synchronizing Item Folders
    • Synchronize Item Folder Dialog Box
  • Creating a Business Area
    • Using the Create Business Area Wizard
    • Using the Graphical Navigator
  • Editing a Business Area
    • Name Editor
    • Source Editor
    • Contents Editor
  • Creating a Drill Path
    • Naming the Drill Path
    • Specifying Drill Levels
    • Specifying the Join
    • Reviewing the Summary
  • Editing a Drill Path
    • Editing the Drill Path Name
    • Reviewing the Drill Levels in the Drill Path
  • Creating Lists of Values
    • Naming the List of Values
    • Defining Items in a List of Values
    • Referencing Items in a List of Values
    • Reviewing the Summary
  • Editing Lists of Values
    • Editing the Name
    • Editing the Defining Items
    • Editing the Referencing Items
    • Editing the Options
  • Creating Alternative Sort Orders
    • Naming the Alternative Sort Order
    • Defining Item for the Alternative Sort Order
    • Defining Order Item for the Alternative Sort Order
    • Referencing Items for the Alternative Sort Order
    • Referencing Selection Panel for the Alternative Sort Order
    • Reviewing the Summary
  • Editing Alternative Sort Orders
    • Editing the Alternative Sort Order Name
    • Editing the Defining Item
    • Editing the Defining Order Item
    • Editing the Referencing Items
    • Editing the Options
  • Creating Drills to Detail
    • Create Drill to Detail Dialog Box
  • Editing Drills to Detail
  • Creating Registered Functions
    • Naming the Registered Function
    • Specifying the Function Parameters
    • Reviewing the Summary
  • Editing Registered Functions
    • Renaming a Registered Function
    • Modifying the Parameters of a Registered Function
• Configuring Discoverer Objects
  • Configuration Parameters for Oracle Discoverer modules
  • Configuration Parameters for Item Folders
  • Configuration Parameters for Registered Functions
• Deploying Business Definitions to Oracle BI Discoverer
  • Directly Deploying Business Definitions to Oracle BI Discoverer
  • Deploying Business Definitions to Earlier Versions of Oracle BI Discoverer
  • Indirectly Deploying Business Definitions to Oracle BI Discoverer
• Accessing BI Objects Using Oracle BI Discoverer
  • Using Business Definitions in Oracle BI Discoverer
• Creating Business Definitions for OBIEE
  • Creating an Oracle Business Intelligence Module
    • Defining Oracle Business Intelligence Location
  • About Logical Tables
  • Editing a Logical Table
    • Name Editor
    • Source Items Editor
    • Items Editor
    • Joins Editor
    • Composition Editor
  • Creating a Logical Table
    • Using the Create Logical Table Wizard
    • Naming and Describing the Logical Table
    • Selecting Source Items
    • Selecting the Foreign Key
    • Reviewing the Summary
    • Using the Graphical Navigator to Create Logical Tables
    • Adding Joins Using the Graphical Navigator
    • Synchronizing Logical Tables
    • Using the Synchronize Logical Table Dialog Box
  • Creating a Dimension Drill Path
    • Naming the Dimension Drill Path
    • Specifying Drill Levels
    • Specifying the Drill Level Key
    • Reviewing the Summary
    • Properties of a Dimensional Drill Path
  • Editing a Dimension Drill Path
    • Editing the Dimension Drill Path Name
    • Reviewing the Drill Levels in the Dimension Drill Path
  • Creating a Catalog Folder
    • Using the Create Catalog Folder Wizard
    • Naming the Catalog Folder
    • Selecting the Source
    • Reviewing the Summary
    • Using the Graphical Navigator
  • Editing a Catalog Folder
    • Name Editor
    • Source Editor
    • Contents Editor
• Configuring Oracle Business Intelligence Objects
  • Configuration Parameters for Oracle Business Intelligence Modules
• Accessing BI Objects Using OBIEE
  • Merging Updated RPD Files
• Deriving BI Objects
  • Selecting Source Objects
  • Selecting a Target for the Derived Objects
  • Specifying Derivation Rules
    • Setting Global Rules
  • Reviewing the Pre Derivation Rules
  • Reviewing Derivation Progress
  • Finishing the Derivation

10 Importing Design Definitions from Oracle Designer

• Using Oracle Designer Sources
  • Using Oracle Designer as a Metadata Source

11 Creating New Platforms

• Creating a New Platform
• Defining the Properties of a New Platform
  • Defining the Platform Type
  • Defining the Data Type Map
  • Generic Data Types Supported in Warehouse Builder
  • DB2 Data Types Mapping
  • MS SQL Server Data Types Mapping
  • Creating Modules Based on a Platform
• Creating a Microsoft Excel Platform
  • Importing an Excel Worksheet
• Using Custom Metadata Import in Platforms
  • Example: Implementing SQL-Based CMI Import for DB2 UDB
• Defining Other Platforms

12 Using Code Templates to Load and Transfer Data

• About Code Templates
  • Load Code Template
  • Integration Code Template
  • Control Code Template
  • Change Data Capture Code Template
  • Oracle Target Code Template
  • Function Code Template
  • Predefined Code Templates
• Working with Code Templates
  • Creating a Code Template Folder
  • Creating a Code Template
  • Importing a Code Template
  • Tasks in a Code Template
  • Using Code Templates
    • Creating a Template Mappings Module
    • Specifying an Agent for Template Mappings
    • Edit Agent Location Dialog Box
    • Creating a Mapping Under the Code Template Mapping
    • Using Code Templates in the Mapping

13 Importing and Publishing Web Services

• Defining Web Services
• Publishing Functions as Web Services
  • Operations and Parameters Generated in a Web Service
  • Creating a Web Service
    • Creating an Application Server Module
    • Providing an Application Server Location
    • Creating the Web Service
• Importing External Web Services

Index