Go to main content
1/40
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 a Mapping
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 Mapping
2.9
Troubleshooting
2.9.1
Troubleshooting Oracle Database Errors
2.9.2
Common Problems and Solutions
3
Oracle Autonomous Data Warehouse Cloud
3.1
Introduction
3.1.1
Concepts
3.1.2
Knowledge Modules
3.2
Prerequisites
3.3
Setting up the Topology
3.3.1
Creating an Oracle Data Server
3.3.2
Creating an Oracle Physical Schema
3.4
Creating and Reverse-Engineering an Oracle Model
3.4.1
Create an Oracle Model
3.4.2
Reverse Engineer an Oracle Model
3.5
Designing a Mapping
3.5.1
Loading data
3.5.2
Extracting data
4
Files
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 File Data Server
4.3.1.1
Creation of the Data Server
4.3.2
Creating a File Physical Schema
4.4
Setting Up an Integration Project
4.5
Creating and Reverse-Engineering a File Model
4.5.1
Create a File Model
4.5.2
Reverse-engineer a File Model
4.5.2.1
Delimited Files Reverse-Engineering
4.5.2.2
Fixed Files Reverse-engineering using the Wizard
4.5.2.3
COBOL Copybook reverse-engineering
4.5.2.4
Customized Reverse-Engineering
4.6
Designing a Mapping
4.6.1
Loading Data From Files
4.6.2
Integrating Data in Files
4.6.2.1
IKM SQL to File Append
4.6.2.2
IKM File to File (Java)
5
Generic SQL
5.1
Introduction
5.1.1
Concepts
5.1.2
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
Creating a Data Server
5.3.2
Creating a Physical Schema
5.4
Setting up an Integration Project
5.5
Creating and Reverse-Engineering a Model
5.5.1
Create a Data Model
5.5.2
Reverse-engineer a Data Model
5.6
Setting up Changed Data Capture
5.7
Setting up Data Quality
5.8
Designing a Mapping
5.8.1
Loading Data From and to an ANSI SQL-92 Compliant Technology
5.8.1.1
Loading Data from an ANSI SQL-92 Compliant Technology
5.8.1.2
Loading Data to an ANSI SQL-92 Compliant Technology
5.8.2
Integrating Data in an ANSI SQL-92 Compliant Technology
5.8.3
Designing an ETL-Style Mapping
6
XML Files
6.1
Introduction
6.1.1
Concepts
6.1.2
Pre/Post Processing Support for XML Driver
6.1.3
Knowledge Modules
6.2
Installation and Configuration
6.2.1
System Requirements
6.2.2
Technologic Specific Requirements
6.2.3
Connectivity Requirements
6.3
Setting up the Topology
6.3.1
Creating an XML Data Server
6.3.1.1
Creation of the Data Server
6.3.2
Creating a Physical Schema for XML
6.4
Setting Up an Integration Project
6.5
Creating and Reverse-Engineering a XML File
6.5.1
Create an XML Model
6.5.2
Reverse-Engineering an XML Model
6.6
Designing a Mapping
6.6.1
Notes about XML Mappings
6.6.1.1
Targeting an XML Structure
6.6.1.2
Synchronizing XML File and Schema
6.6.1.3
Handling Large XML Files
6.6.2
Loading Data from and to XML
6.6.2.1
Loading Data from an XML Schema
6.6.2.2
Loading Data to an XML Schema
6.6.3
Integrating Data in XML
6.7
Troubleshooting
6.7.1
Detect the Errors Coming from XML
6.7.2
Common Errors
7
Complex Files
7.1
Introduction
7.1.1
Concepts
7.1.2
Pre/Post Processing Support for Complex File Driver
7.1.3
Knowledge Modules
7.2
Installation and Configuration
7.2.1
System Requirements
7.2.2
Technology Specific Requirements
7.2.3
Connectivity Requirements
7.3
Building a Native Schema Description File Using the Native Format Builder
7.4
Setting up the Topology
7.4.1
Creating a Complex File Data Server
7.4.1.1
Creation of the Data Server
7.4.2
Creating a Complex File Physical Schema
7.5
Setting Up an Integration Project
7.6
Creating and Reverse-Engineering a Complex File Model
7.6.1
Create a Complex File Model
7.6.2
Reverse-engineer a Complex File Model
7.7
Designing a Mapping
8
Microsoft SQL Server
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.2.1
Using the BULK INSERT Command
8.2.2.2
Using the BCP Command
8.2.2.3
Using Linked Servers
8.2.3
Connectivity Requirements
8.3
Setting up the Topology
8.3.1
Creating a Microsoft SQL Server Data Server
8.3.1.1
Creation of the Data Server
8.3.2
Creating a Microsoft SQL Server Physical Schema
8.4
Setting Up an Integration Project
8.5
Creating and Reverse-Engineering a Microsoft SQL Server Model
8.5.1
Create a Microsoft SQL Server Model
8.5.2
Reverse-engineer a Microsoft SQL Server Model
8.6
Setting up Changed Data Capture
8.7
Setting up Data Quality
8.8
Designing a Mapping
8.8.1
Loading Data from and to Microsoft SQL Server
8.8.1.1
Loading Data from Microsoft SQL Server
8.8.1.2
Loading Data to Microsoft SQL Server
8.8.2
Integrating Data in Microsoft SQL Server
9
Microsoft Excel
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 Microsoft Excel Data Server
9.3.2
Creating a Microsoft Excel Physical Schema
9.4
Setting Up an Integration Project
9.5
Creating and Reverse-Engineering a Microsoft Excel Model
9.5.1
Create a Microsoft Excel Model
9.5.2
Reverse-engineer a Microsoft Excel Model
9.6
Designing a Mapping
9.6.1
Loading Data From and to Microsoft Excel
9.6.1.1
Loading Data from Microsoft Excel
9.6.1.2
Loading Data to Microsoft Excel
9.6.2
Integrating Data in Microsoft Excel
9.7
Troubleshooting
9.7.1
Decoding Error Messages
9.7.2
Common Problems and Solutions
10
Microsoft Access
10.1
Introduction
10.2
Concepts
10.3
Knowledge Modules
10.4
Specific Requirements
11
Netezza
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 Netezza Data Server
11.3.1.1
Creation of the Data Server
11.3.2
Creating a Netezza Physical Schema
11.4
Setting Up an Integration Project
11.5
Creating and Reverse-Engineering a Netezza Model
11.5.1
Create a Netezza Model
11.5.2
Reverse-engineer a Netezza Model
11.6
Setting up Data Quality
11.7
Designing a Mapping
11.7.1
Loading Data from and to Netezza
11.7.1.1
Loading Data from Netezza
11.7.1.2
Loading Data to Netezza
11.7.2
Integrating Data in Netezza
12
Teradata
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 Teradata Data Server
12.3.1.1
Creation of the Data Server
12.3.2
Creating a Teradata Physical Schema
12.4
Setting Up an Integration Project
12.5
Creating and Reverse-Engineering a Teradata Model
12.5.1
Create a Teradata Model
12.5.2
Reverse-engineer a Teradata Model
12.6
Setting up Data Quality
12.7
Designing a Mapping
12.7.1
Loading Data from and to Teradata
12.7.1.1
Loading Data from Teradata
12.7.1.2
Loading Data to Teradata
12.7.2
Integrating Data in Teradata
12.7.3
Designing an ETL-Style Mapping
12.8
KM Optimizations for Teradata
12.8.1
Primary Indexes and Statistics
12.8.2
Support for Teradata Utilities
12.8.3
Support for Named Pipes
12.8.4
Optimized Management of Temporary Tables
13
Hypersonic SQL
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 Hypersonic SQL Data Server
13.3.2
Creating a Hypersonic SQL Physical Schema
13.4
Setting Up an Integration Project
13.5
Creating and Reverse-Engineering a Hypersonic SQL Model
13.5.1
Create a Hypersonic SQL Model
13.5.2
Reverse-engineer a Hypersonic SQL Model
13.6
Setting up Changed Data Capture
13.7
Setting up Data Quality
13.8
Designing a Mapping
14
IBM Informix
14.1
Introduction
14.2
Concepts
14.3
Knowledge Modules
14.4
Specific Requirements
15
IBM DB2 for iSeries
15.1
Introduction
15.1.1
Concepts
15.1.2
Knowledge Modules
15.2
Installation and Configuration
15.2.1
System Requirements and Certifications
15.2.2
Technology Specific Requirements
15.2.3
Connectivity Requirements
15.3
Setting up the Topology
15.3.1
Creating a DB2/400 Data Server
15.3.1.1
Creation of the Data Server
15.3.2
Creating a DB2/400 Physical Schema
15.4
Setting Up an Integration Project
15.5
Creating and Reverse-Engineering an IBM DB2/400 Model
15.5.1
Create an IBM DB2/400 Model
15.5.2
Reverse-engineer an IBM DB2/400 Model
15.6
Setting up Changed Data Capture
15.6.1
Setting up Trigger-Based CDC
15.6.2
Setting up Log-Based CDC
15.6.2.1
How does it work?
15.6.2.2
CDCRTVJRN Program Details
15.6.2.3
Installing the CDC Components on iSeries
15.6.2.4
Using the CDC with the Native Journals
15.6.2.5
Problems While Reading Journals
15.7
Setting up Data Quality
15.8
Designing a Mapping
15.8.1
Loading Data from and to IBM DB2 for iSeries
15.8.1.1
Loading Data from IBM DB2 for iSeries
15.8.1.2
Loading Data to IBM DB2 for iSeries
15.8.2
Integrating Data in IBM DB2 for iSeries
15.9
Specific Considerations with DB2 for iSeries
15.9.1
Installing the Run-Time Agent on iSeries
15.9.2
Alternative Connectivity Methods for iSeries
15.9.2.1
Using Client Access
15.9.2.2
Using the IBM JT/400 and Native Drivers
15.10
Troubleshooting
15.10.1
Troubleshooting Error messages
15.10.2
Common Problems and Solutions
15.10.2.1
Connection Errors
16
IBM DB2 UDB
16.1
Introduction
16.2
Concepts
16.3
Knowledge Modules
16.4
Specific Requirements
17
Salesforce.com
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 a Salesforce.com Data Server
17.3.2
Creating a Physical Schema for Salesforce.com Data Server
17.4
Setting Up an Integration Project
17.5
Creating and Reverse-Engineering a Salesforce.com Model
17.5.1
Create a Salesforce.com Model
17.5.2
Reverse-engineer a Salesforce.com Model
17.6
Designing a Mapping
17.6.1
Loading Data from and to Salesforce.com
17.6.1.1
Loading Data from Salesforce.com
17.6.1.2
Loading Data to Salesforce.com
17.6.2
Integrating Data in Salesforce.com
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 a Mapping
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 Business Intelligence Cloud Service
20.1
Introduction
20.2
Setting up the Topology
20.2.1
Creating an Oracle BICS Data Server
20.2.2
Creating an Oracle BICS Physical Schema
20.2.3
Importing BICS Certificate into Trust Store of Standalone Agent
20.3
Reverse Engineering a BICS Model
20.4
Designing a Mapping
21
Oracle Hyperion Planning
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 Hyperion Planning Adapter
21.3.1
Setting up Adapter for ODI Studio
21.3.2
Setting up Adapter for ODI Standalone Agent
21.4
Setting up the Topology
21.4.1
Creating an Hyperion Planning Data Server
21.4.2
Creating an Hyperion Planning Physical Schema
21.5
Creating and Reverse-Engineering a Planning Model
21.5.1
Create a Planning Model
21.5.2
Reverse-engineer a Planning Model
21.6
Designing a Mapping
21.6.1
Loading Metadata
21.6.2
Loading Data
21.6.3
Load Options
21.7
Datastore Tables and Data Load Columns
21.7.1
Accounts
21.7.2
Employee
21.7.3
Entities
21.7.4
User-Defined Dimensions
21.7.5
Attribute Dimensions
21.7.6
UDA
21.7.7
Data Load Columns
22
Oracle Hyperion Essbase
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 Hyperion Essbase Adapter
22.3.1
Setting up Adapter for ODI Studio
22.3.2
Setting up Adapter for ODI Standalone Agent
22.4
Setting up the Topology
22.4.1
Creating an Hyperion Essbase Data Server
22.4.2
Creating an Hyperion Essbase Physical Schema
22.5
Creating and Reverse-Engineering an Essbase Model
22.5.1
Create an Essbase Model
22.5.2
Reverse-engineer an Essbase Model
22.6
Designing a Mapping
22.6.1
Loading Metadata
22.6.2
Loading Data
22.6.3
Extracting Data
22.6.3.1
Data Extraction Methods for Essbase
22.6.3.2
Extracting Essbase Data
22.6.3.3
Extracting Members from Metadata
Part III Other Technologies
23
JMS
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 Data Server
23.3.1.1
Creation of the Data Server
23.3.2
Creating a JMS Physical Schema
23.4
Setting Up an Integration Project
23.5
Creating and Defining a JMS Model
23.5.1
Create a JMS Model
23.5.2
Defining the JMS Datastores
23.6
Designing a Mapping
23.6.1
Loading Data from a JMS Source
23.6.2
Integrating Data in a JMS Target
23.7
JMS Standard Properties
23.7.1
Using JMS Properties
23.7.1.1
Declaring JMS Properties
23.7.1.2
Filtering on the Router
23.7.1.3
Filtering on the Client
23.7.1.4
Using Property Values as Source Data
23.7.1.5
Setting Properties when Sending a Message
24
JMS XML
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 XML Data Server
24.3.1.1
Creation of the Data Server
24.3.2
Creating a JMS XML Physical Schema
24.4
Setting Up an Integration Project
24.5
Creating and Reverse-Engineering a JMS XML Model
24.5.1
Create a JMS XML Model
24.5.2
Reverse-Engineering a JMS XML Model
24.6
Designing a Mapping
24.6.1
Loading Data from a JMS XML Source
24.6.2
Integrating Data in a JMS XML Target
25
LDAP Directories
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
Technologic Specific Requirements
25.2.3
Connectivity Requirements
25.3
Setting up the Topology
25.3.1
Creating an LDAP Data Server
25.3.1.1
Creation of the Data Server
25.3.2
Creating a Physical Schema for LDAP
25.4
Setting Up an Integration Project
25.5
Creating and Reverse-Engineering an LDAP Directory
25.5.1
Create an LDAP Model
25.5.2
Reverse-Engineering an LDAP Model
25.6
Designing a Mapping
25.6.1
Loading Data from and to LDAP
25.6.1.1
Loading Data from an LDAP Directory
25.6.1.2
Loading Data to an LDAP Directory
25.6.2
Integrating Data in an LDAP Directory
25.7
Troubleshooting
26
Oracle TimesTen In-Memory Database
26.1
Introduction
26.1.1
Concepts
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
Setting up the Topology
26.3.1
Creating a TimesTen Data Server
26.3.1.1
Creation of the Data Server
26.3.2
Creating a TimesTen Physical Schema
26.4
Setting Up an Integration Project
26.5
Creating and Reverse-Engineering a TimesTen Model
26.5.1
Create a TimesTen Model
26.5.2
Reverse-engineer a TimesTen Model
26.6
Setting up Data Quality
26.7
Designing a Mapping
26.7.1
Loading Data from and to TimesTen
26.7.1.1
Loading Data from TimesTen
26.7.1.2
Loading Data to TimesTen
26.7.2
Integrating Data in TimesTen
27
Oracle GoldenGate
27.1
Introduction
27.1.1
Overview of the GoldenGate CDC Process
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
Working with the Oracle GoldenGate JKMs
27.3.1
Define the Topology
27.3.1.1
Define the Source Data Server
27.3.1.2
Create the Source Physical Schema
27.3.1.3
Define the Staging Server
27.3.1.4
Create the Staging Physical Schema
27.3.1.5
Define the Oracle GoldenGate Data Servers
27.3.1.6
Create the Oracle GoldenGate Physical Schemas
27.3.1.7
Create the Oracle GoldenGate Logical Schemas
27.3.2
Create the Replicated Tables
27.3.3
Set Up an Integration Project
27.3.4
Configure CDC for the Source Datastores
27.3.4.1
Create Oracle GoldenGate Physical Schemas from the model
27.3.5
Configure and Start Oracle GoldenGate Processes (Offline mode only)
27.3.6
Design Mappings Using Replicated Data
27.4
Advanced Configuration
27.4.1
Initial Load Method
27.4.2
Tuning Replication Performances
27.4.3
One Source Multiple Staging Configuration (Offline mode only)
27.5
Integrated Capture
27.5.1
Integrated Capture Deployment Options
27.5.2
Deciding Which Apply Method to Use
27.5.2.1
Nonintegrated Replicat
27.5.2.1.1
Integrated Replicat
27.5.2.1.2
Integrated Replicat Requirements
27.6
Using Different Capture and Apply Modes Together
27.7
Switching to Different Process Mode
27.8
Upgrading GoldenGate Classic Extract to Integrated
28
Oracle SOA Suite Cross References
28.1
Introduction
28.1.1
Concepts
28.1.1.1
General Principles
28.1.1.2
Cross Reference Table Structures
28.1.1.3
Handling Cross Reference Table Structures
28.1.2
Knowledge Modules
28.1.3
Overview of the SOA XREF KM Process
28.1.3.1
Loading Phase (LKM)
28.1.3.2
Integration and Cross-Referencing Phase (IKM)
28.1.3.3
Updating/Deleting Processed Records (LKM)
28.2
Installation and Configuration
28.2.1
System Requirements and Certifications
28.2.2
Technology Specific Requirements
28.2.3
Connectivity Requirements
28.3
Working with XREF using the SOA Cross References KMs
28.3.1
Defining the Topology
28.3.2
Setting up the Project
28.3.3
Designing a Mapping with the Cross-References KMs
28.4
Knowledge Module Options Reference
Part IV Appendices
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 FOREIGNKEYS
B.4.3
CREATE XMLFILE
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.4.13
WRITE MAPPING FILE
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
Rich Metadata
B.7.1
Supported user-specified types for different databases
B.8
XML Schema Supported Features
B.8.1
Datatypes
B.8.2
Supported Elements
B.8.2.1
All
B.8.2.2
Any
B.8.2.3
AnyAttribute
B.8.2.4
AnyType
B.8.2.5
Attribute
B.8.2.6
AttributeGroup
B.8.2.7
Choice
B.8.2.8
ComplexContent
B.8.2.9
ComplexType
B.8.2.10
Element
B.8.2.11
Extension
B.8.2.12
Group
B.8.2.13
Import
B.8.2.14
Include
B.8.2.15
List
B.8.2.16
Restriction
B.8.2.17
Schema
B.8.2.18
Sequence
B.8.2.19
SimpleContent
B.8.2.20
SimpleType
B.8.3
Unsupported Features
B.8.3.1
Unsupported Elements
B.8.3.2
Unsupported Features
B.8.3.3
Unsupported Datatypes
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
JSON Support
C.2.4
Supported Features
C.3
Driver Configuration
C.4
Detailed Driver Commands
C.5
JDBC API and XML Schema Supported Features
D
Pre/Post Processing Support for XML and Complex File Drivers
D.1
Overview
D.2
Configuring the processing stages
D.3
Implementing the processing stages
D.4
Example: Groovy Script for Reading XML Data From Within a ZIP File
D.5
Example: Groovy Script for Transforming XML Data and Writing to a Different Format
D.6
Example: Java Class for Reading Data From HTTP Source Requiring Authentication
D.7
Example: Groovy Code Embedded in Configuration XML File
Scripting on this page enhances content navigation, but does not change the content in any way.