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

Part I Databases, Files, and XML

2 Oracle Database

• 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.2.1 Using the SQL*Loader Utility
    • 2.2.2.2 Using External Tables
    • 2.2.2.3 Using Oracle Streams
  • 2.2.3 Connectivity Requirements
• 2.3 Setting up the Topology
  • 2.3.1 Creating an Oracle Data Server
    • 2.3.1.1 Creation of the Data Server
  • 2.3.2 Creating an Oracle Physical Schema
• 2.4 Setting Up an Integration Project
• 2.5 Creating and Reverse-Engineering an Oracle Model
  • 2.5.1 Create an Oracle Model
  • 2.5.2 Reverse-engineer an Oracle Model
• 2.6 Setting up Changed Data Capture
• 2.7 Setting up Data Quality
• 2.8 Designing an Interface
  • 2.8.1 Loading Data from and to Oracle
    • 2.8.1.1 Loading Data from Oracle
    • 2.8.1.2 Loading Data to Oracle
  • 2.8.2 Integrating Data in Oracle
  • 2.8.3 Designing an ETL-Style Interface
• 2.9 Troubleshooting
  • 2.9.1 Troubleshooting Oracle Database Errors
  • 2.9.2 Common Problems and Solutions

3 Files

• 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 Creating a File Data Server
    • 3.3.1.1 Creation of the Data Server
  • 3.3.2 Creating a File Physical Schema
• 3.4 Setting Up an Integration Project
• 3.5 Creating and Reverse-Engineering a File Model
  • 3.5.1 Create a File Model
  • 3.5.2 Reverse-engineer a File Model
    • 3.5.2.1 Delimited Files Reverse-Engineering
    • 3.5.2.2 Fixed Files Reverse-engineering using the Wizard
    • 3.5.2.3 COBOL Copybook reverse-engineering
    • 3.5.2.4 Customized Reverse-Engineering
• 3.6 Designing an Interface
  • 3.6.1 Loading Data From Files
  • 3.6.2 Integrating Data in Files

4 Generic SQL

• 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 Creating a Data Server
  • 4.3.2 Creating a Physical Schema
• 4.4 Setting up an Integration Project
• 4.5 Creating and Reverse-Engineering a Model
  • 4.5.1 Create a Data Model
  • 4.5.2 Reverse-engineer a Data Model
• 4.6 Setting up Changed Data Capture
• 4.7 Setting up Data Quality
• 4.8 Designing an Interface
  • 4.8.1 Loading Data From and to an ANSI SQL-92 Compliant Technology
    • 4.8.1.1 Loading Data from an ANSI SQL-92 Compliant Technology
    • 4.8.1.2 Loading Data to an ANSI SQL-92 Compliant Technology
  • 4.8.2 Integrating Data in an ANSI SQL-92 Compliant Technology
  • 4.8.3 Designing an ETL-Style Interface

5 XML Files

• 5.1 Introduction
  • 5.1.1 Concepts
  • 5.1.2 Knowledge Modules
• 5.2 Installation and Configuration
  • 5.2.1 System Requirements
  • 5.2.2 Technologic Specific Requirements
  • 5.2.3 Connectivity Requirements
• 5.3 Setting up the Topology
  • 5.3.1 Creating an XML Data Server
    • 5.3.1.1 Creation of the Data Server
  • 5.3.2 Creating a Physical Schema for XML
• 5.4 Setting Up an Integration Project
• 5.5 Creating and Reverse-Engineering a XML File
  • 5.5.1 Create an XML Model
  • 5.5.2 Reverse-Engineering an XML Model
• 5.6 Designing an Interface
  • 5.6.1 Notes about XML Interfaces
    • 5.6.1.1 Targeting an XML Structure
    • 5.6.1.2 Synchronizing XML File and Schema
    • 5.6.1.3 Handling Large XML Files
  • 5.6.2 Loading Data from and to XML
    • 5.6.2.1 Loading Data from an XML Schema
    • 5.6.2.2 Loading Data to an XML Schema
  • 5.6.3 Integrating Data in XML
• 5.7 Troubleshooting
  • 5.7.1 Detect the Errors Coming from XML
  • 5.7.2 Common Errors

6 Microsoft SQL Server

• 6.1 Introduction
  • 6.1.1 Concepts
  • 6.1.2 Knowledge Modules
• 6.2 Installation and Configuration
  • 6.2.1 System Requirements and Certifications
  • 6.2.2 Technology Specific Requirements
    • 6.2.2.1 Using the BULK INSERT Command
    • 6.2.2.2 Using the BCP Command
    • 6.2.2.3 Using Linked Servers
  • 6.2.3 Connectivity Requirements
• 6.3 Setting up the Topology
  • 6.3.1 Creating a Microsoft SQL Server Data Server
    • 6.3.1.1 Creation of the Data Server
  • 6.3.2 Creating a Microsoft SQL Server Physical Schema
• 6.4 Setting Up an Integration Project
• 6.5 Creating and Reverse-Engineering a Microsoft SQL Server Model
  • 6.5.1 Create a Microsoft SQL Server Model
  • 6.5.2 Reverse-engineer a Microsoft SQL Server Model
• 6.6 Setting up Changed Data Capture
• 6.7 Setting up Data Quality
• 6.8 Designing an Interface
  • 6.8.1 Loading Data from and to Microsoft SQL Server
    • 6.8.1.1 Loading Data from Microsoft SQL Server
    • 6.8.1.2 Loading Data to Microsoft SQL Server
  • 6.8.2 Integrating Data in Microsoft SQL Server

7 Microsoft Excel

• 7.1 Introduction
  • 7.1.1 Concepts
  • 7.1.2 Knowledge Modules
• 7.2 Installation and Configuration
  • 7.2.1 System Requirements and Certifications
  • 7.2.2 Technology Specific Requirements
  • 7.2.3 Connectivity Requirements
• 7.3 Setting up the Topology
  • 7.3.1 Creating a Microsoft Excel Data Server
  • 7.3.2 Creating a Microsoft Excel Physical Schema
• 7.4 Setting Up an Integration Project
• 7.5 Creating and Reverse-Engineering a Microsoft Excel Model
  • 7.5.1 Create a Microsoft Excel Model
  • 7.5.2 Reverse-engineer a Microsoft Excel Model
• 7.6 Designing an Interface
  • 7.6.1 Loading Data From and to Microsoft Excel
    • 7.6.1.1 Loading Data from Microsoft Excel
    • 7.6.1.2 Loading Data to Microsoft Excel
  • 7.6.2 Integrating Data in Microsoft Excel
• 7.7 Troubleshooting
  • 7.7.1 Decoding Error Messages
  • 7.7.2 Common Problems and Solutions

8 Microsoft Access

• 8.1 Introduction
• 8.2 Concepts
• 8.3 Knowledge Modules
• 8.4 Specific Requirements

9 Netezza

• 9.1 Introduction
  • 9.1.1 Concepts
  • 9.1.2 Knowledge Modules
• 9.2 Installation and Configuration
  • 9.2.1 System Requirements and Certifications
  • 9.2.2 Technology Specific Requirements
  • 9.2.3 Connectivity Requirements
• 9.3 Setting up the Topology
  • 9.3.1 Creating a Netezza Data Server
    • 9.3.1.1 Creation of the Data Server
  • 9.3.2 Creating a Netezza Physical Schema
• 9.4 Setting Up an Integration Project
• 9.5 Creating and Reverse-Engineering a Netezza Model
  • 9.5.1 Create a Netezza Model
  • 9.5.2 Reverse-engineer a Netezza Model
• 9.6 Setting up Data Quality
• 9.7 Designing an Interface
  • 9.7.1 Loading Data from and to Netezza
    • 9.7.1.1 Loading Data from Netezza
    • 9.7.1.2 Loading Data to Netezza
  • 9.7.2 Integrating Data in Netezza

10 Teradata

• 10.1 Introduction
  • 10.1.1 Concepts
  • 10.1.2 Knowledge Modules
• 10.2 Installation and Configuration
  • 10.2.1 System Requirements and Certifications
  • 10.2.2 Technology Specific Requirements
  • 10.2.3 Connectivity Requirements
• 10.3 Setting up the Topology
  • 10.3.1 Creating a Teradata Data Server
    • 10.3.1.1 Creation of the Data Server
  • 10.3.2 Creating a Teradata Physical Schema
• 10.4 Setting Up an Integration Project
• 10.5 Creating and Reverse-Engineering a Teradata Model
  • 10.5.1 Create a Teradata Model
  • 10.5.2 Reverse-engineer a Teradata Model
• 10.6 Setting up Data Quality
• 10.7 Designing an Interface
  • 10.7.1 Loading Data from and to Teradata
    • 10.7.1.1 Loading Data from Teradata
    • 10.7.1.2 Loading Data to Teradata
  • 10.7.2 Integrating Data in Teradata
  • 10.7.3 Designing an ETL-Style Interface
• 10.8 KM Optimizations for Teradata
  • 10.8.1 Primary Indexes and Statistics
  • 10.8.2 Support for Teradata Utilities
  • 10.8.3 Support for Named Pipes
  • 10.8.4 Optimized Management of Temporary Tables

11 Hypersonic SQL

• 11.1 Introduction
  • 11.1.1 Concepts
  • 11.1.2 Knowledge Modules
• 11.2 Installation and Configuration
  • 11.2.1 System Requirements and Certifications
  • 11.2.2 Technology Specific Requirements
  • 11.2.3 Connectivity Requirements
• 11.3 Setting up the Topology
  • 11.3.1 Creating a Hypersonic SQL Data Server
  • 11.3.2 Creating a Hypersonic SQL Physical Schema
• 11.4 Setting Up an Integration Project
• 11.5 Creating and Reverse-Engineering a Hypersonic SQL Model
  • 11.5.1 Create a Hypersonic SQL Model
  • 11.5.2 Reverse-engineer a Hypersonic SQL Model
• 11.6 Setting up Changed Data Capture
• 11.7 Setting up Data Quality
• 11.8 Designing an Interface

12 IBM Informix

• 12.1 Introduction
• 12.2 Concepts
• 12.3 Knowledge Modules
• 12.4 Specific Requirements

13 IBM DB2 for iSeries

• 13.1 Introduction
  • 13.1.1 Concepts
  • 13.1.2 Knowledge Modules
• 13.2 Installation and Configuration
  • 13.2.1 System Requirements and Certifications
  • 13.2.2 Technology Specific Requirements
  • 13.2.3 Connectivity Requirements
• 13.3 Setting up the Topology
  • 13.3.1 Creating a DB2/400 Data Server
    • 13.3.1.1 Creation of the Data Server
  • 13.3.2 Creating a DB2/400 Physical Schema
• 13.4 Setting Up an Integration Project
• 13.5 Creating and Reverse-Engineering an IBM DB2/400 Model
  • 13.5.1 Create an IBM DB2/400 Model
  • 13.5.2 Reverse-engineer an IBM DB2/400 Model
• 13.6 Setting up Changed Data Capture
  • 13.6.1 Setting up Trigger-Based CDC
  • 13.6.2 Setting up Log-Based CDC
    • 13.6.2.1 How does it work?
    • 13.6.2.2 CDCRTVJRN Program Details
    • 13.6.2.3 Installing the CDC Components on iSeries
    • 13.6.2.4 Using the CDC with the Native Journals
    • 13.6.2.5 Problems While Reading Journals
• 13.7 Setting up Data Quality
• 13.8 Designing an Interface
  • 13.8.1 Loading Data from and to IBM DB2 for iSeries
    • 13.8.1.1 Loading Data from IBM DB2 for iSeries
    • 13.8.1.2 Loading Data to IBM DB2 for iSeries
  • 13.8.2 Integrating Data in IBM DB2 for iSeries
• 13.9 Specific Considerations with DB2 for iSeries
  • 13.9.1 Installing the Run-Time Agent on iSeries
  • 13.9.2 Alternative Connectivity Methods for iSeries
    • 13.9.2.1 Using Client Access
    • 13.9.2.2 Using the IBM JT/400 and Native Drivers
• 13.10 Troubleshooting
  • 13.10.1 Troubleshooting Error messages
  • 13.10.2 Common Problems and Solutions
    • 13.10.2.1 Connection Errors

14 IBM DB2 UDB

• 14.1 Introduction
• 14.2 Concepts
• 14.3 Knowledge Modules
• 14.4 Specific Requirements

15 Sybase AS Enterprise

• 15.1 Introduction
• 15.2 Concepts
• 15.3 Knowledge Modules
• 15.4 Specific Requirements

16 Sybase IQ

• 16.1 Introduction
• 16.2 Concepts
• 16.3 Knowledge Modules
• 16.4 Specific Requirements

Part II Business Intelligence

17 Oracle Business Intelligence Enterprise Edition

• 17.1 Introduction
  • 17.1.1 Concepts
  • 17.1.2 Knowledge Modules
• 17.2 Installation and Configuration
  • 17.2.1 System Requirements and Certifications
  • 17.2.2 Technology Specific Requirements
  • 17.2.3 Connectivity Requirements
• 17.3 Setting up the Topology
  • 17.3.1 Creating an Oracle BI Data Server
    • 17.3.1.1 Creation of the Data Server
  • 17.3.2 Creating an Oracle BI Physical Schema
• 17.4 Setting Up an Integration Project
• 17.5 Creating and Reverse-Engineering an Oracle BI Model
  • 17.5.1 Create an Oracle BI Model
  • 17.5.2 Reverse-engineer an Oracle BI Model
• 17.6 Setting up Data Quality
• 17.7 Designing an Interface
  • 17.7.1 Loading Data from and to Oracle BI
    • 17.7.1.1 Loading Data from Oracle BI
    • 17.7.1.2 Loading Data to Oracle BI
  • 17.7.2 Integrating Data in Oracle BI

18 Oracle Hyperion Essbase

• 18.1 Introduction
  • 18.1.1 Integration Process
  • 18.1.2 Knowledge Modules
• 18.2 Installation and Configuration
  • 18.2.1 System Requirements and Certifications
  • 18.2.2 Technology Specific Requirements
  • 18.2.3 Connectivity Requirements
• 18.3 Setting up the Topology
  • 18.3.1 Creating an Hyperion Essbase Data Server
  • 18.3.2 Creating an Hyperion Essbase Physical Schema
• 18.4 Creating and Reverse-Engineering an Essbase Model
  • 18.4.1 Create an Essbase Model
  • 18.4.2 Reverse-engineer an Essbase Model
• 18.5 Designing an Interface
  • 18.5.1 Loading Metadata
  • 18.5.2 Loading Data
  • 18.5.3 Extracting Data
    • 18.5.3.1 Data Extraction Methods for Essbase
    • 18.5.3.2 Extracting Essbase Data
    • 18.5.3.3 Extracting Members from Metadata

19 Oracle Hyperion Financial Management

• 19.1 Introduction
  • 19.1.1 Integration Process
  • 19.1.2 Knowledge Modules
• 19.2 Installation and Configuration
  • 19.2.1 System Requirements and Certifications
  • 19.2.2 Technology Specific Requirements
  • 19.2.3 Connectivity Requirements
• 19.3 Setting up the Topology
  • 19.3.1 Creating an Hyperion Financial Management Data Server
  • 19.3.2 Creating an Hyperion Financial Management Physical Schema
• 19.4 Creating and Reverse-Engineering a Financial Management Model
  • 19.4.1 Create an Financial Management Model
  • 19.4.2 Reverse-Engineer an Financial Management Model
• 19.5 Designing an Interface
  • 19.5.1 Loading Metadata
  • 19.5.2 Loading Data
  • 19.5.3 Extracting Data
    • 19.5.3.1 Extracting Financial Management Data
    • 19.5.3.2 Extracting Members from Member Lists
• 19.6 Data Store Tables

20 Oracle Hyperion Planning

• 20.1 Introduction
  • 20.1.1 Integration Process
  • 20.1.2 Knowledge Modules
• 20.2 Installation and Configuration
  • 20.2.1 System Requirements and Certifications
  • 20.2.2 Technology Specific Requirements
  • 20.2.3 Connectivity Requirements
• 20.3 Setting up the Topology
  • 20.3.1 Creating an Hyperion Planning Data Server
  • 20.3.2 Creating an Hyperion Planning Physical Schema
• 20.4 Creating and Reverse-Engineering a Planning Model
  • 20.4.1 Create a Planning Model
  • 20.4.2 Reverse-engineer a Planning Model
• 20.5 Designing an Interface
  • 20.5.1 Loading Metadata
  • 20.5.2 Loading Data
  • 20.5.3 Load Options
• 20.6 Datastore Tables and Data Load Columns
  • 20.6.1 Accounts
  • 20.6.2 Employee
  • 20.6.3 Entities
  • 20.6.4 User-Defined Dimensions
  • 20.6.5 Attribute Dimensions
  • 20.6.6 UDA
  • 20.6.7 Data Load Columns

21 Oracle OLAP

• 21.1 Introduction
  • 21.1.1 Concepts
  • 21.1.2 Knowledge Modules
• 21.2 Installation and Configuration
  • 21.2.1 System Requirements and Certifications
  • 21.2.2 Technology Specific Requirements
  • 21.2.3 Connectivity Requirements
• 21.3 Setting up the Topology
  • 21.3.1 Creating an Oracle Data Server
    • 21.3.1.1 Creation of the Data Server
  • 21.3.2 Creating an Oracle Physical Schema
• 21.4 Setting Up an Integration Project
• 21.5 Creating and Reverse-Engineering an Oracle Model
  • 21.5.1 Create an Oracle Model
  • 21.5.2 Reverse-engineer an Oracle OLAP Cube
• 21.6 Working with Oracle OLAP KMs in Integration Interfaces
  • 21.6.1 Using Oracle OLAP as a Source in an Integration Interface
  • 21.6.2 Using Oracle ROLAP as a Target in an Integration Interface
  • 21.6.3 Using Oracle MOLAP as a Target in an Integration Interface

Part III Other Technologies

22 JMS

• 22.1 Introduction
  • 22.1.1 Concepts
    • 22.1.1.1 JMS Message Structure
    • 22.1.1.2 Using a JMS Destination
  • 22.1.2 Knowledge Modules
• 22.2 Installation and Configuration
  • 22.2.1 System Requirements and Certifications
  • 22.2.2 Technology Specific Requirements
  • 22.2.3 Connectivity Requirements
• 22.3 Setting up the Topology
  • 22.3.1 Creating a JMS Data Server
    • 22.3.1.1 Creation of the Data Server
  • 22.3.2 Creating a JMS Physical Schema
• 22.4 Setting Up an Integration Project
• 22.5 Creating and Defining a JMS Model
  • 22.5.1 Create a JMS Model
  • 22.5.2 Defining the JMS Datastores
• 22.6 Designing an Interface
  • 22.6.1 Loading Data from a JMS Source
  • 22.6.2 Integrating Data in a JMS Target
• 22.7 JMS Standard Properties
  • 22.7.1 Using JMS Properties
    • 22.7.1.1 Declaring JMS Properties
    • 22.7.1.2 Filtering on the Router
    • 22.7.1.3 Filtering on the Client
    • 22.7.1.4 Using Property Values as Source Data
    • 22.7.1.5 Setting Properties when Sending a Message

23 JMS XML

• 23.1 Introduction
  • 23.1.1 Concepts
    • 23.1.1.1 JMS Message Structure
    • 23.1.1.2 Using a JMS Destination
  • 23.1.2 Knowledge Modules
• 23.2 Installation and Configuration
  • 23.2.1 System Requirements and Certifications
  • 23.2.2 Technology Specific Requirements
  • 23.2.3 Connectivity Requirements
• 23.3 Setting up the Topology
  • 23.3.1 Creating a JMS XML Data Server
    • 23.3.1.1 Creation of the Data Server
  • 23.3.2 Creating a JMS XML Physical Schema
• 23.4 Setting Up an Integration Project
• 23.5 Creating and Reverse-Engineering a JMS XML Model
  • 23.5.1 Create a JMS XML Model
  • 23.5.2 Reverse-Engineering a JMS XML Model
• 23.6 Designing an Interface
  • 23.6.1 Loading Data from a JMS XML Source
  • 23.6.2 Integrating Data in a JMS XML Target

24 LDAP Directories

• 24.1 Introduction
  • 24.1.1 Concepts
  • 24.1.2 Knowledge Modules
• 24.2 Installation and Configuration
  • 24.2.1 System Requirements
  • 24.2.2 Technologic Specific Requirements
  • 24.2.3 Connectivity Requirements
• 24.3 Setting up the Topology
  • 24.3.1 Creating an LDAP Data Server
    • 24.3.1.1 Creation of the Data Server
  • 24.3.2 Creating a Physical Schema for LDAP
• 24.4 Setting Up an Integration Project
• 24.5 Creating and Reverse-Engineering an LDAP Directory
  • 24.5.1 Create an LDAP Model
  • 24.5.2 Reverse-Engineering an LDAP Model
• 24.6 Designing an Interface
  • 24.6.1 Loading Data from and to LDAP
    • 24.6.1.1 Loading Data from an LDAP Directory
    • 24.6.1.2 Loading Data to an LDAP Directory
  • 24.6.2 Integrating Data in an LDAP Directory
• 24.7 Troubleshooting

25 Oracle Changed Data Capture Adapters

• 25.1 Introduction
  • 25.1.1 Concepts
  • 25.1.2 Knowledge Modules
• 25.2 Installation and Configuration
  • 25.2.1 System Requirements
  • 25.2.2 Technology Specific Requirements
  • 25.2.3 Connectivity Requirements
• 25.3 Setting up the Topology
  • 25.3.1 Creating an Attunity Stream Data Server
    • 25.3.1.1 Creation of the Data Server
  • 25.3.2 Creating an Attunity Stream Physical Schema
• 25.4 Setting Up an Integration Project
• 25.5 Creating and Reverse-Engineering an Attunity Stream Model
  • 25.5.1 Create an Attunity Stream Model
  • 25.5.2 Reverse-engineer an Attunity Stream Model
• 25.6 Designing an Interface Using the LKM Attunity to SQL

26 Oracle GoldenGate

• 26.1 Introduction
  • 26.1.1 Overview of the GoldeGate CDC Process
  • 26.1.2 Knowledge Modules
• 26.2 Installation and Configuration
  • 26.2.1 System Requirements and Certifications
  • 26.2.2 Technology Specific Requirements
  • 26.2.3 Connectivity Requirements
• 26.3 Working with the Oracle GoldenGate JKMs
  • 26.3.1 Define the Topology
    • 26.3.1.1 Define the Staging Server
    • 26.3.1.2 Create the Staging Physical Schema
    • 26.3.1.3 Define the Source Data Server
    • 26.3.1.4 Create the Source Physical Schema
  • 26.3.2 Create the Replicated Tables
  • 26.3.3 Set Up an Integration Project
  • 26.3.4 Configure CDC for the Replicated Tables
  • 26.3.5 Configure and Start Oracle GoldenGate Processes
  • 26.3.6 Design Interfaces Using Replicated Data
• 26.4 Advanced Configuration
  • 26.4.1 Initial Load Method
  • 26.4.2 Tuning Replication Performances
  • 26.4.3 One Source Multiple Staging Configuration

27 Oracle Enterprise Service Bus

• 27.1 Introduction
  • 27.1.1 Concepts
  • 27.1.2 Knowledge Modules
  • 27.1.3 Overview of the XREF KM Process
• 27.2 Installation and Configuration
  • 27.2.1 System Requirements and Certifications
  • 27.2.2 Technology Specific Requirements
  • 27.2.3 Connectivity Requirements
• 27.3 Working with XREF using the ESB Cross-References KMs
  • 27.3.1 Defining the Topology
  • 27.3.2 Setting up the Project
  • 27.3.3 Designing an Interface with the ESB Cross-References KMs
• 27.4 Knowledge Module Options Reference

A Oracle Data Integrator Driver for LDAP Reference

• A.1 Introduction to Oracle Data Integrator Driver for LDAP
• A.2 LDAP Processing Overview
  • A.2.1 LDAP to Relational Mapping
    • A.2.1.1 General Principle
    • A.2.1.2 Grouping Factor
    • A.2.1.3 Mapping Exceptions
    • A.2.1.4 Reference LDAP Tree
  • A.2.2 Managing Relational Schemas
    • A.2.2.1 Relational Schema Storage
    • A.2.2.2 Accessing Data in the Relational Structure
• A.3 Installation and Configuration
  • A.3.1 Driver Configuration
  • A.3.2 Using Property Bundles
    • A.3.2.1 LDAP Directory Connection Configuration
    • A.3.2.2 External Database Connection Configuration
  • A.3.3 Table Aliases Configuration
• A.4 SQL Syntax
  • A.4.1 SQL Statements
    • A.4.1.1 DISCONNECT
    • A.4.1.2 INSERT INTO
    • A.4.1.3 SELECT
    • A.4.1.4 UPDATE
    • A.4.1.5 Expressions, Condition & values
  • A.4.2 SQL FUNCTIONS
• A.5 JDBC API Implemented Features

B Oracle Data Integrator Driver for XML Reference

• B.1 Introduction to Oracle Data Integrator Driver for XML
• B.2 XML Processing Overview
  • B.2.1 XML to SQL Mapping
  • B.2.2 XML Namespaces
  • B.2.3 Managing Schemas
    • B.2.3.1 Schema Storage
    • B.2.3.2 Multiple Schemas
    • B.2.3.3 Accessing Data in the Schemas
    • B.2.3.4 Case Sensitivity
    • B.2.3.5 Loading/Synchronizing
  • B.2.4 Locking
  • B.2.5 XML Schema (XSD) Support
• B.3 Installation and Configuration
  • B.3.1 Driver Configuration
  • B.3.2 Automatically Create Multiple Schemas
  • B.3.3 Using an External Database to Store the Data
• B.4 Detailed Driver Commands
  • B.4.1 CREATE FILE
  • B.4.2 CREATE XMLFILE
  • B.4.3 CREATE FOREIGNKEYS
  • B.4.4 CREATE SCHEMA
  • B.4.5 DROP FOREIGNKEYS
  • B.4.6 DROP SCHEMA
  • B.4.7 LOAD FILE
  • B.4.8 SET SCHEMA
  • B.4.9 SYNCHRONIZE
  • B.4.10 UNLOCK FILE
  • B.4.11 TRUNCATE SCHEMA
  • B.4.12 VALIDATE
• B.5 SQL Syntax
  • B.5.1 SQL Statements
    • B.5.1.1 COMMIT
    • B.5.1.2 CREATE TABLE
    • B.5.1.3 DELETE
    • B.5.1.4 DISCONNECT
    • B.5.1.5 DROP TABLE
    • B.5.1.6 INSERT INTO
    • B.5.1.7 ROLLBACK
    • B.5.1.8 SELECT
    • B.5.1.9 SET AUTOCOMMIT
    • B.5.1.10 UPDATE
    • B.5.1.11 Expressions, Condition and Values
  • B.5.2 SQL FUNCTIONS
• B.6 JDBC API Implemented Features
• B.7 XML Schema Supported Features
  • B.7.1 Datatypes
  • B.7.2 Supported Elements
    • B.7.2.1 All
    • B.7.2.2 Attribute
    • B.7.2.3 AttributeGroup
    • B.7.2.4 Choice
    • B.7.2.5 ComplexContent
    • B.7.2.6 ComplexType
    • B.7.2.7 Element
    • B.7.2.8 Extension
    • B.7.2.9 Group
    • B.7.2.10 Import
    • B.7.2.11 Include
    • B.7.2.12 List
    • B.7.2.13 Restriction
    • B.7.2.14 Schema
    • B.7.2.15 Sequence
    • B.7.2.16 SimpleContent
    • B.7.2.17 SimpleType
  • B.7.3 Unsupported Features
    • B.7.3.1 Unsupported Elements
    • B.7.3.2 Unsupported Features