Table of Contents
- Title and Copyright Information
- Preface
- 1 Introduction
-
Part I Databases, Files, and XML
- 2 Oracle Database
-
3
Oracle Autonomous Data Warehouse Cloud
- 3.1 Introduction
- 3.2 Prerequisites
- 3.3 Setting up the Topology
- 3.4 Creating and Reverse-Engineering an Oracle Model
- 3.5 Designing a Mapping
- 3.6 Best Practices for Working with ADWC
- 4 Files
- 5 Generic SQL
- 6 XML Files
- 7 Complex Files
- 8 Microsoft SQL Server
- 9 Microsoft Excel
- 10 Microsoft Access
- 11 Netezza
- 12 Teradata
- 13 Hypersonic SQL
- 14 IBM Informix
-
15
IBM DB2 for iSeries
- 15.1 Introduction
- 15.2 Installation and Configuration
- 15.3 Setting up the Topology
- 15.4 Setting Up an Integration Project
- 15.5 Creating and Reverse-Engineering an IBM DB2/400 Model
- 15.6 Setting up Changed Data Capture
- 15.7 Setting up Data Quality
- 15.8 Designing a Mapping
- 15.9 Specific Considerations with DB2 for iSeries
- 15.10 Troubleshooting
- 16 IBM DB2 UDB
- 17 Salesforce.com
- 18 Sybase IQ
- 19 Other Databases
-
Part II Business Intelligence
- 20 Oracle Business Intelligence Enterprise Edition
- 21 Oracle Business Intelligence Cloud Service
- 22 Oracle Hyperion Planning
- 23 Oracle Hyperion Essbase
-
Part III Other Technologies
- 24 JMS
- 25 JMS XML
- 26 LDAP Directories
- 27 Oracle TimesTen In-Memory Database
-
28
Oracle GoldenGate
- 28.1 Introduction
- 28.2 Installation and Configuration
-
28.3
Working with the Oracle GoldenGate JKMs
-
28.3.1
Define the Topology
- 28.3.1.1 Define the Source Data Server
- 28.3.1.2 Create the Source Physical Schema
- 28.3.1.3 Define the Staging Server
- 28.3.1.4 Create the Staging Physical Schema
- 28.3.1.5 Define the Oracle GoldenGate Data Servers
- 28.3.1.6 Create the Oracle GoldenGate Physical Schemas
- 28.3.1.7 Create the Oracle GoldenGate Logical Schemas
- 28.3.2 Create the Replicated Tables
- 28.3.3 Set Up an Integration Project
- 28.3.4 Configure CDC for the Source Datastores
- 28.3.5 Configure and Start Oracle GoldenGate Processes (Offline mode only)
- 28.3.6 Design Mappings Using Replicated Data
-
28.3.1
Define the Topology
- 28.4 Advanced Configuration
- 28.5 Integrated Capture
- 28.6 Using Different Capture and Apply Modes Together
- 28.7 Switching to Different Process Mode
- 28.8 Upgrading GoldenGate Classic Extract to Integrated
- 29 Oracle SOA Suite Cross References
- 30 Oracle Object Storage
- 31 Oracle Storage Cloud Service
-
Part IV Applications
- 32 Oracle Enterprise Resource Planning Cloud
- 33 Oracle Marketing Cloud
- 34 Oracle Sales Cloud
- 35 Oracle Service Cloud
-
36
Oracle Business Intelligence Cloud Connector
- 36.1 Introduction
- 36.2 Installation and Configuration
- 36.3 Setting up the Topology
- 36.4 Creating and Reverse-Engineering an Oracle BI Cloud Connector Model
- 36.5 Designing a Mapping
- 37 Oracle NetSuite
- 38 Other Applications
- Part V 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.3 Installation and Configuration
- A.4 SQL Syntax
- 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.3 Installation and Configuration
- B.4 Detailed Driver Commands
- B.5 SQL Syntax
- B.6 JDBC API Implemented Features
- B.7 Rich Metadata
-
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
- C Oracle Data Integrator Driver for Complex Files Reference
-
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