Oracle Warehouse Builder Sources and Targets Guide Oracle Warehouse Builder Sources and Targets Guide
Connecting to Sources and Targets in Oracle Warehouse Builder “Connecting to Sources and Targets in Oracle Warehouse Builder”
Supported Sources and Targets “Supported Sources and Targets” Sources and Targets Supported in Oracle Warehouse Builder 11g Release 2 (11.2) “Sources and Targets Supported in Oracle Warehouse Builder 11g Release 2 (11.2)”
Oracle Database Heterogeneous Services “Oracle Database Heterogeneous Services”
Connecting Through Oracle Database Gateways “Connecting Through Oracle Database Gateways”
Connecting Through JDBC “Connecting Through JDBC”
Choosing JDBC or Gateways Connectivity “Choosing JDBC or Gateways Connectivity”
Connecting Through ODBC “Connecting Through ODBC”
Flexible Code Templates for Data Movement “Flexible Code Templates for Data Movement”
Connecting Through Code Templates “Connecting Through Code Templates”
Connecting Through ERP Application Connectors “Connecting Through ERP Application Connectors”
Choosing a Connection Technology “Choosing a Connection Technology”
Connecting to Oracle Database and Other Data Sources “Connecting to Oracle Database and Other Data Sources”
About Source Data and Metadata “About Source Data and Metadata”
General Steps for Importing Metadata from Sources “General Steps for Importing Metadata from Sources” Subsequent Steps “Subsequent Steps”
About Locations “About Locations” Automatically Created Locations “Automatically Created Locations” Types of Locations “Types of Locations”
Creating Locations “Creating Locations” Using SQL*Net to Create Locations “Using SQL*Net to Create Locations” About Locations, Passwords, and Security “About Locations, Passwords, and Security”
Granting Privileges to a Target Location “Granting Privileges to a Target Location” Upgrade Action “Upgrade Action” EUL Deployment “EUL Deployment”
Registering and Unregistering Locations “Registering and Unregistering Locations”
Deleting Locations “Deleting Locations”
Locations Registered in Multiple Control Centers “Locations Registered in Multiple Control Centers”
About DB Connectors and Directories “About DB Connectors and Directories”
About Modules “About Modules”
Creating Modules “Creating Modules”
Creating User-Defined Folders “Creating User-Defined Folders”
Using the Import Metadata Wizard “Using the Import Metadata Wizard”
Importing Metadata Definitions from Oracle Database “Importing Metadata Definitions from Oracle Database”
Edit Oracle Database Location Dialog Box “Edit Oracle Database Location Dialog Box” Name “Name” Description “Description” Type “Type” Schema “Schema” Version “Version” Test Connection “Test Connection” Test Results “Test Results”
Importing Metadata Definitions “Importing Metadata Definitions”
Filter Information Page “Filter Information Page” Selecting the Object Types “Selecting the Object Types” Search Based on the Object Name “Search Based on the Object Name”
Object Selection Page “Object Selection Page” Importing Dependent Objects “Importing Dependent Objects” Importing Dimensions “Importing Dimensions”
Summary and Import Page “Summary and Import Page”
Import Results Page “Import Results Page”
Reimporting Definitions “Reimporting Definitions”
Advanced Import Options “Advanced Import Options”
Advanced Import Options for Views and External Tables “Advanced Import Options for Views and External Tables”
Advanced Import Options for Tables “Advanced Import Options for Tables”
Advanced Import Options for Object Types “Advanced Import Options for Object Types”
Updating Source Module Definitions “Updating Source Module Definitions”
Using Flat Files as Sources or Targets “ Using Flat Files as Sources or Targets”
About Flat Files “About Flat Files”
About Metadata for Flat Files “About Metadata for Flat Files”
About Flat File Modules and Locations “About Flat File Modules and Locations”
Working with Flat Files as Sources or Targets “Working with Flat Files as Sources or Targets”
Flat Files as Sources “Flat Files as Sources”
Defining Character Data Files “Defining Character Data Files”
About External Tables “About External Tables”
Choosing Between External Table and Flat File Operators “Choosing Between External Table and Flat File Operators”
Flat Files as Targets “Flat Files as Targets” Creating a New Flat File as a Target “Creating a New Flat File as a Target”
Creating Flat File Modules “Creating Flat File Modules”
Describing the Flat File Module “Describing the Flat File Module”
Defining Locations for Flat File Modules “Defining Locations for Flat File Modules”
Connection Information Page “Connection Information Page”
Edit File System Location Dialog Box “Edit File System Location Dialog Box”
Using the Create Flat File Wizard “Using the Create Flat File Wizard”
Describing a Flat File “Describing a Flat File”
Defining File Properties for a Flat File “Defining File Properties for a Flat File”
Record Organization “Record Organization”
Logical Record Definition “Logical Record Definition”
Number of Rows to Skip “Number of Rows to Skip”
Field Format “Field Format”
Defining the Record Type for a Flat File “Defining the Record Type for a Flat File”
Defining Field Properties for a Flat File “Defining Field Properties for a Flat File”
SQL*Loader Properties “SQL*Loader Properties” Type “Type” Length “Length” Precision “Precision” Scale “Scale” Mask “Mask” NULLIF “NULLIF” DEFAULTIF “DEFAULTIF”
SQL Properties “SQL Properties” SQL Type “SQL Type” SQL Length “SQL Length” SQL Precision “SQL Precision” SQL Scale “SQL Scale”
Importing Definitions from Flat Files Using Sampling “Importing Definitions from Flat Files Using Sampling”
Using the Flat File Sample Wizard “Using the Flat File Sample Wizard”
Flat File Wizard for Simple Flat Files “Flat File Wizard for Simple Flat Files”
Describing the Flat File “Describing the Flat File”
Specifying the Record Organization “Specifying the Record Organization”
Specifying Field Properties “Specifying Field Properties”
SQL*Loader Properties “SQL*Loader Properties”
SQL Properties “SQL Properties”
Flat File Wizard For Complex Flat Files “Flat File Wizard For Complex Flat Files”
Describing the Flat File “Describing the Flat File”
Selecting the Record Organization “Selecting the Record Organization”
Specifying Logical Records “Specifying Logical Records”
Selecting the File Format “Selecting the File Format”
Selecting the File Layout “Selecting the File Layout”
Selecting Record Types (Multiple Record Type Files Only) “Selecting Record Types (Multiple Record Type Files Only)”
Example: Flat File with Multiple Record Types “Example: Flat File with Multiple Record Types” Example of a File with Multiple Record Types “Example of a File with Multiple Record Types”
Defining Multiple Record Organization in a Delimited File “Defining Multiple Record Organization in a Delimited File”
Defining Multiple Record Organization in a Fixed-Length File “Defining Multiple Record Organization in a Fixed-Length File”
Specifying Field Lengths (Fixed-Length Files Only) “Specifying Field Lengths (Fixed-Length Files Only)”
Specifying Field Lengths for Multiple Record Files “Specifying Field Lengths for Multiple Record Files”
Specifying Field Properties “Specifying Field Properties”
SQL*Loader Properties “SQL*Loader Properties”
SQL Properties “SQL Properties”
Importing Data from COBOL Copybooks “Importing Data from COBOL Copybooks”
Understanding Data Hierarchy in COBOL Applications “Understanding Data Hierarchy in COBOL Applications” COBOL Copybook “COBOL Copybook”
COBOL Data Types “COBOL Data Types”
Arrays Defined on Fields “Arrays Defined on Fields” Arrays Defined on Elementary Fields “Arrays Defined on Elementary Fields” Varying Array Defined on Elementary Fields “Varying Array Defined on Elementary Fields” Array Defined on a Group Field “Array Defined on a Group Field” Varying Array Defined on a Group Field “Varying Array Defined on a Group Field”
Multiple Definitions “Multiple Definitions”
Multiple Record Definitions “Multiple Record Definitions” Copybook With Multiple Records “Copybook With Multiple Records”
Group Fields “Group Fields”
Redefinition “Redefinition” Redefining a Field “Redefining a Field” Redefining a Group “Redefining a Group”
COBOL File Formats “COBOL File Formats”
Reinterpreting COBOL Data Structures Into Relational Data Structures “Reinterpreting COBOL Data Structures Into Relational Data Structures” Records “Records” Arrays “Arrays” Mapping COBOL Data Types to SQL Data Types “Mapping COBOL Data Types to SQL Data Types” COBOL Data Types and the Equivalent SQL *Loader Data Types “COBOL Data Types and the Equivalent SQL *Loader Data Types”
Importing Metadata “Importing Metadata” Importing a Copybook “Importing a Copybook”
Import Cobol Session Options “Import Cobol Session Options”
Example: Importing a Single Record Type Varying Array Copybook “Example: Importing a Single Record Type Varying Array Copybook”
Importing The COBOL Copybook “Importing The COBOL Copybook”
Defining the File Properties “Defining the File Properties”
Creating a Mapping to Load Data “Creating a Mapping to Load Data”
Configuring The Mapping “Configuring The Mapping”
Specifying the Data File “Specifying the Data File”
Viewing and Editing a File Definition “Viewing and Editing a File Definition”
Name Tab “Name Tab”
General Tab “General Tab”
Record Tab “Record Tab” Example of Record Type Values “Example of Record Type Values”
Structure Tab “Structure Tab”
Using External Tables “Using External Tables”
Creating a New External Table Definition “Creating a New External Table Definition” Before you begin “Before you begin”
Name Page “Name Page”
File Selection Page “File Selection Page”
Locations Page “Locations Page”
Importing an External Table “Importing an External Table”
Editing External Table Definitions “Editing External Table Definitions”
Name Tab “Name Tab”
Columns Tab “Columns Tab”
File Tab “File Tab”
Locations Tab “Locations Tab”
Data Rules Tab “Data Rules Tab”
Access Parameters Tab “Access Parameters Tab”
Synchronizing an External Table Definition with a Record in a File “Synchronizing an External Table Definition with a Record in a File”
Configuring External Tables “Configuring External Tables”
Access Specification “Access Specification”
Reject “Reject”
Parallel “Parallel”
Data Characteristics “Data Characteristics”
Field Editing “Field Editing”
Identification “Identification”
Data Files “Data Files”
Connecting to non-Oracle Data Sources Through Gateways “Connecting to non-Oracle Data Sources Through Gateways”
Connecting to a DB2 Database “Connecting to a DB2 Database”
Creating a DB2 Module “Creating a DB2 Module”
Connecting to a SQL Server Database “Connecting to a SQL Server Database”
Creating a SQL Server Module “Creating a SQL Server Module”
Connecting to an ODBC Data Source “Connecting to an ODBC Data Source”
Setting up ODBC Connectivity “Setting up ODBC Connectivity”
Installing ODBC Driver “Installing ODBC Driver”
Creating a System DSN “Creating a System DSN”
Configuring the Database “Configuring the Database” Creating a Heterogeneous Services Initialization File “Creating a Heterogeneous Services Initialization File” Configuring the listener.ora file “Configuring the listener.ora file”
Creating an ODBC Module “Creating an ODBC Module”
Importing Database Objects “Importing Database Objects”
Connecting to Microsoft Data Sources Through ODBC Connection “Connecting to Microsoft Data Sources Through ODBC Connection”
Connecting to Excel Spreadsheets Through ODBC “Connecting to Excel Spreadsheets Through ODBC” Scenario “Scenario” Solution “Solution”
Case Study “Case Study” Step 1: Install ODBC Driver for Excel “Step 1: Install ODBC Driver for Excel” Step 2: Delimit the Data in the Excel File (Optional) “Step 2: Delimit the Data in the Excel File (Optional)” Step 3: Create a System DSN “Step 3: Create a System DSN” Step 4: Create the Heterogeneous Services Initialization File “Step 4: Create the Heterogeneous Services Initialization File” Step 5: Modify the listener.ora file “Step 5: Modify the listener.ora file” Step 6: Create an ODBC Source Module “Step 6: Create an ODBC Source Module” Step 7: Import Metadata from Excel Using the Metadata Import Wizard “Step 7: Import Metadata from Excel Using the Metadata Import Wizard” Step 8: Create a Mapping to Load Data Into the Target Table “Step 8: Create a Mapping to Load Data Into the Target Table” Step 9: Deploy the Mapping “Step 9: Deploy the Mapping”
Troubleshooting “Troubleshooting” Error “Error” Probable Cause “Probable Cause” Action “Action” Error “Error” Probable Cause “Probable Cause” Action “Action”
Connecting to SQL Server Through ODBC “Connecting to SQL Server Through ODBC” Scenario “Scenario” Solution “Solution” Case Study “Case Study”
Creating an ODBC Data Source “Creating an ODBC Data Source”
Configuring the Oracle Database Server “Configuring the Oracle Database Server”
Creating a Heterogeneous Service Configuration File “Creating a Heterogeneous Service Configuration File”
Editing the listener.ora file “Editing the listener.ora file”
Adding the SQL Server as a Source in Warehouse Builder “Adding the SQL Server as a Source in Warehouse Builder”
Troubleshooting “Troubleshooting” Error “Error” Probable Cause “Probable Cause” Action “Action” Error “Error” Probable Cause “Probable Cause” Action “Action”
Connecting to Data Sources Through JDBC “Connecting to Data Sources Through JDBC”
Generic Connection Using JDBC “Generic Connection Using JDBC”
Connecting to DB2 Database “Connecting to DB2 Database” JDBC Connection Drivers for DB2 “JDBC Connection Drivers for DB2” Modifying the ccastart.bat File “Modifying the ccastart.bat File”
Creating a DB2 Module “Creating a DB2 Module”
Importing Metadata into a DB2 Module “Importing Metadata into a DB2 Module”
Connecting to SQL Server Database “Connecting to SQL Server Database” JDBC Connection Driver for SQL Server “JDBC Connection Driver for SQL Server”
Creating a SQL Server Module “Creating a SQL Server Module”
Importing Metadata into a SQL Server Module “Importing Metadata into a SQL Server Module”
Importing Data from Other Databases Using JDBC “Importing Data from Other Databases Using JDBC”
Integrating with Applications “Integrating with Applications”
Integrating with E-Business Suite “Integrating with E-Business Suite” Before You Begin “Before You Begin”
Importing E-Business Suite Metadata Definitions “Importing E-Business Suite Metadata Definitions”
Filtering E-Business Suite Metadata “Filtering E-Business Suite Metadata”
Filtering E-Business Suite Metadata by Business Domain “Filtering E-Business Suite Metadata by Business Domain”
Filtering E-Business Suite Metadata by Text String “Filtering E-Business Suite Metadata by Text String”
Selecting the Objects “Selecting the Objects”
Reviewing Import Summary “Reviewing Import Summary”
Integrating with PeopleSoft “Integrating with PeopleSoft”
Importing PeopleSoft Metadata Definitions “Importing PeopleSoft Metadata Definitions”
Filtering PeopleSoft Metadata “Filtering PeopleSoft Metadata”
Filtering PeopleSoft Metadata by Business Domain “Filtering PeopleSoft Metadata by Business Domain”
Filtering PeopleSoft Metadata by Text String “Filtering PeopleSoft Metadata by Text String”
Selecting the Objects “Selecting the Objects”
Reviewing Import Summary “Reviewing Import Summary”
Integrating with Siebel “Integrating with Siebel”
Importing Siebel Metadata Definitions “Importing Siebel Metadata Definitions”
Creating a Siebel Source Module “Creating a Siebel Source Module”
Importing Siebel Metadata “Importing Siebel Metadata” Filtering Siebel Metadata by Text String “Filtering Siebel Metadata by Text String”
Extracting Data from SAP Applications “Extracting Data from SAP Applications”
Why SAP Connector “Why SAP Connector”
Supported SAP Versions “Supported SAP Versions”
Overview of SAP Objects “Overview of SAP Objects”
SAP Object Types “SAP Object Types”
SAP Business Domains “SAP Business Domains”
Overview of the Warehouse Builder-SAP Interaction “Overview of the Warehouse Builder-SAP Interaction”
SAP Function Modules “SAP Function Modules”
Data Rerieval Mechanisms “Data Rerieval Mechanisms” Completely Managed By Warehouse Builder “Completely Managed By Warehouse Builder” Managed By Warehouse Builder With SAP Verification “Managed By Warehouse Builder With SAP Verification” Manual “Manual”
Implementing an SAP Data Retrieval Mechanism “Implementing an SAP Data Retrieval Mechanism” Development Environment “Development Environment” Test and Production Environment “Test and Production Environment” Scenario 1 “Scenario 1” Scenario 2 “Scenario 2”
Connecting to an SAP System “Connecting to an SAP System”
Required Files For SAP Connector “Required Files For SAP Connector” Files Required In Windows “Files Required In Windows” Required Files for Windows “Required Files for Windows” Files Required In Unix “Files Required In Unix” Required Files for Unix “Required Files for Unix”
Troubleshooting Connection Errors “Troubleshooting Connection Errors” SAP Connection Errors “SAP Connection Errors”
Creating SAP Module Definitions “Creating SAP Module Definitions” Remote Function Call (RFC) “Remote Function Call (RFC)” SAP Remote Function Call (SAPRFC.INI) “SAP Remote Function Call (SAPRFC.INI)”
Connecting to an SAP System “Connecting to an SAP System”
Importing Metadata from SAP Tables “Importing Metadata from SAP Tables”
Importing SAP Metadata Definitions “Importing SAP Metadata Definitions”
Filtering SAP Metadata “Filtering SAP Metadata”
Filtering SAP Metadata by Business Domain “Filtering SAP Metadata by Business Domain”
Filtering SAP Metadata by Text String “Filtering SAP Metadata by Text String”
Selecting Objects for Metadata Import “Selecting Objects for Metadata Import”
Reviewing Import Summary “Reviewing Import Summary”
Reimporting SAP Tables “Reimporting SAP Tables”
Analyzing Metadata Details “Analyzing Metadata Details” Column Descriptions “Column Descriptions” Constraints Details “Constraints Details”
Creating SAP Extraction Mappings “Creating SAP Extraction Mappings”
Defining an SAP Extraction Mapping “Defining an SAP Extraction Mapping”
Adding SAP Tables to the Mapping “Adding SAP Tables to the Mapping”
Setting the Loading Type “Setting the Loading Type” SQL*Loader Code Generated in ABAP “SQL*Loader Code Generated in ABAP”
Setting Configuration Properties for the Mapping “Setting Configuration Properties for the Mapping” Setting the Language Parameter “Setting the Language Parameter” Setting the Runtime Parameters “Setting the Runtime Parameters”
Setting the Join Rank “Setting the Join Rank”
Retrieving Data from the SAP System “Retrieving Data from the SAP System”
Automated System “Automated System” Automated Data Retrieval “Automated Data Retrieval”
Semi Automated System “Semi Automated System”
Manual System “Manual System” Using SQL*Loader in the Process Flow “Using SQL*Loader in the Process Flow”
Importing Warehouse Builder Data into Business Intelligence Applications “Importing Warehouse Builder Data into Business Intelligence Applications”
Creating Business Definitions for Oracle BI Discoverer “Creating Business Definitions for Oracle BI Discoverer”
Creating Oracle Discoverer Module “Creating Oracle Discoverer Module”
Naming the Oracle Discoverer Module “Naming the Oracle Discoverer Module”
Setting the Connection Information “Setting the Connection Information”
Defining Discoverer Locations “Defining Discoverer Locations”
Reviewing the Summary Information “Reviewing the Summary Information”
About Item Folders “About Item Folders”
Editing an Item Folder “Editing an Item Folder”
Name Editor “Name Editor”
Source Items Editor “Source Items Editor” Deleting Items “Deleting Items”
Items Editor “Items Editor” Item Details “Item Details” Adding Items Through the Items Editor “Adding Items Through the Items Editor”
Joins Editor “Joins Editor”
Conditions Editor “Conditions Editor”
Composition Editor “Composition Editor” Adding Items Through the Composition Editor “Adding Items Through the Composition Editor” Deleting Items “Deleting Items”
General Properties of an Item Folder “General Properties of an Item Folder”
Creating an Item Folder “Creating an Item Folder”
Using the Create Item Folder Wizard “Using the Create Item Folder Wizard”
Naming and Describing the Item Folder “Naming and Describing the Item Folder”
Selecting Source Items “Selecting Source Items”
Selecting the Join “Selecting the Join”
Reviewing the Summary “Reviewing the Summary”
Using the Graphical Navigator to Create Item Folders “Using the Graphical Navigator to Create Item Folders” Using the Menu “Using the Menu” Using the Canvas “Using the Canvas” Steps to Create an Item Folder “Steps to Create an Item Folder” Adding Items to an Item Folder “Adding Items to an Item Folder”
Adding Joins Using the Graphical Navigator “Adding Joins Using the Graphical Navigator”
Synchronizing Item Folders “Synchronizing Item Folders”
Synchronize Item Folder Dialog Box “Synchronize Item Folder Dialog Box”
Creating a Business Area “Creating a Business Area”
Using the Create Business Area Wizard “Using the Create Business Area Wizard”
Naming the Business Area “Naming the Business Area”
Selecting the Item Folders “Selecting the Item Folders”
Reviewing the Summary “Reviewing the Summary”
Using the Graphical Navigator “Using the Graphical Navigator” Using the Menu “Using the Menu” Using the Canvas “Using the Canvas”
Editing a Business Area “Editing a Business Area”
Name Editor “Name Editor”
Source Editor “Source Editor”
Contents Editor “Contents Editor”
Creating a Drill Path “Creating a Drill Path”
Naming the Drill Path “Naming the Drill Path”
Specifying Drill Levels “Specifying Drill Levels”
Specifying the Join “Specifying the Join”
Reviewing the Summary “Reviewing the Summary”
Editing a Drill Path “Editing a Drill Path”
Editing the Drill Path Name “Editing the Drill Path Name”
Reviewing the Drill Levels in the Drill Path “Reviewing the Drill Levels in the Drill Path”
Creating Lists of Values “Creating Lists of Values”
Naming the List of Values “Naming the List of Values”
Defining Items in a List of Values “Defining Items in a List of Values”
Referencing Items in a List of Values “Referencing Items in a List of Values”
Reviewing the Summary “Reviewing the Summary”
Editing Lists of Values “Editing Lists of Values”
Editing the Name “Editing the Name”
Editing the Defining Items “Editing the Defining Items”
Editing the Referencing Items “Editing the Referencing Items”
Editing the Options “Editing the Options”
Creating Alternative Sort Orders “Creating Alternative Sort Orders”
Naming the Alternative Sort Order “Naming the Alternative Sort Order”
Defining Item for the Alternative Sort Order “Defining Item for the Alternative Sort Order”
Defining Order Item for the Alternative Sort Order “Defining Order Item for the Alternative Sort Order”
Referencing Items for the Alternative Sort Order “Referencing Items for the Alternative Sort Order”
Referencing Selection Panel for the Alternative Sort Order “Referencing Selection Panel for the Alternative Sort Order”
Reviewing the Summary “Reviewing the Summary”
Editing Alternative Sort Orders “Editing Alternative Sort Orders”
Editing the Alternative Sort Order Name “Editing the Alternative Sort Order Name”
Editing the Defining Item “Editing the Defining Item”
Editing the Defining Order Item “Editing the Defining Order Item”
Editing the Referencing Items “Editing the Referencing Items”
Editing the Options “Editing the Options”
Creating Drills to Detail “Creating Drills to Detail”
Create Drill to Detail “Create Drill to Detail”
Editing Drills to Detail “Editing Drills to Detail”
Creating Registered Functions “Creating Registered Functions”
Naming the Registered Function “Naming the Registered Function”
Specifying the Function Parameters “Specifying the Function Parameters”
Reviewing the Summary “Reviewing the Summary”
Editing Registered Functions “Editing Registered Functions”
Renaming a Registered Function “Renaming a Registered Function”
Modifying the Parameters of a Registered Function “Modifying the Parameters of a Registered Function”
Configuring Discoverer Objects “Configuring Discoverer Objects”
Configuration Parameters for Oracle Discoverer modules “Configuration Parameters for Oracle Discoverer modules”
Configuration Parameters for Item Folders “Configuration Parameters for Item Folders”
Configuration Parameters for Registered Functions “Configuration Parameters for Registered Functions”
Deploying Business Definitions to Oracle BI Discoverer “Deploying Business Definitions to Oracle BI Discoverer” Different Methods of Deploying Business Definitions “Different Methods of Deploying Business Definitions”
Directly 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 “Deploying Business Definitions to Earlier Versions of Oracle BI Discoverer”
Indirectly Deploying Business Definitions to Oracle BI Discoverer “Indirectly Deploying Business Definitions to Oracle BI Discoverer”
Accessing BI Objects Using Oracle BI Discoverer “Accessing BI Objects Using Oracle BI Discoverer”
Using Business Definitions in Oracle BI Discoverer “Using Business Definitions in Oracle BI Discoverer”
Creating Business Definitions for OBIEE “Creating Business Definitions for OBIEE”
Creating an Oracle Business Intelligence Module “Creating an Oracle Business Intelligence Module”
Defining Oracle Business Intelligence Location “Defining Oracle Business Intelligence Location”
About Logical Tables “About Logical Tables”
Editing a Logical Table “Editing a Logical Table”
Name Editor “Name Editor”
Source Items Editor “Source Items Editor” Adding Items Through the Source Items Editor “Adding Items Through the Source Items Editor” Deleting Items “Deleting Items”
Items Editor “Items Editor” Item Details “Item Details” Adding Items Through Items Editor “Adding Items Through Items Editor”
Joins Editor “Joins Editor” Properties of a Join “Properties of a Join”
Composition Editor “Composition Editor” Adding Items Through the Composition Editor “Adding Items Through the Composition Editor” Deleting Items “Deleting Items”
Creating a Logical Table “Creating a Logical Table”
Using the Create Logical Table Wizard “Using the Create Logical Table Wizard”
Naming and Describing the Logical Table “Naming and Describing the Logical Table”
Selecting Source Items “Selecting Source Items”
Selecting the Foreign Key “Selecting the Foreign Key”
Reviewing the Summary “Reviewing the Summary”
Using the Graphical Navigator to Create Logical Tables “Using the Graphical Navigator to Create Logical Tables” Using the Menu “Using the Menu” Using the Canvas “Using the Canvas” Steps to Create a Logical Table “Steps to Create a Logical Table” Adding Items to a Logical Table “Adding Items to a Logical Table” Properties of a Logical Table “Properties of a Logical Table”
Adding Joins Using the Graphical Navigator “Adding Joins Using the Graphical Navigator”
Synchronizing Logical Tables “Synchronizing Logical Tables”
Synchronize Logical Table Dialog Box “Synchronize Logical Table Dialog Box”
Creating a Dimension Drill Path “Creating a Dimension Drill Path”
Naming the Dimension Drill Path “Naming the Dimension Drill Path”
Specifying Drill Levels “Specifying Drill Levels”
Specifying the Drill Level Key “Specifying the Drill Level Key”
Reviewing the Summary “Reviewing the Summary”
Properties of a Dimensional Drill Path “Properties of a Dimensional Drill Path”
Editing a Dimension Drill Path “Editing a Dimension Drill Path”
Editing the Dimension Drill Path Name “Editing the Dimension Drill Path Name”
Reviewing the Drill Levels in the Dimension Drill Path “Reviewing the Drill Levels in the Dimension Drill Path”
Creating a Catalog Folder “Creating a Catalog Folder”
Using the Create Catalog Folder Wizard “Using the Create Catalog Folder Wizard”
Naming the Catalog Folder “Naming the Catalog Folder”
Selecting the Source “Selecting the Source”
Reviewing the Summary “Reviewing the Summary”
Using the Graphical Navigator “Using the Graphical Navigator” Using the Menu “Using the Menu” Using the Canvas “Using the Canvas”
Editing a Catalog Folder “Editing a Catalog Folder”
Name Editor “Name Editor”
Source Editor “Source Editor”
Contents Editor “Contents Editor”
Configuring Oracle Business Intelligence Objects “Configuring Oracle Business Intelligence Objects”
Configuration Parameters for Oracle Business Intelligence Modules “Configuration Parameters for Oracle Business Intelligence Modules”
Accessing BI Objects Using OBIEE “Accessing BI Objects Using OBIEE”
Merging Updated RPD Files “Merging Updated RPD Files” Example Scenario “Example Scenario”
Deriving BI Objects “Deriving BI Objects”
Selecting Source Objects “Selecting Source Objects”
Selecting a Target for the Derived Objects “Selecting a Target for the Derived Objects”
Specifying Derivation Rules “Specifying Derivation Rules” Setting Global Rules “Setting Global Rules”
Reviewing the Pre Derivation Rules “Reviewing the Pre Derivation Rules”
Reviewing Derivation Progress “Reviewing Derivation Progress”
Finishing the Derivation “Finishing the Derivation”
Importing Design Definitions from Third- Party Design Tools “Importing Design Definitions from Third- Party Design Tools”
Using Oracle Designer 6i/9i Sources “Using Oracle Designer 6i/9i Sources”
Using Designer 6i/9i as a Metadata Source “Using Designer 6i/9i as a Metadata Source”
Creating New Platforms “Creating New Platforms”
Creating a New Platform “Creating a New Platform”
Defining the Properties of a New Platform “Defining the Properties of a New Platform” Properties of a Platform “Properties of a Platform”
Defining the Platform Type “Defining the Platform Type” Properties of Data Type “Properties of Data Type”
Defining the Data Type Map “Defining the Data Type Map” Data Type Mapping Properties “Data Type Mapping Properties”
Generic Data Types Supported in Warehouse Builder “Generic Data Types Supported in Warehouse Builder” Generic Data Types “Generic Data Types”
DB2 Data Types Mapping “DB2 Data Types Mapping” DB2 Data Types to Generic Data Types “DB2 Data Types to Generic Data Types” Generic Data Types to DB2 Data Types “Generic Data Types to DB2 Data Types”
Informix Data Types Mapping “Informix Data Types Mapping” Informix Data Types to Generic Data Types “Informix Data Types to Generic Data Types” Generic Data Type to Informix Data Type “Generic Data Type to Informix Data Type”
MS SQL Server Data Types Mapping “MS SQL Server Data Types Mapping” MS SQL Server Data Types to Generic Data Types “MS SQL Server Data Types to Generic Data Types” Generic Data Types to MS SQL Server Data Types “Generic Data Types to MS SQL Server Data Types”
MySQL Data Types Mapping “MySQL Data Types Mapping” MySQL Data Types to Generic Data Types “MySQL Data Types to Generic Data Types” Generic Data Types to MySQL Data Types “Generic Data Types to MySQL Data Types”
Teradata Data Type Mapping “Teradata Data Type Mapping” Teradata Data Types to Generic Data Types “Teradata Data Types to Generic Data Types” Generic Data Type to Teradata Data Type “Generic Data Type to Teradata Data Type”
Creating Modules Based on a Platform “Creating Modules Based on a Platform” Providing a Name and Access Method “Providing a Name and Access Method” Providing Connection Information “Providing Connection Information”
Creating a Microsoft Excel Platform “Creating a Microsoft Excel Platform”
Importing an Excel Worksheet “Importing an Excel Worksheet”
Using Custom Metadata Import in Platforms “Using Custom Metadata Import in Platforms”
Implementing SQL-Based CMI Import for DB2 UDB “Implementing SQL-Based CMI Import for DB2 UDB” Platform Definition for IBM DB2 UDB “Platform Definition for IBM DB2 UDB” CMI Definition File “CMI Definition File”
Defining Other Platforms “Defining Other Platforms” JDBC Requirements for Different Platforms “JDBC Requirements for Different Platforms”
Using Code Templates to Load and Transfer Data “Using Code Templates to Load and Transfer Data”
Understanding Code Templates “Understanding Code Templates”
Load Code Template “Load Code Template”
Integration Code Template “Integration Code Template”
Control Code Template “Control Code Template”
Change Data Capture Code Template “Change Data Capture Code Template”
Oracle Target Code Template “Oracle Target Code Template”
Function Code Template “Function Code Template”
Predefined CTs “Predefined CTs”
Using Code Templates “Using Code Templates”
Creating a Code Template Folder “Creating a Code Template Folder”
Creating a Code Template “Creating a Code Template”
Importing a Code Template “Importing a Code Template”
Tasks in a Code Template “Tasks in a Code Template”
Implementing Code Templates “Implementing Code Templates”
Creating a Code Template Mapping “Creating a Code Template Mapping”
Specifying an Agent for the Code Template Mapping “Specifying an Agent for the Code Template Mapping”
Creating a Mapping Under the Code Template Mapping “Creating a Mapping Under the Code Template Mapping”
Using Code Templates in the Mapping “Using Code Templates in the Mapping”
Importing and Exporting Data as Web Services “Importing and Exporting Data as Web Services”
Defining Web Services “Defining Web Services”
Publishing Functionalities as Web Services “Publishing Functionalities as Web Services”
Creating an Application Server Module “Creating an Application Server Module”
Providing an Application Server Location “Providing an Application Server Location”
Creating a Web Service “Creating a Web Service”
Importing External Web Services “Importing External Web Services”