Go to main content
1/17
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
JDBC and Code Template-based Connectivity
Choosing a Connection Technology
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 Oracle 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 Oracle 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
Deploying and Executing SAP ABAP Mappings
Automated System
Semi-Automated System
Manual System
8
Integrating with Oracle ERP 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 Oracle 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 Oracle 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
Scripting on this page enhances content navigation, but does not change the content in any way.