Go to main content
1/16
Contents
List of Examples
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Overview of Oracle Data Integrator SAP BW Knowledge Modules
1.1
Overview
2
Setting Up the Environment
2.1
Before You Begin
2.1.1
System Requirements and Certification
2.1.2
Requesting ODI SAP Component Installation into the SAP System
2.1.3
Requesting FTP Server Access
2.1.4
Gathering SAP Connection Information
2.2
Validating the Shared Folder Setup
2.3
Validating the FTP Setup
2.4
Validating SAP Privileges
2.5
Validating SAP Transport Layer Name
2.6
Installing Oracle Data Integrator
2.7
Installing and Configuring the Oracle DB Target
2.8
Installing and Configuring JCo
2.9
Configuring Oracle Data Integrator
2.9.1
Add the Open Tool
3
Configuring the Topology
3.1
Configuring the File Server for SAP ABAP
3.2
Configuring the Target Data Server
3.3
Configuring the SAP Source Server
3.3.1
Configuring the Data Server
3.3.2
Configuring the Logical Schema
4
Creating a New Project
4.1
Creating a New Project
5
Reverse-Engineering Data Models
5.1
Reverse-Engineering the Oracle Target
5.2
Reverse-Engineering the SAP BW Source Datastores
5.2.1
Creating the Data Model
5.2.2
Validating the SAP Connection
5.2.3
Starting the Reverse-Engineering Process
5.2.4
Using the SAP Metadata Browser
5.2.4.1
The Tree View
5.2.4.2
The Search Panel
5.2.5
Reverse-Engineering Without GUI
6
Creating and Running the Mapping
6.1
Creating the Mapping
6.1.1
Info Cube Extraction
6.1.1.1
Create the Mapping
6.1.1.2
Define the Source and Target Datastores
6.1.1.3
Create the Mappings
6.1.1.4
Define the Mapping Flow
6.1.2
Info Object Extraction
6.1.2.1
Create the Mapping
6.1.2.2
Define the Source and Target Datastores
6.1.2.3
Define Joins between Info Object's Main table and Text Table
6.1.2.4
Create the Mappings
6.1.2.5
Define the Mapping Flow
6.1.3
Info Object Hierarchy Extraction
6.1.3.1
Create the Mapping
6.1.3.2
Define the Source and Target Datastores
6.1.3.3
Create the Mappings
6.1.3.4
Define the Mapping Flow
6.1.4
Info Object Interval Hierarchy Extraction
6.1.4.1
Create the Mapping
6.1.4.2
Define the Source and Target Datastores
6.1.4.3
Define Joins between Sources (Info Object Main table and InfoObject Hierarchy Table)
6.1.4.4
Create the Mappings
6.1.4.5
Define the Mapping Flow
6.1.5
ODS/DSO Extraction
6.1.5.1
Create the Mapping
6.1.5.2
Define the Source and Target Datastores
6.1.5.3
Create the Mappings
6.1.5.4
Define the Mapping Flow
6.1.6
Info Cube & Related Info Object Extraction
6.1.6.1
Create the Mapping
6.1.6.2
Define the Source and Target Datastores
6.1.6.3
Define Joins between Sources (Info Cube & Object)
6.1.6.4
Create the Mappings
6.1.6.5
Define the Mapping Flow
6.1.7
Info Cube Extraction with Navigational Attributes
6.1.7.1
Create the Mapping
6.1.7.2
Define the Source and Target Datastores
6.1.7.3
Define Joins Between Sources (Info Cube & Info Object)
6.1.7.4
Create the Mappings
6.1.7.5
Define the Mapping Flow
6.1.8
Open Hub Extraction
6.1.8.1
Create the Mapping
6.1.8.2
Define the Source and Target Datastores
6.1.8.3
Create the Mappings
6.1.8.4
Define the Mapping Flow
6.2
Running the Mapping
6.2.1
Running the Mapping
6.2.2
Review the Mapping Execution
6.2.3
Review the Resulting Data
7
Creating a Package for Delta Extraction
7.1
Modify the Mapping Flow
7.2
Creating the MIN_REQUEST_ID Variable
7.3
Creating a Package for Delta Extraction
7.4
Running the Package
8
Going Further with Oracle Data Integrator
8.1
Going further with Oracle Data Integrator
A
SAP ABAP BW Required Privileges
A.1
Important points to consider
A.2
Authorizations Required for RKM SAP BW Upload
A.3
Authorizations Required for RKM SAP BW Execution
A.4
Authorizations Required for LKM SAP BW Upload (Background mode)
A.5
Authorizations Required for LKM SAP BW Execution (Background mode)
A.6
Authorizations Required for LKM SAP BW Upload (Dialog mode)
A.7
Authorizations Required for LKM SAP BW Execution (Dialog mode)
B
SAP Stand-Alone Connection Test
B.1
SAP Stand-Alone Connection Test
Scripting on this page enhances content navigation, but does not change the content in any way.