Home / Middleware / Oracle Data Integrator

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