Home
/
Middleware
/
Oracle Data Integrator
1/15
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 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
Scripting on this page enhances content navigation, but does not change the content in any way.