Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview of Oracle Data Integrator SAP BW Knowledge Modules

• Overview

2 Setting Up the Environment

• Before You Begin
  • System Requirements and Certification
  • Getting the Right Privileges
  • Gathering SAP Connection Information
  • Requesting FTP Server Access
• Validating the Shared Folder Setup
• Validating the FTP Setup
• Validating SAP Privileges
• Validating SAP Transport Layer Name
• Installing Oracle Data Integrator
• Installing and Configuring the Oracle DB Target
• Installing and Configuring JCo
• Configuring Oracle Data Integrator
  • Add the Open Tool

3 Configuring the Topology

• Configuring the File Server for SAP ABAP
• Configuring the Target Data Server
• Configuring the SAP Source Server
  • Configuring the Data Server
  • Configuring the Logical Schema

4 Creating a New Project

• Creating a New Project

5 Reverse-Engineering Data Models

• Reverse-Engineering the Oracle Target
• Reverse-Engineering the SAP BW Source Datastores
  • Creating the Data Model
  • Validating the SAP Connection
  • Starting the Reverse-Engineering Process
  • Using the SAP Metadata Browser
    • The Tree View
    • The Search Panel
  • Reverse-Engineering Without GUI

6 Creating and Running the Mapping

• Creating the Mapping
  • Info Cube Extraction
    • Create the Mapping
    • Define the Source and Target Datastores
    • Create the Mappings
    • Define the Mapping Flow
  • Info Object Extraction
    • Create the Mapping
    • Define the Source and Target Datastores
    • Define Joins between Info Object's Main table and Text Table
    • Create the Mappings
    • Define the Mapping Flow
  • Info Object Hierarchy Extraction
    • Create the Mapping
    • Define the Source and Target Datastores
    • Create the Mappings
    • Define the Mapping Flow
  • Info Object Interval Hierarchy Extraction
    • Create the Mapping
    • Define the Source and Target Datastores
    • Define Joins between Sources (Info Object Main table and InfoObject Hierarchy Table)
    • Create the Mappings
    • Define the Mapping Flow
  • ODS/DSO Extraction
    • Create the Mapping
    • Define the Source and Target Datastores
    • Create the Mappings
    • Define the Mapping Flow
  • Info Cube & Related Info Object Extraction
    • Create the Mapping
    • Define the Source and Target Datastores
    • Define Joins between Sources (Info Cube & Object)
    • Create the Mappings
    • Define the Mapping Flow
  • Info Cube Extraction with Navigational Attributes
    • Create the Mapping
    • Define the Source and Target Datastores
    • Define Joins Between Sources (Info Cube & Info Object)
    • Create the Mappings
    • Define the Mapping Flow
  • Open Hub Extraction
    • Create the Mapping
    • Define the Source and Target Datastores
    • Create the Mappings
    • Define the Mapping Flow
• Running the Mapping
  • Running the Mapping
  • Review the Mapping Execution
  • Review the Resulting Data

7 Creating a Package for Delta Extraction

• Modify the Mapping Flow
• Creating the MIN_REQUEST_ID Variable
• Creating a Package for Delta Extraction
• Running the Package

8 Going Further with Oracle Data Integrator

• Going further with Oracle Data Integrator

A SAP ABAP BW Required Privileges

• Important points to consider
• Authorizations Required for RKM SAP BW Upload
• Authorizations Required for RKM SAP BW Execution
• Authorizations Required for LKM SAP BW Upload (Background mode)
• Authorizations Required for LKM SAP BW Execution (Background mode)
• Authorizations Required for LKM SAP BW Upload (Dialog mode)
• Authorizations Required for LKM SAP BW Execution (Dialog mode)

B SAP Stand-Alone Connection Test

• SAP Stand-Alone Connection Test

C Uninstalling ODI SAP Components

• Updating ODI SAP Components
• Uninstalling ODI SAP Components