Table of Contents
- Title and Copyright Information
- Preface
-
Part I Before You Begin
-
1
What is Oracle Data Integration Platform Cloud?
- Why Use Oracle Data Integration Platform Cloud?
- Data Integration Platform Cloud Certifications
- High Level Concepts in Oracle Data Integration Platform Cloud
- Tour Data Integration Platform Cloud
- Data Integration Platform Cloud versus Data Integration Platform Cloud Classic
- Data Integration Platform Cloud Architecture
- Data Integration Platform Cloud Classic Architecture
- What are the Oracle Data Integration Platform Cloud Editions?
-
2
Get Started
- Before You Begin with Oracle Data Integration Platform Cloud
- How to Begin with Oracle Data Integration Platform Cloud
- Access Oracle Data Integration Platform Cloud
- Assign Oracle Data Integration Platform Cloud Roles
-
Create Instances for Data Integration Platform Cloud
- Create Data Integration Platform Cloud Instances
- QuickStart Data Integration Platform Cloud Classic Instances
-
Create Data Integration Platform Cloud Classic Instances
- Find Your User-Managed Services and Backup Location
- Create an Object Storage Classic Container
- Provision Oracle Database and Exadata Cloud Instances
- Provision and Access an Oracle Data Integration Platform Cloud Classic Service Instance
-
Configure VPN as a Service (VPNaaS)
- Create Public DVLBR and Mapping IP Networks
-
Set up VPNaaS
- OPC – IP Network and DIPC Instance Check
- OPC – Provision a VPN Connection under VPNaaS
- Create and Configure On-Premises Third-Party VPN Device
- OPC and On-Premises – Verify Tunnel Status is Up
- OPC and On-Premises – Verify VPN Connection
- Configure DIPC Connection to On-Premises Database Server as a Data Source
- Understand the Information on the Home page
-
3
Before You Perform Tasks in Data Integration Platform Cloud
-
Set up an Agent
- What is an Agent?
- Agent Certifications
- Import a Client Certificate to the Agent
- Download the Agent Package
- Before You Register Your Agent
- Add Your DIPC Agent as a Confidential Application
- Register Your Agent
- Set Your Agent Properties
- Configure Agent Secure Sockets Layer (SSL)
- Start and Stop the Agent
- Monitor Your Agents
- Create a Connection
- Set up Default Connections
- Understand the Catalog
-
Set up an Agent
-
1
What is Oracle Data Integration Platform Cloud?
-
Part II Perform Tasks in Data Integration Platform Cloud
- 4 Synchronize Data
- 5 ODI Execution
- 6 Replicate Data
- 7 Add Data to Data Lake
- 8 Prepare Data
- 9 Monitor Jobs
- 10 Create Policies
- 11 Maintain Oracle Data Integration Platform Cloud
-
Part III Perform Tasks on Hosted VMs
- 12 Replicate Data to Oracle Autonomous Data Warehouse Cloud
-
13
Analyzing Data Streams
- Planning Your Stream Analytics Installation
- Provisioning Oracle Event Hub and Big Data Cloud Instances
- Installing Oracle Stream Analytics
- Configuring Stream Analytics
- Upgrading Oracle Stream Analytics
- Administering Stream Analytics
-
Working with Stream Analytics
- Home Page
- About the Catalog
- Typical Workflow for Administering Stream Analytics
- Creating a Connection
- Cache Configuration for Coherence
- Creating a Stream
- Creating a Reference
- Creating a Dashboard
- Creating a Cube
- Exploring a Cube
- Creating a Target
- Creating a Geo Fence
- Creating a Predictive Model
- Creating a Custom Jar
- Creating a Pipeline
- Configuring a Pipeline
- Exporting and Importing a Pipeline and Its Dependent Artifacts
- Publishing a Pipeline
- Using the Topology Viewer
- Working with Patterns
- Understanding Expression Builder Functions
-
14
Integrating Data
- Connecting to ODI Studio with VNC Server
- Setting Up a Topology
- Creating and Using Data Models and Datastores
-
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
- Creating and Using Packages
- Controlling Concurrent Execution of Scenarios and Load Plans
- Using Scenarios
- Using Load Plans
-
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
-
Debugging Integration Processes
- About Sessions and Blueprints
- Introduction to Debugging in the Session Editor
- Starting a Debugging Session
- Stepping through a Blueprint in the Session Editor
- Using the Debugging Cursor
- Managing Debugging Sessions
- Monitoring Integration Processes
- Using Oracle Data Integrator Console
-
15
Validating Data Quality
- Understanding the Software Components
- Understanding Key Concepts of Enterprise Data Quality
- Using Enterprise Data Quality
-
Understanding the Key Tasks In EDQ
- About Snapshots
- About Processes
- About External Tasks
- About Exports
- Creating a Job
- Editing a Job
- About Exports
- Deleting a Job
- Using Job Triggers
- Creating and Managing Processors
-
Part IV Reference Information
- 16 Configure Remote Agents
-
17
Data Source Connection Details
- Create a File Connection
- Create a Kafka Connect Connection
- Create a Microsoft SQL Server Connection
- Create a MySQL Connection
- Create an Autonomous Data Warehouse Cloud (ADWC) Connection
- Create an Oracle BI Cloud Connector Connection
- Create a PDB Connection
- Create an Oracle Database Connection
- Create an Oracle Object Storage Connection
- Create an Oracle Object Storage Classic Connection
- Create an Amazon S3 Connection
- Create a Salesforce Connection
- 18 Configure GoldenGate
-
Appendix
- A Terminology
- B What's Certified for Hosted VM Tasks
-
C
Frequently Asked Questions for Data Integration Platform
- General Questions about Oracle Data Integration Platform Cloud
- Service Editions
- Oracle Data Integration Platform Cloud User Roles
- Create an Instance (Provision)
- Data source information
- Service Details and Native Applications on the VMs
- Load Balancers
- Security
- Agents
- Data Synchronization
- Deliver Data to Oracle Autonomous Data Warehouse Cloud
- Maintain Your Service Instances
- Backup and Recovery
- Storage Administration
- D Kafka Connect Client Libraries