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 an Interface
  • 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 EnterpriseOne

• 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 an Interface
  • 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 an Interface
  • 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 an Interface
  • 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 Gathering SAP Connection Information
    • 6.2.3.3 Gathering FTP Connection Information
  • 6.2.4 Getting the Right Privileges
• 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.6 Designing an Interface
• 6.7 Considerations for SAP BW Integration
  • 6.7.1 File Transfer Configurations
  • 6.7.2 Controlling ABAP Uploading
  • 6.7.3 Log Files
  • 6.7.4 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 Gathering SAP Connection Information
    • 7.2.3.3 Gathering FTP Connection Information
    • 7.2.3.4 Gathering Shared Directory Information
  • 7.2.4 Getting the Right Privileges
• 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 an Interface
• 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 Controlling ABAP Uploading
  • 7.7.3 Log Files
  • 7.7.4 Limitations of the SAP ABAP Adapter

A Additional Information for SAP ABAP BW Adapter

• A.1 SAP ABAP BW Required Privileges
  • A.1.1 Authorizations Required for RKM SAP BW Setup
  • A.1.2 Authorizations Required for RKM Execution
  • A.1.3 Authorizations Required for LKM Execution
  • A.1.4 Authorizations Required for LKM Execution for Production
• A.2 SAP Stand-Alone Connection Test
• A.3 SAP Stand-Alone Connection Test
• A.4 Uninstalling ODI SAP Components

B Additional Information for SAP ABAP ERP Adapter

• B.1 SAP ABAP ERP Required Privileges
  • B.1.1 Authorizations Required for RKM SAP ERP Setup
  • B.1.2 Authorizations Required for RKM Execution
  • B.1.3 Authorizations Required for LKM Execution
  • B.1.4 Authorizations Required for LKM Execution for Production
• B.2 SAP Connection Test
• B.3 SAP Stand-Alone Connection Test
• B.4 Uninstalling ODI SAP Components