Table of Contents
- Title and Copyright Information
- Abstract
- Preface
- 1 Getting Started with Oracle Data Integrator Cloud
- Part I Oracle Data Integrator Cloud Architecture, Components, and Workflows
-
Part II Creating Service Instances for Oracle Data Integrator Cloud
- 5 Creating an Object Storage Classic Container
- 6 Provisioning Oracle Database Cloud Service Instances
-
7
Provisioning and Accessing Oracle Data Integrator Cloud Service Instance
- Provisioning the Oracle Java Cloud Instance
- Connecting to the Oracle Java Cloud Instance Environment Using SSH
- Installing Oracle Data Integrator
- Apply Patch 26669648 to Update ODI to version 12.2.1.3.1.
- Locating your Database Prefix
- Creating Oracle Data Integrator Repository using the Repository Creation Utility (RCU)
- Updating the Java Cloud Instance Domain
- Creating Agents in the Master Repository Using Oracle Data Integrator Studio
- Starting the Administration Server
- Post-Configuration Tasks
- Starting the Managed Server
-
8
Provisioning and Accessing the Clustered Oracle Data Integrator Cloud Instance
- Provisioning the Clustered Oracle Java Cloud Instance
- Installing Oracle Data Integrator
- Apply Patch 26669648 to Update ODI to version 12.2.1.3.1.
- Installing Oracle Data Integrator on the Second Oracle Java Cloud Instance Node
- Locating your Database Prefix
- Creating Oracle Data Integrator Repository using the Repository Creation Utility (RCU)
- Updating the Clustered Oracle Java Cloud Instance Domain
- Creating Agents in the Master Repository Using Oracle Data Integrator Studio
- Starting the Administration Server
- Post-Configuration Tasks
- Starting the Managed Server
-
Part III Integrating Data
- 9 Understanding Oracle Data Integrator Concepts
- 10 Typical Integration Projects
- 11 Setting up a Topology
- 12 Creating and Using Data Models and Datastores
-
13
Creating and Using Mappings
- Introduction to Mappings
- Creating a Mapping
-
Using Mapping Components
- The Expression Editor
- Source and Target Datastores
- Creating Multiple Targets
- Adding a Reusable Mapping
- Creating Aggregates
- Creating Distincts
- Creating Expressions
- Creating Filters
- Creating Joins and Lookups
- Creating Pivots
- Creating Sets
- Creating Sorts
- Creating Splits
- Creating Subquery Filters
- Creating Table Functions
- Creating Unpivots
- Creating Flatten Components
- Creating Jagged Components
- Creating a Mapping Using a Dataset
-
Physical Design
- About the Physical Mapping Diagram
- Selecting LKMs, IKMs and CKMs
- Configuring Execution Locations
- Adding Commands to be Executed Before and After a Mapping
- Configuring In-Session Parallelism
- Configuring Parallel Target Table Load
- Configuring Temporary Indexes
- Configuring Journalizing
- Configuring Extraction Options
- Creating and Managing Physical Mapping Designs
- Reusable Mappings
- Editing Mappings Using the Property Inspector and the Structure Panel
- Flow Control and Static Control
- Designing E-LT and ETL-Style Mappings
- 14 Creating and Using Packages
- 15 Using Scenarios
- 16 Using Load Plans
-
17
Running Integration Processes
- Understanding ODI Executions
- Executing Mappings, Procedures, Packages and Model Operations
- Executing a Scenario
- Restarting a Session
- Stopping a Session
- Executing a Load Plan
- Restarting a Load Plan Run
- Stopping a Load Plan Run
- Scheduling Scenarios and Load Plans
- Simulating an Execution
-
Managing Executions Using Web Services
- Introduction to Run-Time Web Services
- Executing a Scenario Using a Web Service
- Monitoring a Session Status Using a Web Service
- Restarting a Session Using a Web Service
- Executing a Load Plan Using a Web Service
- Stopping a Load Plan Run Using a Web Service
- Restarting a Load Plan Instance Using a Web Service
- Monitoring a Load Plan Run Status Using a Web Service
- Accessing the Web Service from a Command Line
- Using the Run-Time Web Services with External Authentication
- Using WS-Addressing
- Using Asynchronous Web Services with Callback
- 18 Debugging Integration Processes
- 19 Monitoring Integration Processes
- 20 Using Oracle Data Integrator Console
- 21 Managing Environments
- 22 Life Cycle Management in Oracle Data Integrator
- Part IV Maintaining Your Oracle Data Integrator Cloud Service