Go to main content
1/36
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
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 a Mapping
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 a Mapping
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 Mapping
5
XML Files
5.1
Introduction
5.1.1
Concepts
5.1.2
Pre/Post Processing Support for XML Driver
5.1.3
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 a Mapping
5.6.1
Notes about XML Mappings
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
Pre/Post Processing Support for Complex File Driver
6.1.3
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
Building a Native Schema Description File Using the Native Format Builder
6.4
Setting up the Topology
6.4.1
Creating a Complex File Data Server
6.4.1.1
Creation of the Data Server
6.4.2
Creating a Complex File Physical Schema
6.5
Setting Up an Integration Project
6.6
Creating and Reverse-Engineering a Complex File Model
6.6.1
Create a Complex File Model
6.6.2
Reverse-engineer a Complex File Model
6.7
Designing a Mapping
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 a Mapping
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 a Mapping
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 a Mapping
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 a Mapping
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 Mapping
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 Data Quality
12.7
Designing a Mapping
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 a Mapping
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
Alternative Connectivity Methods for iSeries
14.9.1.1
Using Client Access
14.9.1.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
Part II Business Intelligence
16
Oracle Business Intelligence Enterprise Edition
16.1
Introduction
16.1.1
Concepts
16.1.2
Knowledge Modules
16.2
Installation and Configuration
16.2.1
System Requirements and Certifications
16.2.2
Technology Specific Requirements
16.2.3
Connectivity Requirements
16.3
Setting up the Topology
16.3.1
Creating an Oracle BI Data Server
16.3.1.1
Creation of the Data Server
16.3.2
Creating an Oracle BI Physical Schema
16.4
Setting Up an Integration Project
16.5
Creating and Reverse-Engineering an Oracle BI Model
16.5.1
Create an Oracle BI Model
16.5.2
Reverse-engineer an Oracle BI Model
16.6
Setting up Data Quality
16.7
Designing a Mapping
16.7.1
Loading Data from and to Oracle BI
16.7.1.1
Loading Data from Oracle BI
16.7.1.2
Loading Data to Oracle BI
16.7.2
Integrating Data in Oracle BI
17
Oracle Business Intelligence Enterprise Edition Data Lineage
17.1
Introduction
17.1.1
Components
17.1.2
Lineage Lifecycle
17.1.2.1
Setting up the Lineage
17.1.2.2
Refreshing the Lineage
17.1.2.3
Using the Lineage
17.2
Installing the Lineage in an OBIEE Server
17.2.1
Installation Overview
17.2.2
Requirements
17.2.3
Installation Instructions
17.2.3.1
Installing and Starting the OBIEE Lineage Wizard
17.2.3.2
Deploying the OBIEE Lineage Artifacts using the Wizard
17.2.4
Post-Installation Tasks
17.3
Exporting Metadata from OBIEE and Refreshing the OBIEE Lineage
17.4
Refreshing the OBIEE Lineage from Existing Exports
17.4.1
Exporting the OBIEE Repository Documentation to a Text File
17.4.2
Exporting the OBIEE Web Catalog Report to a Text File
17.4.3
Refreshing the OBIEE Lineage From Existing Exports
17.5
Automating the Lineage Tasks
17.5.1
Configuring the Scripts
17.5.2
Automating Lineage Deployment
17.5.3
Automating Lineage Refresh
17.6
Using the Lineage in OBIEE Dashboards
17.6.1
Viewing Execution Statistics
17.6.2
Viewing and Filtering Lineage Data
17.6.3
Using the Dashboard
17.6.4
Using Lineage and Hierarchy
17.6.5
Using Contextual Lineage
18
Oracle Hyperion Planning
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 Hyperion Planning Adapter
18.3.1
Setting up Adapter for ODI Studio
18.3.2
Setting up Adapter for ODI Standalone Agent
18.4
Setting up the Topology
18.4.1
Creating an Hyperion Planning Data Server
18.4.2
Creating an Hyperion Planning Physical Schema
18.5
Creating and Reverse-Engineering a Planning Model
18.5.1
Create a Planning Model
18.5.2
Reverse-engineer a Planning Model
18.6
Designing a Mapping
18.6.1
Loading Metadata
18.6.2
Loading Data
18.6.3
Load Options
18.7
Datastore Tables and Data Load Columns
18.7.1
Accounts
18.7.2
Employee
18.7.3
Entities
18.7.4
User-Defined Dimensions
18.7.5
Attribute Dimensions
18.7.6
UDA
18.7.7
Data Load Columns
19
Oracle Hyperion Essbase
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 Hyperion Essbase Adapter
19.3.1
Setting up Adapter for ODI Studio
19.3.2
Setting up Adapter for ODI Standalone Agent
19.4
Setting up the Topology
19.4.1
Creating an Hyperion Essbase Data Server
19.4.2
Creating an Hyperion Essbase Physical Schema
19.5
Creating and Reverse-Engineering an Essbase Model
19.5.1
Create an Essbase Model
19.5.2
Reverse-engineer an Essbase Model
19.6
Designing a Mapping
19.6.1
Loading Metadata
19.6.2
Loading Data
19.6.3
Extracting Data
19.6.3.1
Data Extraction Methods for Essbase
19.6.3.2
Extracting Essbase Data
19.6.3.3
Extracting Members from Metadata
Part III Other Technologies
20
JMS
20.1
Introduction
20.1.1
Concepts
20.1.1.1
JMS Message Structure
20.1.1.2
Using a JMS Destination
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 a JMS Data Server
20.3.1.1
Creation of the Data Server
20.3.2
Creating a JMS Physical Schema
20.4
Setting Up an Integration Project
20.5
Creating and Defining a JMS Model
20.5.1
Create a JMS Model
20.5.2
Defining the JMS Datastores
20.6
Designing a Mapping
20.6.1
Loading Data from a JMS Source
20.6.2
Integrating Data in a JMS Target
20.7
JMS Standard Properties
20.7.1
Using JMS Properties
20.7.1.1
Declaring JMS Properties
20.7.1.2
Filtering on the Router
20.7.1.3
Filtering on the Client
20.7.1.4
Using Property Values as Source Data
20.7.1.5
Setting Properties when Sending a Message
21
JMS XML
21.1
Introduction
21.1.1
Concepts
21.1.1.1
JMS Message Structure
21.1.1.2
Using a JMS Destination
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 a JMS XML Data Server
21.3.1.1
Creation of the Data Server
21.3.2
Creating a JMS XML Physical Schema
21.4
Setting Up an Integration Project
21.5
Creating and Reverse-Engineering a JMS XML Model
21.5.1
Create a JMS XML Model
21.5.2
Reverse-Engineering a JMS XML Model
21.6
Designing a Mapping
21.6.1
Loading Data from a JMS XML Source
21.6.2
Integrating Data in a JMS XML Target
22
LDAP Directories
22.1
Introduction
22.1.1
Concepts
22.1.2
Knowledge Modules
22.2
Installation and Configuration
22.2.1
System Requirements
22.2.2
Technologic Specific Requirements
22.2.3
Connectivity Requirements
22.3
Setting up the Topology
22.3.1
Creating an LDAP Data Server
22.3.1.1
Creation of the Data Server
22.3.2
Creating a Physical Schema for LDAP
22.4
Setting Up an Integration Project
22.5
Creating and Reverse-Engineering an LDAP Directory
22.5.1
Create an LDAP Model
22.5.2
Reverse-Engineering an LDAP Model
22.6
Designing a Mapping
22.6.1
Loading Data from and to LDAP
22.6.1.1
Loading Data from an LDAP Directory
22.6.1.2
Loading Data to an LDAP Directory
22.6.2
Integrating Data in an LDAP Directory
22.7
Troubleshooting
23
Oracle TimesTen In-Memory Database
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 a TimesTen Data Server
23.3.1.1
Creation of the Data Server
23.3.2
Creating a TimesTen Physical Schema
23.4
Setting Up an Integration Project
23.5
Creating and Reverse-Engineering a TimesTen Model
23.5.1
Create a TimesTen Model
23.5.2
Reverse-engineer a TimesTen Model
23.6
Setting up Data Quality
23.7
Designing a Mapping
23.7.1
Loading Data from and to TimesTen
23.7.1.1
Loading Data from TimesTen
23.7.1.2
Loading Data to TimesTen
23.7.2
Integrating Data in TimesTen
24
Oracle GoldenGate
24.1
Introduction
24.1.1
Overview of the GoldeGate CDC Process
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
Working with the Oracle GoldenGate JKMs
24.3.1
Define the Topology
24.3.1.1
Define the Source Data Server
24.3.1.2
Create the Source Physical Schema
24.3.1.3
Define the Staging Server
24.3.1.4
Create the Staging Physical Schema
24.3.1.5
Define the Oracle GoldenGate Data Servers
24.3.1.6
Create the Oracle GoldenGate Physical Schemas
24.3.1.7
Create the Oracle GoldenGate Logical Schemas
24.3.2
Create the Replicated Tables
24.3.3
Set Up an Integration Project
24.3.4
Configure CDC for the Source Datastores
24.3.4.1
Create Oracle GoldenGate Physical Schemas from the model
24.3.5
Configure and Start Oracle GoldenGate Processes (Offline mode only)
24.3.6
Design Mappings Using Replicated Data
24.4
Advanced Configuration
24.4.1
Initial Load Method
24.4.2
Tuning Replication Performances
24.4.3
One Source Multiple Staging Configuration (Offline mode only)
24.5
Integrated Capture
24.5.1
Integrated Capture Deployment Options
24.5.2
Deciding Which Apply Method to Use
24.5.2.1
Nonintegrated Replicat
24.6
Using Different Capture and Apply Modes Together
24.7
Switching to Different Process Mode
24.8
Upgrading GoldenGate Classic Extract to Integrated
25
Oracle SOA Suite Cross References
25.1
Introduction
25.1.1
Concepts
25.1.1.1
General Principles
25.1.1.2
Cross Reference Table Structures
25.1.1.3
Handling Cross Reference Table Structures
25.1.2
Knowledge Modules
25.1.3
Overview of the SOA XREF KM Process
25.1.3.1
Loading Phase (LKM)
25.1.3.2
Integration and Cross-Referencing Phase (IKM)
25.1.3.3
Updating/Deleting Processed Records (LKM)
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
Working with XREF using the SOA Cross References KMs
25.3.1
Defining the Topology
25.3.2
Setting up the Project
25.3.3
Designing a Mapping with the Cross-References KMs
25.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.