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
• 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
• Setting Up an FTP Server
• Configuring Oracle Data Integrator
  • Set Up the Topology
  • Add the Open Tool

3 Configuring the Topology

• 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 Integration Interface

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

7 Creating a Package for Delta Extraction

• Modify the Interface 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

• Authorizations Required for RKM SAP BW Setup
• Authorizations Required for RKM Execution
• Authorizations Required for LKM Execution
• Authorizations Required for LKM Execution for Production
• Privileges for Testing ODI Generated Extraction RFCs

B Installing the librfc32/librfc64 Library

• Installing the librfc32/librfc64 Library

C SAP Stand-Alone Connection Test

• SAP Stand-Alone Connection Test

D Uninstalling ODI SAP Components

• Uninstalling ODI SAP Components