Go to main content
1/16
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
Scripting on this page enhances content navigation, but does not change the content in any way.