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
-
Part II Business Intelligence
- 19 Oracle Business Intelligence Enterprise Edition
- 20 Oracle Business Intelligence Cloud Service
- 21 Oracle Hyperion Planning
- 22 Oracle Hyperion Essbase
-
Part III Other Technologies
- 23 JMS
- 24 JMS XML
- 25 LDAP Directories
- 26 Oracle TimesTen In-Memory Database
-
27
Oracle GoldenGate
- 27.1 Introduction
- 27.2 Installation and Configuration
-
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.5 Configure and Start Oracle GoldenGate Processes (Offline mode only)
- 27.3.6 Design Mappings Using Replicated Data
-
27.3.1
Define the Topology
- 27.4 Advanced Configuration
- 27.5 Integrated Capture
- 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
- 29 Oracle Object Storage
- 30 Oracle Storage Cloud Service
-
Part IV SaaS Applications
- 31 Oracle Enterprise Resource Planning Cloud
- 32 Oracle Marketing Cloud
- 33 Oracle Sales Cloud
- 34 Oracle Service Cloud
-
35
Oracle Business Intelligence Cloud Connector
- 35.1 Introduction
- 35.2 Installation and Configuration
- 35.3 Setting up the Topology
- 35.4 Creating and Reverse-Engineering an Oracle BI Cloud Connector Model
- 35.5 Designing a Mapping
- 36 Oracle NetSuite
- 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