Home
/
Middleware
/
Oracle Data Integrator
1/10
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
SAP ABAP BW
4.1
Introduction
4.1.1
Concepts
4.1.2
Knowledge Modules
4.1.3
Overview of the SAP BW Integration Process
4.1.3.1
Reverse-Engineering Process
4.1.3.2
Integration Process
4.2
Installation and Configuration
4.2.1
System Requirements and Certifications
4.2.2
Technology Specific Requirements
4.2.3
Connectivity Requirements
4.2.3.1
Installing and Configuring JCo
4.2.3.2
Gathering SAP Connection Information
4.2.3.3
Gathering FTP Connection Information
4.2.3.4
Gathering Shared Directory Information
4.2.4
Getting the Right Privileges
4.2.5
Adding the Open Tool
4.3
Defining the Topology
4.3.1
Create the File Data Server
4.3.1.1
Create a File Data Server
4.3.1.2
Create the File Schema
4.3.2
Create the SAP ABAP Data Server
4.3.2.1
Create the SAP ABAP Data Server
4.3.2.2
Create the SAP ABAP Schema
4.4
Setting up the Project
4.5
Creating and Reverse-Engineering a Model
4.5.1
Creating a SAP BW Model
4.5.2
Reverse-Engineering a SAP BW Model
4.6
Designing a Mapping
4.7
Considerations for SAP BW Integration
4.7.1
File Transfer Configurations
4.7.1.1
Transfer using a Shared Directory (recommended)
4.7.1.2
FTP based Transfer
4.7.2
Execution Modes
4.7.3
Controlling ABAP Uploading / ABAP code in production
4.7.4
Managing ODI SAP Transport Requests
4.7.5
SAP Packages and SAP Function Groups
4.7.6
Log Files
4.7.7
Limitation of the SAP BW Adapter
5
SAP ABAP ERP
5.1
Introduction
5.1.1
Concepts
5.1.2
Knowledge Modules
5.1.3
Overview of the SAP ABAP Integration Process
5.1.3.1
Reverse-Engineering Process
5.1.3.2
Integration Process
5.2
Installation and Configuration
5.2.1
System Requirements and Certification
5.2.2
Technology Specific Requirements
5.2.3
Connectivity Requirements
5.2.3.1
Installing and Configuring JCo
5.2.3.2
Gathering SAP Connection Information
5.2.3.3
Gathering FTP Connection Information
5.2.3.4
Gathering Shared Directory Information
5.2.4
Getting the Right Privileges
5.2.5
Adding the Open Tool
5.3
Defining the Topology
5.3.1
Create the File Data Server
5.3.1.1
Create a File Data Server
5.3.1.2
Create the File Schema
5.3.2
Create the SAP ABAP Data Server
5.3.2.1
Create the SAP ABAP Data Server
5.3.2.2
Create the SAP ABAP Schema
5.4
Setting up the Project
5.5
Creating and Reverse-Engineering a Model
5.5.1
Creating a SAP ERP Model
5.5.2
Reverse-Engineering a SAP ERP Model
5.6
Designing a Mapping
5.7
Considerations for SAP ERP Integration
5.7.1
File Transfer Configurations
5.7.1.1
Transfer using a Shared Directory (recommended)
5.7.1.2
FTP based Transfer
5.7.2
Execution Modes
5.7.3
Controlling ABAP Uploading
5.7.4
Managing ODI SAP Transport Requests
5.7.5
SAP Packages and SAP Function Groups
5.7.6
Log Files
5.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 Upload
A.1.3
Authorizations Required for RKM SAP BW Execution
A.1.4
Authorizations Required for LKM SAP BW Upload (Background mode)
A.1.5
Authorizations Required for LKM SAP BW Execution (Background mode)
A.1.6
Authorizations Required for LKM SAP BW Upload (Dialog mode)
A.1.7
Authorizations Required for LKM SAP BW Execution (Dialog mode)
A.2
SAP Stand-Alone Connection Test
A.2.1
SAP Stand-Alone Connection Test
A.3
Updating ODI SAP Components
A.4
Uninstalling ODI SAP Components
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 Upload
B.1.3
Authorizations Required for RKM SAP ERP Execution
B.1.4
Authorizations Required for LKM SAP ERP Upload (Background mode)
B.1.5
Authorizations Required for LKM SAP ERP Execution (Background mode)
B.1.6
Authorizations Required for LKM SAP ERP Upload (Dialog mode)
B.1.7
Authorizations Required for LKM SAP ERP Execution (Dialog mode)
B.2
SAP Connection Test
B.3
SAP Stand-Alone Connection Test
B.4
Updating ODI SAP Components
B.5
Uninstalling ODI SAP Components
Scripting on this page enhances content navigation, but does not change the content in any way.