Home / Middleware / Oracle Data Integrator

Contents

Expand All · Collapse All

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