Contents

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
    • 3.6.2.1 IKM SQL to File Append
    • 3.6.2.2 IKM File to File (Java)

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 Complex Files

• 6.1 Introduction
  • 6.1.1 Concepts
  • 6.1.2 Knowledge Modules
• 6.2 Installation and Configuration
  • 6.2.1 System Requirements
  • 6.2.2 Technology Specific Requirements
  • 6.2.3 Connectivity Requirements
• 6.3 Setting up the Topology
  • 6.3.1 Creating a Complex File Data Server
    • 6.3.1.1 Creation of the Data Server
  • 6.3.2 Creating a Complex File Physical Schema
• 6.4 Setting Up an Integration Project
• 6.5 Creating and Reverse-Engineering a Complex File Model
  • 6.5.1 Create a Complex File Model
  • 6.5.2 Reverse-engineer a Complex File Model
• 6.6 Designing an Interface

7 Microsoft SQL Server

• 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.2.1 Using the BULK INSERT Command
    • 7.2.2.2 Using the BCP Command
    • 7.2.2.3 Using Linked Servers
  • 7.2.3 Connectivity Requirements
• 7.3 Setting up the Topology
  • 7.3.1 Creating a Microsoft SQL Server Data Server
    • 7.3.1.1 Creation of the Data Server
  • 7.3.2 Creating a Microsoft SQL Server Physical Schema
• 7.4 Setting Up an Integration Project
• 7.5 Creating and Reverse-Engineering a Microsoft SQL Server Model
  • 7.5.1 Create a Microsoft SQL Server Model
  • 7.5.2 Reverse-engineer a Microsoft SQL Server Model
• 7.6 Setting up Changed Data Capture
• 7.7 Setting up Data Quality
• 7.8 Designing an Interface
  • 7.8.1 Loading Data from and to Microsoft SQL Server
    • 7.8.1.1 Loading Data from Microsoft SQL Server
    • 7.8.1.2 Loading Data to Microsoft SQL Server
  • 7.8.2 Integrating Data in Microsoft SQL Server

8 Microsoft Excel

• 8.1 Introduction
  • 8.1.1 Concepts
  • 8.1.2 Knowledge Modules
• 8.2 Installation and Configuration
  • 8.2.1 System Requirements and Certifications
  • 8.2.2 Technology Specific Requirements
  • 8.2.3 Connectivity Requirements
• 8.3 Setting up the Topology
  • 8.3.1 Creating a Microsoft Excel Data Server
  • 8.3.2 Creating a Microsoft Excel Physical Schema
• 8.4 Setting Up an Integration Project
• 8.5 Creating and Reverse-Engineering a Microsoft Excel Model
  • 8.5.1 Create a Microsoft Excel Model
  • 8.5.2 Reverse-engineer a Microsoft Excel Model
• 8.6 Designing an Interface
  • 8.6.1 Loading Data From and to Microsoft Excel
    • 8.6.1.1 Loading Data from Microsoft Excel
    • 8.6.1.2 Loading Data to Microsoft Excel
  • 8.6.2 Integrating Data in Microsoft Excel
• 8.7 Troubleshooting
  • 8.7.1 Decoding Error Messages
  • 8.7.2 Common Problems and Solutions

9 Microsoft Access

• 9.1 Introduction
• 9.2 Concepts
• 9.3 Knowledge Modules
• 9.4 Specific Requirements

10 Netezza

• 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 Netezza Data Server
    • 10.3.1.1 Creation of the Data Server
  • 10.3.2 Creating a Netezza Physical Schema
• 10.4 Setting Up an Integration Project
• 10.5 Creating and Reverse-Engineering a Netezza Model
  • 10.5.1 Create a Netezza Model
  • 10.5.2 Reverse-engineer a Netezza Model
• 10.6 Setting up Data Quality
• 10.7 Designing an Interface
  • 10.7.1 Loading Data from and to Netezza
    • 10.7.1.1 Loading Data from Netezza
    • 10.7.1.2 Loading Data to Netezza
  • 10.7.2 Integrating Data in Netezza

11 Teradata

• 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 Teradata Data Server
    • 11.3.1.1 Creation of the Data Server
  • 11.3.2 Creating a Teradata Physical Schema
• 11.4 Setting Up an Integration Project
• 11.5 Creating and Reverse-Engineering a Teradata Model
  • 11.5.1 Create a Teradata Model
  • 11.5.2 Reverse-engineer a Teradata Model
• 11.6 Setting up Data Quality
• 11.7 Designing an Interface
  • 11.7.1 Loading Data from and to Teradata
    • 11.7.1.1 Loading Data from Teradata
    • 11.7.1.2 Loading Data to Teradata
  • 11.7.2 Integrating Data in Teradata
  • 11.7.3 Designing an ETL-Style Interface
• 11.8 KM Optimizations for Teradata
  • 11.8.1 Primary Indexes and Statistics
  • 11.8.2 Support for Teradata Utilities
  • 11.8.3 Support for Named Pipes
  • 11.8.4 Optimized Management of Temporary Tables

12 Hypersonic SQL

• 12.1 Introduction
  • 12.1.1 Concepts
  • 12.1.2 Knowledge Modules
• 12.2 Installation and Configuration
  • 12.2.1 System Requirements and Certifications
  • 12.2.2 Technology Specific Requirements
  • 12.2.3 Connectivity Requirements
• 12.3 Setting up the Topology
  • 12.3.1 Creating a Hypersonic SQL Data Server
  • 12.3.2 Creating a Hypersonic SQL Physical Schema
• 12.4 Setting Up an Integration Project
• 12.5 Creating and Reverse-Engineering a Hypersonic SQL Model
  • 12.5.1 Create a Hypersonic SQL Model
  • 12.5.2 Reverse-engineer a Hypersonic SQL Model
• 12.6 Setting up Changed Data Capture
• 12.7 Setting up Data Quality
• 12.8 Designing an Interface

13 IBM Informix

• 13.1 Introduction
• 13.2 Concepts
• 13.3 Knowledge Modules
• 13.4 Specific Requirements

14 IBM DB2 for iSeries

• 14.1 Introduction
  • 14.1.1 Concepts
  • 14.1.2 Knowledge Modules
• 14.2 Installation and Configuration
  • 14.2.1 System Requirements and Certifications
  • 14.2.2 Technology Specific Requirements
  • 14.2.3 Connectivity Requirements
• 14.3 Setting up the Topology
  • 14.3.1 Creating a DB2/400 Data Server
    • 14.3.1.1 Creation of the Data Server
  • 14.3.2 Creating a DB2/400 Physical Schema
• 14.4 Setting Up an Integration Project
• 14.5 Creating and Reverse-Engineering an IBM DB2/400 Model
  • 14.5.1 Create an IBM DB2/400 Model
  • 14.5.2 Reverse-engineer an IBM DB2/400 Model
• 14.6 Setting up Changed Data Capture
  • 14.6.1 Setting up Trigger-Based CDC
  • 14.6.2 Setting up Log-Based CDC
    • 14.6.2.1 How does it work?
    • 14.6.2.2 CDCRTVJRN Program Details
    • 14.6.2.3 Installing the CDC Components on iSeries
    • 14.6.2.4 Using the CDC with the Native Journals
    • 14.6.2.5 Problems While Reading Journals
• 14.7 Setting up Data Quality
• 14.8 Designing an Interface
  • 14.8.1 Loading Data from and to IBM DB2 for iSeries
    • 14.8.1.1 Loading Data from IBM DB2 for iSeries
    • 14.8.1.2 Loading Data to IBM DB2 for iSeries
  • 14.8.2 Integrating Data in IBM DB2 for iSeries
• 14.9 Specific Considerations with DB2 for iSeries
  • 14.9.1 Installing the Run-Time Agent on iSeries
  • 14.9.2 Alternative Connectivity Methods for iSeries
    • 14.9.2.1 Using Client Access
    • 14.9.2.2 Using the IBM JT/400 and Native Drivers
• 14.10 Troubleshooting
  • 14.10.1 Troubleshooting Error messages
  • 14.10.2 Common Problems and Solutions
    • 14.10.2.1 Connection Errors

15 IBM DB2 UDB

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

16 Sybase AS Enterprise

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

17 Sybase IQ

• 17.1 Introduction
• 17.2 Concepts
• 17.3 Knowledge Modules
• 17.4 Specific Requirements

Part II Business Intelligence

18 Oracle Business Intelligence Enterprise Edition

• 18.1 Introduction
  • 18.1.1 Concepts
  • 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 Oracle BI Data Server
    • 18.3.1.1 Creation of the Data Server
  • 18.3.2 Creating an Oracle BI Physical Schema
• 18.4 Setting Up an Integration Project
• 18.5 Creating and Reverse-Engineering an Oracle BI Model
  • 18.5.1 Create an Oracle BI Model
  • 18.5.2 Reverse-engineer an Oracle BI Model
• 18.6 Setting up Data Quality
• 18.7 Designing an Interface
  • 18.7.1 Loading Data from and to Oracle BI
    • 18.7.1.1 Loading Data from Oracle BI
    • 18.7.1.2 Loading Data to Oracle BI
  • 18.7.2 Integrating Data in Oracle BI

19 Oracle Business Intelligence Enterprise Edition Data Lineage

• 19.1 Introduction
  • 19.1.1 Components
  • 19.1.2 Lineage Lifecycle
    • 19.1.2.1 Setting up the Lineage
    • 19.1.2.2 Refreshing the Lineage
    • 19.1.2.3 Using the Lineage
• 19.2 Installing the Lineage in an OBIEE Server
  • 19.2.1 Installation Overview
  • 19.2.2 Requirements
  • 19.2.3 Installation Instructions
    • 19.2.3.1 Installing and Starting the OBIEE Lineage Wizard
    • 19.2.3.2 Deploying the OBIEE Lineage Artifacts using the Wizard
  • 19.2.4 Post-Installation Tasks
• 19.3 Exporting Metadata from OBIEE and Refreshing the OBIEE Lineage
• 19.4 Refreshing the OBIEE Lineage from Existing Exports
  • 19.4.1 Exporting the OBIEE Repository Documentation to a Text File
  • 19.4.2 Exporting the OBIEE Web Catalog Report to a Text File
  • 19.4.3 Refreshing the OBIEE Lineage From Existing Exports
• 19.5 Automating the Lineage Tasks
  • 19.5.1 Configuring the Scripts
  • 19.5.2 Automating Lineage Deployment
  • 19.5.3 Automating Lineage Refresh
• 19.6 Using the Lineage in OBIEE Dashboards
  • 19.6.1 Viewing Execution Statistics
  • 19.6.2 Viewing and Filtering Lineage Data
  • 19.6.3 Using the Dashboard
  • 19.6.4 Using Lineage and Hierarchy
  • 19.6.5 Using Contextual Lineage

20 Oracle Hyperion Essbase

• 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 Essbase Data Server
  • 20.3.2 Creating an Hyperion Essbase Physical Schema
• 20.4 Creating and Reverse-Engineering an Essbase Model
  • 20.4.1 Create an Essbase Model
  • 20.4.2 Reverse-engineer an Essbase Model
• 20.5 Designing an Interface
  • 20.5.1 Loading Metadata
  • 20.5.2 Loading Data
  • 20.5.3 Extracting Data
    • 20.5.3.1 Data Extraction Methods for Essbase
    • 20.5.3.2 Extracting Essbase Data
    • 20.5.3.3 Extracting Members from Metadata

21 Oracle Hyperion Financial Management

• 21.1 Introduction
  • 21.1.1 Integration Process
  • 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 Hyperion Financial Management Data Server
  • 21.3.2 Creating an Hyperion Financial Management Physical Schema
• 21.4 Creating and Reverse-Engineering a Financial Management Model
  • 21.4.1 Create an Financial Management Model
  • 21.4.2 Reverse-Engineer an Financial Management Model
• 21.5 Designing an Interface
  • 21.5.1 Loading Metadata
  • 21.5.2 Loading Data
  • 21.5.3 Extracting Data
    • 21.5.3.1 Extracting Financial Management Data
    • 21.5.3.2 Extracting Members from Member Lists
• 21.6 Data Store Tables

22 Oracle Hyperion Planning

• 22.1 Introduction
  • 22.1.1 Integration Process
  • 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 an Hyperion Planning Data Server
  • 22.3.2 Creating an Hyperion Planning Physical Schema
• 22.4 Creating and Reverse-Engineering a Planning Model
  • 22.4.1 Create a Planning Model
  • 22.4.2 Reverse-engineer a Planning Model
• 22.5 Designing an Interface
  • 22.5.1 Loading Metadata
  • 22.5.2 Loading Data
  • 22.5.3 Load Options
• 22.6 Datastore Tables and Data Load Columns
  • 22.6.1 Accounts
  • 22.6.2 Employee
  • 22.6.3 Entities
  • 22.6.4 User-Defined Dimensions
  • 22.6.5 Attribute Dimensions
  • 22.6.6 UDA
  • 22.6.7 Data Load Columns

23 Oracle OLAP

• 23.1 Introduction
  • 23.1.1 Concepts
  • 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 an Oracle Data Server
    • 23.3.1.1 Creation of the Data Server
  • 23.3.2 Creating an Oracle Physical Schema
• 23.4 Setting Up an Integration Project
• 23.5 Creating and Reverse-Engineering an Oracle Model
  • 23.5.1 Create an Oracle Model
  • 23.5.2 Reverse-engineer an Oracle OLAP Cube
• 23.6 Working with Oracle OLAP KMs in Integration Interfaces
  • 23.6.1 Using Oracle OLAP as a Source in an Integration Interface
  • 23.6.2 Using Oracle ROLAP as a Target in an Integration Interface
  • 23.6.3 Using Oracle MOLAP as a Target in an Integration Interface

Part III Other Technologies

24 JMS

• 24.1 Introduction
  • 24.1.1 Concepts
    • 24.1.1.1 JMS Message Structure
    • 24.1.1.2 Using a JMS Destination
  • 24.1.2 Knowledge Modules
• 24.2 Installation and Configuration
  • 24.2.1 System Requirements and Certifications
  • 24.2.2 Technology Specific Requirements
  • 24.2.3 Connectivity Requirements
• 24.3 Setting up the Topology
  • 24.3.1 Creating a JMS Data Server
    • 24.3.1.1 Creation of the Data Server
  • 24.3.2 Creating a JMS Physical Schema
• 24.4 Setting Up an Integration Project
• 24.5 Creating and Defining a JMS Model
  • 24.5.1 Create a JMS Model
  • 24.5.2 Defining the JMS Datastores
• 24.6 Designing an Interface
  • 24.6.1 Loading Data from a JMS Source
  • 24.6.2 Integrating Data in a JMS Target
• 24.7 JMS Standard Properties
  • 24.7.1 Using JMS Properties
    • 24.7.1.1 Declaring JMS Properties
    • 24.7.1.2 Filtering on the Router
    • 24.7.1.3 Filtering on the Client
    • 24.7.1.4 Using Property Values as Source Data
    • 24.7.1.5 Setting Properties when Sending a Message

25 JMS XML

• 25.1 Introduction
  • 25.1.1 Concepts
    • 25.1.1.1 JMS Message Structure
    • 25.1.1.2 Using a JMS Destination
  • 25.1.2 Knowledge Modules
• 25.2 Installation and Configuration
  • 25.2.1 System Requirements and Certifications
  • 25.2.2 Technology Specific Requirements
  • 25.2.3 Connectivity Requirements
• 25.3 Setting up the Topology
  • 25.3.1 Creating a JMS XML Data Server
    • 25.3.1.1 Creation of the Data Server
  • 25.3.2 Creating a JMS XML Physical Schema
• 25.4 Setting Up an Integration Project
• 25.5 Creating and Reverse-Engineering a JMS XML Model
  • 25.5.1 Create a JMS XML Model
  • 25.5.2 Reverse-Engineering a JMS XML Model
• 25.6 Designing an Interface
  • 25.6.1 Loading Data from a JMS XML Source
  • 25.6.2 Integrating Data in a JMS XML Target

26 LDAP Directories

• 26.1 Introduction
  • 26.1.1 Concepts
  • 26.1.2 Knowledge Modules
• 26.2 Installation and Configuration
  • 26.2.1 System Requirements
  • 26.2.2 Technologic Specific Requirements
  • 26.2.3 Connectivity Requirements
• 26.3 Setting up the Topology
  • 26.3.1 Creating an LDAP Data Server
    • 26.3.1.1 Creation of the Data Server
  • 26.3.2 Creating a Physical Schema for LDAP
• 26.4 Setting Up an Integration Project
• 26.5 Creating and Reverse-Engineering an LDAP Directory
  • 26.5.1 Create an LDAP Model
  • 26.5.2 Reverse-Engineering an LDAP Model
• 26.6 Designing an Interface
  • 26.6.1 Loading Data from and to LDAP
    • 26.6.1.1 Loading Data from an LDAP Directory
    • 26.6.1.2 Loading Data to an LDAP Directory
  • 26.6.2 Integrating Data in an LDAP Directory
• 26.7 Troubleshooting

27 Oracle TimesTen In-Memory Database

• 27.1 Introduction
  • 27.1.1 Concepts
  • 27.1.2 Knowledge Modules
• 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 Setting up the Topology
  • 27.3.1 Creating a TimesTen Data Server
    • 27.3.1.1 Creation of the Data Server
  • 27.3.2 Creating a TimesTen Physical Schema
• 27.4 Setting Up an Integration Project
• 27.5 Creating and Reverse-Engineering a TimesTen Model
  • 27.5.1 Create a TimesTen Model
  • 27.5.2 Reverse-engineer a TimesTen Model
• 27.6 Setting up Data Quality
• 27.7 Designing an Interface
  • 27.7.1 Loading Data from and to TimesTen
    • 27.7.1.1 Loading Data from TimesTen
    • 27.7.1.2 Loading Data to TimesTen
  • 27.7.2 Integrating Data in TimesTen

28 Oracle Changed Data Capture Adapters

• 28.1 Introduction
  • 28.1.1 Concepts
  • 28.1.2 Knowledge Modules
• 28.2 Installation and Configuration
  • 28.2.1 System Requirements
  • 28.2.2 Technology Specific Requirements
  • 28.2.3 Connectivity Requirements
• 28.3 Setting up the Topology
  • 28.3.1 Creating an Attunity Stream Data Server
    • 28.3.1.1 Creation of the Data Server
  • 28.3.2 Creating an Attunity Stream Physical Schema
• 28.4 Setting Up an Integration Project
• 28.5 Creating and Reverse-Engineering an Attunity Stream Model
  • 28.5.1 Create an Attunity Stream Model
  • 28.5.2 Reverse-engineer an Attunity Stream Model
• 28.6 Designing an Interface Using the LKM Attunity to SQL

29 Oracle GoldenGate

• 29.1 Introduction
  • 29.1.1 Overview of the GoldeGate CDC Process
  • 29.1.2 Knowledge Modules
• 29.2 Installation and Configuration
  • 29.2.1 System Requirements and Certifications
  • 29.2.2 Technology Specific Requirements
  • 29.2.3 Connectivity Requirements
• 29.3 Working with the Oracle GoldenGate JKMs
  • 29.3.1 Define the Topology
    • 29.3.1.1 Define the Staging Server
    • 29.3.1.2 Create the Staging Physical Schema
    • 29.3.1.3 Define the Source Data Server
    • 29.3.1.4 Create the Source Physical Schema
  • 29.3.2 Create the Replicated Tables
  • 29.3.3 Set Up an Integration Project
  • 29.3.4 Configure CDC for the Replicated Tables
  • 29.3.5 Configure and Start Oracle GoldenGate Processes
  • 29.3.6 Design Interfaces Using Replicated Data
• 29.4 Advanced Configuration
  • 29.4.1 Initial Load Method
  • 29.4.2 Tuning Replication Performances
  • 29.4.3 One Source Multiple Staging Configuration

30 Oracle SOA Suite Cross References

• 30.1 Introduction
  • 30.1.1 Concepts
    • 30.1.1.1 General Principles
    • 30.1.1.2 Cross Reference Table Structures
    • 30.1.1.3 Handling Cross Reference Table Structures
  • 30.1.2 Knowledge Modules
  • 30.1.3 Overview of the SOA XREF KM Process
    • 30.1.3.1 Loading Phase (LKM)
    • 30.1.3.2 Integration and Cross-Referencing Phase (IKM)
    • 30.1.3.3 Updating/Deleting Processed Records (LKM)
• 30.2 Installation and Configuration
  • 30.2.1 System Requirements and Certifications
  • 30.2.2 Technology Specific Requirements
  • 30.2.3 Connectivity Requirements
• 30.3 Working with XREF using the SOA Cross References KMs
  • 30.3.1 Defining the Topology
  • 30.3.2 Setting up the Project
  • 30.3.3 Designing an Interface with the Cross-References KMs
• 30.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 an External Database to Store the Data
    • A.3.2.1 Passing the Properties in the Driver URL
    • A.3.2.2 Setting the Properties in ODI Studio
    • A.3.2.3 Setting the Properties in a Properties File
  • A.3.3 LDAP Directory Connection Configuration
  • A.3.4 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

C Oracle Data Integrator Driver for Complex Files Reference

• C.1 Introduction to Oracle Data Integrator Driver for Complex Files
• C.2 Complex Files Processing Overview
  • C.2.1 Generating the Native Schema
  • C.2.2 XML to SQL Mapping
  • C.2.3 Supported Features
• C.3 Driver Configuration
• C.4 Detailed Driver Commands
• C.5 JDBC API and XML Schema Supported Features