Home
/
Middleware
/
Oracle Data Integrator
1/15
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction
1.1
Terminology
1.2
Using This Guide
2
Oracle E-Business Suite
2.1
Introduction
2.1.1
Concepts
2.1.2
Knowledge Modules
2.2
Installation and Configuration
2.2.1
System Requirements and Certifications
2.2.2
Technology Specific Requirements
2.2.3
Connectivity Requirements
2.3
Setting Up the Topology
2.3.1
Create an Oracle Data Server
2.3.2
Create an Oracle Physical Schema
2.4
Setting up an Integration Project
2.5
Creating an Oracle Model and Reverse-Engineering E-Business Suite Tables
2.5.1
Create an Oracle Model
2.5.2
Reverse-Engineer E-Business Suite Tables
2.6
Designing a Mapping
2.6.1
Loading Data from E-Business Suite
2.6.2
Integrating Data in E-Business Suite through the Open Interface
2.6.2.1
Managing Group IDs
2.6.2.2
Executing an Open Interface Program
3
JD Edwards World
3.1
Introduction
3.1.1
Concepts
3.1.2
Knowledge Modules
3.2
Installation and Configuration
3.2.1
System Requirements and Certifications
3.2.2
Technology Specific Requirements
3.2.3
Connectivity Requirements
3.3
Setting Up the Topology
3.3.1
Create a Data Server
3.3.2
Create a Physical Schema
3.4
Setting up an Integration Project
3.5
Creating and Reverse-Engineering a Model
3.5.1
Create a Model
3.5.2
Reverse-Engineer JDE Tables
3.6
Designing a Mapping
3.6.1
Loading Data from JDE
3.6.2
Integrating Data in JDE
4
Oracle PeopleSoft
4.1
Introduction
4.1.1
Concepts
4.1.2
Knowledge Modules
4.2
Installation and Configuration
4.2.1
System Requirements and Certifications
4.2.2
Technology Specific Requirements
4.2.3
Connectivity Requirements
4.3
Setting up the Topology
4.3.1
Create a Data Server
4.3.2
Create a Physical Schema
4.4
Setting up the Project
4.5
Creating and Reverse-Engineering a Model
4.5.1
Create a Model
4.5.2
Reverse-Engineer PeopleSoft Tables
4.6
Designing a Mapping
4.6.1
Loading Data from PeopleSoft
5
Oracle Siebel CRM
5.1
Introduction
5.1.1
Concepts
5.1.2
Overview of Extracting Data from Siebel
5.1.3
Knowledge Modules
5.2
Installation and Configuration
5.2.1
System Requirements and Certifications
5.2.2
Technology Specific Requirements
5.2.3
Connectivity Requirements
5.3
Setting up the Topology
5.3.1
Create a Data Server
5.3.2
Create a Physical Schema
5.4
Setting up the Project
5.5
Creating and Reverse-Engineering a Model
5.5.1
Create a Model
5.5.2
Reverse-Engineer Siebel CRM Tables
5.6
Designing a Mapping
5.6.1
Loading Data from Siebel
5.6.2
Loading Data from Siebel through EIM tables
5.6.3
Integrating Data in Siebel through EIM tables
6
SAP ABAP BW
6.1
Introduction
6.1.1
Concepts
6.1.2
Knowledge Modules
6.1.3
Overview of the SAP BW Integration Process
6.1.3.1
Reverse-Engineering Process
6.1.3.2
Integration Process
6.2
Installation and Configuration
6.2.1
System Requirements and Certifications
6.2.2
Technology Specific Requirements
6.2.3
Connectivity Requirements
6.2.3.1
Installing and Configuring JCo
6.2.3.2
Installing ODI SAP Components into SAP System
6.2.3.3
Validating the SAP Environment Setup
6.2.3.4
Gathering SAP Connection Information
6.2.3.5
Gathering FTP Connection Information
6.2.3.6
Gathering Shared Directory Information
6.2.4
Adding the Open Tool
6.3
Defining the Topology
6.3.1
Create the File Data Server
6.3.1.1
Create a File Data Server
6.3.1.2
Create the File Schema
6.3.2
Create the SAP ABAP Data Server
6.3.2.1
Create the SAP ABAP Data Server
6.3.2.2
Create the SAP ABAP Schema
6.4
Setting up the Project
6.5
Creating and Reverse-Engineering a Model
6.5.1
Creating a SAP BW Model
6.5.2
Reverse-Engineering a SAP BW Model
6.5.3
Reverse-Engineering a PSA Table in SAP BW Model
6.6
Designing a Mapping
6.7
Considerations for SAP BW Integration
6.7.1
File Transfer Configurations
6.7.1.1
Transfer using a Shared Directory (recommended)
6.7.1.2
FTP based Transfer
6.7.2
Execution Modes
6.7.3
Controlling ABAP Uploading / ABAP code in production
6.7.4
Managing ODI SAP Transport Requests
6.7.5
SAP Packages and SAP Function Groups
6.7.6
Log Files
6.7.7
Limitation of the SAP BW Adapter
7
SAP ABAP ERP
7.1
Introduction
7.1.1
Concepts
7.1.2
Knowledge Modules
7.1.3
Overview of the SAP ABAP Integration Process
7.1.3.1
Reverse-Engineering Process
7.1.3.2
Integration Process
7.2
Installation and Configuration
7.2.1
System Requirements and Certification
7.2.2
Technology Specific Requirements
7.2.3
Connectivity Requirements
7.2.3.1
Installing and Configuring JCo
7.2.3.2
Installing ODI SAP Components into SAP System
7.2.3.3
Validating the SAP Environment Setup
7.2.3.4
Gathering SAP Connection Information
7.2.3.5
Gathering FTP Connection Information
7.2.3.6
Gathering Shared Directory Information
7.2.4
Adding the Open Tool
7.3
Defining the Topology
7.3.1
Create the File Data Server
7.3.1.1
Create a File Data Server
7.3.1.2
Create the File Schema
7.3.2
Create the SAP ABAP Data Server
7.3.2.1
Create the SAP ABAP Data Server
7.3.2.2
Create the SAP ABAP Schema
7.4
Setting up the Project
7.5
Creating and Reverse-Engineering a Model
7.5.1
Creating a SAP ERP Model
7.5.2
Reverse-Engineering a SAP ERP Model
7.6
Designing a Mapping
7.7
Considerations for SAP ERP Integration
7.7.1
File Transfer Configurations
7.7.1.1
Transfer using a Shared Directory (recommended)
7.7.1.2
FTP based Transfer
7.7.2
Execution Modes
7.7.3
Controlling ABAP Uploading / ABAP code in production
7.7.4
Managing ODI SAP Transport Requests
7.7.5
SAP Packages and SAP Function Groups
7.7.6
Log Files
7.7.7
Limitations of the SAP ABAP Adapter
A
Additional Information for SAP ABAP BW Adapter
A.1
SAP ABAP BW Required Privileges
A.1.1
Important points to consider
A.1.2
Authorizations Required for RKM SAP BW Setup
A.1.3
Authorizations Required for RKM SAP BW Execution
A.1.4
Authorizations Required for LKM SAP BW Execution
A.1.5
Authorizations Required for LKM SAP BW Execution in Production
A.1.6
Authorizations Required for LKM SAP BW Execution as Background Process
A.1.7
Authorizations Required for LKM SAP BW Execution as Background Process in Production
A.2
SAP Stand-Alone Connection Test
A.2.1
SAP Stand-Alone Connection Test
B
Additional Information for SAP ABAP ERP Adapter
B.1
SAP ABAP ERP Required Privileges
B.1.1
Important points to consider
B.1.2
Authorizations Required for RKM SAP ERP Setup
B.1.3
Authorizations Required for RKM SAP ERP Execution
B.1.4
Authorizations Required for LKM SAP ERP Execution
B.1.5
Authorizations Required for LKM SAP ERP Execution in Production
B.1.6
Authorizations Required for LKM SAP ERP Execution as Background Process
B.1.7
Authorizations Required for LKM SAP ERP Execution as Background Process in Production
B.2
SAP Connection Test
B.3
SAP Stand-Alone Connection Test
C
Components, Compatibility, and Upgrading of the ODI SAP Adapter
C.1
Components
C.2
Compatibility
C.3
Upgrading
C.3.1
Method 1: Add as new KMs
C.3.2
Replace existing KMs
D
Installing ODI SAP Components
D.1
Updating ODI SAP Components
D.2
Installing ODI SAP Components
D.2.1
Installing SAP Transport Request (TR)
D.2.1.1
Downloading the Transport Request files
D.2.1.2
Installing the Transport Request Files
D.2.1.3
Creating Transport Request for ODI SAP Production Objects
D.2.1.4
Creating Transport Request for ODI SAP Development Objects
D.2.2
Installing and Assigning SAP User Profile
D.3
Validating the ODI SAP Setup
D.3.1
Validating the Shared Folder Setup
D.3.2
Validating the FTP Setup
D.3.3
Validating SAP Privileges
D.3.4
Validating SAP Transport Layer Name
D.4
Uninstalling ODI SAP Components
D.4.1
Validating Uninstallation of ODI SAP Components
E
Moving ODI and SAP Components from Development to Production
E.1
Transport Request (TR)
E.1.1
Viewing the List of TRs
E.1.1.1
Description of TR Fields
E.1.2
Transport Request (TR) relevant to DEV
E.1.3
Transport Request (TR) relevant to PROD
E.2
Remote Function Call (RFC)
E.3
Adding Mappings Under Same Transport Request
E.3.1
KM Options Descriptions
E.4
Creating ODI Package
E.5
Generating ODI Scenario
E.6
Moving ODI Scenario to production repository (optional)
E.7
Releasing ODI SAP Components TR into Production
E.7.1
Transports are created after TR import
E.7.2
Transports are created using RKM process
E.8
Releasing the ODI Mapping TR into Production
E.9
Executing the ODI Scenario
Scripting on this page enhances content navigation, but does not change the content in any way.