Go to main content
1/273
Contents
Title and Copyright Information
Preface
Documentation Accessibility
Conventions
1
Oracle Data Integrator Studio Overview
2
Using the Online Help
2.1
About the Online Help
2.2
About the Help Center
2.3
Opening the Online Help
2.4
Searching the Documentation
3
Main Windows
3.1
About Oracle Data Integrator Studio
3.2
About the Online Help
3.3
Check for Updates Wizard
3.3.1
Step 1: Select update source
3.3.2
Step 2: Select updates to install
3.3.3
Step 3: View download progress
3.3.4
Step 4: View summary
3.4
Find ODI Object Navigator
3.4.1
Standard
3.4.2
Advanced
3.5
Log Window
3.6
Manage Libraries Dialog
3.7
New Gallery
3.8
Preferences Dialog
3.8.1
Preferences Dialog - Environment Page
3.8.2
Preferences Dialog - Environment - Log Page
3.8.3
Preferences Dialog - Code Editor Page
3.8.4
Preferences Dialog - Code Editor - Caret Behavior Page
3.8.5
Preferences Dialog - Code Editor - Display Page
3.8.6
Preferences Dialog - Code Editor - Fonts Page
3.8.7
Preferences Dialog - Code Editor - Line Gutter Page
3.8.8
Preferences Dialog - Code Editor - Syntax Colors Page
3.8.9
Preferences Dialog - Credentials Page
3.8.10
Preferences Dialog - Credentials - HTTP Keystore Tab Page
3.8.11
Preferences Dialog - Credentials - Username Token Tab Page
3.8.12
Preferences Dialog - Certificates - X509 Certificates Tab Page
3.8.13
Preferences Dialog - Credentials - STS Configuration Tab Page
3.8.14
Preferences Dialog - Diagrams - Annotation Page
3.8.15
Preferences Dialog - Http Analyzer
3.8.16
Preferences Dialog - ODI - System Page
3.8.17
Preferences Dialog - ODI - System - Agent Page
3.8.18
Preferences Dialog - ODI - System - Concurrent Development Page
3.8.19
Preferences Dialog - ODI - System - Groovy Page
3.8.20
Preferences Dialog - ODI - System - Reports Page
3.8.21
Preferences Dialog - ODI - System - Scenarios Page
3.8.22
Preferences Dialog - ODI - User Interface Page
3.8.23
Preferences Dialog - ODI - User Interface - Designer Page
3.8.24
Preferences Dialog - ODI - User Interface - Operator Page
3.8.25
Preferences Dialog - ODI - User Interface - Topology Page
3.8.26
Preferences Dialog - ODI - User Interface - Versioning
3.8.27
Preferences Dialog - ODI - User Interface - Versioning - Subversion Page
3.8.28
Preferences Dialog - Web Browser and Proxy - Web Browsers
3.8.29
Preferences Dialog - Web Browser and Proxy - Proxy Page
3.8.30
Preferences Dialog - Web Browser and Proxy - Internet Files Page
3.9
Property Inspector
3.10
Save Files
3.11
Save to File
3.12
Thumbnail
3.13
Unable to Connect Dialog
3.14
Unable to Save Dialog
3.15
Update Center Dialog
3.16
Windows Dialog
4
Navigator-Independent Editors, Wizards, and Dialogs
4.1
Add ODI Objects to Subversion Dialog
4.2
Add Open Tool Dialog
4.3
Change Current ODI User Password Dialog
4.4
Change Wallet Password Dialog
4.5
Clean Stale Sessions Dialog
4.6
Clean Stale Sessions Results Dialog
4.7
Compare with Export File Dialog
4.8
Configure Subversion Repository with ODI Dialog
4.9
Connect to Debug Session... Dialog
4.10
Contents Of Deployment Archive Dialog
4.11
Create Branch From Tag Dialog
4.12
Create Default SVN Project Structure Dialog
4.13
Create Deployment Archive with All Repository Objects Dialog
4.14
Create Deployment Archive from Selected Objects Dialog
4.15
Create Deployment Archive from VCS Label Dialog
4.16
Create Full Tag Dialog
4.17
Create New Model and Topology Objects Wizard
4.17.1
Step 1 - Create a new model and associate it with a new or existing logical schema and a new or existing context
4.17.2
Step 2 - Associate the new model with a new or existing data server
4.17.3
Step 3 - Associate the new model with a new or existing physical schema
4.18
Big Data Configurations Wizard
4.18.1
Step 1 - Specify the general settings
4.18.2
Step 2 - Configure the data servers for selected Big Data technologies
4.18.3
Step 3 - Validate all the settings
4.19
Create Partial Tag Dialog
4.20
Select Tag Dialog
4.21
Create Version Dialog
4.22
Datasources Deployment Dialog
4.23
Debugger
4.23.1
Debug Variables
4.23.2
Debug Breakpoint
4.23.2.1
Breakpoint Properties
4.23.3
Debug Session
4.23.4
Debug Session Threads
4.23.5
Debug Data
4.24
Deployment Archive Details Dialog
4.25
Display Options Dialog
4.26
Drivers Dialog
4.27
Enter Export Key Dialog for Multiple Files Import
4.28
Enter Export Key Dialog for Single File Import
4.29
Enter Export Key Dialog to Compare with Export File
4.30
Enter Wallet Password Dialog
4.31
Export Key fields in Export Dialog
4.32
Export of <Object> Dialog
4.33
Export of <Version> Dialog
4.34
Export Multiple Objects Dialog
4.35
Export Selection Dialog
4.36
Groovy Editor
4.37
Import Report
4.38
Import Scenario Dialog
4.39
Import Selection Dialog
4.40
Initialize Deployment Repository Dialog
4.41
Inventory Dialog
4.42
Master Repository Creation Wizard
4.42.1
Step 1 - Repository Connection
4.42.2
Step 2 - Authentication
4.42.3
Step 3 - Password Storage
4.43
Master Repository Import Wizard
4.43.1
Step 1 - Repository Connection
4.43.2
Step 2 - Password Storage
4.44
Merge Dialog
4.45
Merge Results Window
4.45.1
Merge Object Selection
4.45.2
Merge Conflict Resolution
4.46
Merge Summary Dialog
4.47
Merge Summary Selection Dialog
4.48
New Password Dialog
4.49
New Wallet Password Dialog
4.50
OPSS Enterprise Roles Dialog
4.51
Oracle Data Integrator Login Dialog
4.52
Patch Deployment Repository Dialog
4.53
Preferences Dialog
4.54
Recover Password Storage Wizard
4.55
Release Tag Selection Dialog
4.56
Release Tag Wizard
4.56.1
Step 1
4.56.2
Step 2
4.57
Repository Connection Information Editor
4.58
Restart Debug Session Dialog
4.59
Restart Session Dialog
4.60
Restore Deleted ODI Object
4.61
Restore Object from Subversion Repository Dialog
4.62
Rollback the Patch Dialog
4.63
Search Messages Log Dialog
4.64
Select Version Control Management System Dialog
4.65
Simulation Report
4.66
Smart Export Dialog
4.67
Smart Export Report
4.68
Smart Import Report
4.69
Smart Import Wizard
4.69.1
Step 1 - File Selection
4.69.2
Step 2 - Import Actions
4.69.3
Step 3 - Summary
4.70
Start Debug Session... Dialog
4.71
Stop Session Dialog
4.72
Structure Pane
4.73
SVN Connection Dialog
4.74
Switch Authentication Mode Wizard
4.74.1
Step 1 - Login
4.74.2
Step 2 - Credentials
4.75
Password Storage Wizard
4.75.1
Step 1 - Login
4.75.2
Step 2 - Password Storage
4.76
Switch Repository Compatibility Mode Wizard
4.77
Target Object Selection Dialog
4.78
URL Examples Dialog
4.79
Version Browser Dialog
4.80
Version Compare Results Window
4.81
Version History Dialog
4.82
Version Selection Dialog
4.83
Version Tree Editor
4.84
Version Tree Filter Dialog
5
Operator Navigator Editors
5.1
Define Filter Dialog
5.2
Export the Log Dialog
5.3
Import of the Log Dialog
5.4
Load Plan and Scenario Folder
5.4.1
Definition
5.5
Load Plan Run Editor
5.5.1
Execution
5.5.2
Load Plan
5.5.3
Steps
5.5.4
Variables
5.6
Operator Navigator
5.7
Purge Log Dialog
5.8
Remove Temporary Objects Dialog
5.9
Regenerate Scenario Dialog
5.10
Restart Load Plan Dialog
5.11
Scenario Variable Editor
5.11.1
Definition
5.12
Session Editor
5.12.1
Definition
5.12.2
Steps
5.12.3
Blueprint
5.12.4
Details
5.13
Session Folder Editor
5.13.1
Definition
5.14
Session Step Editor
5.14.1
Definition
5.14.2
Details
5.15
Session Task Editor
5.15.1
Definition
5.15.2
Code
5.15.3
Connection
5.15.4
Details
5.16
Session Variable Editor
5.16.1
Definition
5.16.2
History
5.17
Start Load Plan Dialog
5.18
Stop Load Plan Dialog
6
Designer Navigator Editors
6.1
Add Step Wizard
6.1.1
Step 1 - Select a type and location of the step
6.1.2
Step 2 - Select Step Name (for Serial, Parallel, Else, and Exception steps)
6.1.3
Step 2 - Select Scenario (for Run Scenario steps)
6.1.4
Step 2 - Select Variable to Evaluate (for Case steps)
6.1.5
Step 2 - When Clause Evaluation (for When steps)
6.1.6
Step 3 - Select Scenario Variables (for Run Scenario steps)
6.2
Attribute Editor
6.2.1
Definition
6.2.2
Description
6.2.3
Control
6.3
Attribute Matching Dialog
6.4
Condition Editor
6.4.1
Definition
6.4.2
Control
6.5
Connection Path Selection Dialog
6.6
Create a Lookup or a Join Dialog
6.7
Create <Version> Dialog
6.8
Cross Reference Editor
6.8.1
Definition
6.9
Datastore Editor
6.9.1
Definition
6.9.2
Attributes
6.9.3
Files
6.9.4
Journalizing
6.9.5
Partitions
6.9.6
Services
6.9.7
View Data Editor
6.9.8
Data... Editor
6.10
Designer Navigator
6.11
Diagram Editor
6.11.1
Definition
6.11.2
Diagram
6.12
Edit Choice Dialog
6.13
Export All Scenarios Dialog
6.14
Export Work Repository Dialog
6.15
Expression Editor
6.16
Fetch Data for Reverse Engineering Dialog
6.17
Filter Editor
6.17.1
Definition
6.18
Folder Editor
6.18.1
Definition
6.18.2
Version
6.19
Generate DDL Editor
6.20
Generate Mappings IN Editor
6.21
Generate Mappings OUT Editor
6.22
New <Object> Dialog
6.23
Import <Object> Dialog
6.24
Import Work Repository Dialog
6.25
Key Editor
6.25.1
Description
6.25.2
Attributes
6.25.3
Control
6.26
Knowledge Module Editor
6.26.1
Definition
6.26.2
Tasks
6.26.3
Options
6.26.4
Version
6.27
Load Plan Editor
6.27.1
Definition
6.27.2
Steps
6.27.2.1
Common Properties
6.27.2.2
Serial Step Properties
6.27.2.3
Parallel Step Properties
6.27.2.4
Run Scenario Step Properties
6.27.2.5
Case Step Properties
6.27.2.6
When Step Properties
6.27.2.7
Else Step Properties
6.27.3
Exceptions
6.27.4
Variables
6.28
Locked Objects Dialog
6.29
Lookup Scenario Dialog
6.30
Lookup Variable Dialog
6.31
Mapping Editor
6.31.1
Connector Points
6.32
Reusable Mapping Editor
6.32.1
Reusable Mapping Editor Logical Tab
6.33
11
g
-Compatible Mapping Editor
6.34
Mapping Editor Overview Tab
6.34.1
Definition Tab
6.34.2
Execution Tab
6.34.3
Scenarios Tab
6.34.4
Markers Tab
6.34.5
Memo Tab
6.34.6
Version Tab
6.34.7
Privileges Tab
6.34.8
Flexfields Tab
6.35
Mapping Editor Concepts
6.35.1
Component Styles
6.35.2
Component Attributes
6.36
Mapping Editor Validation Results Tab
6.37
Mapping Editor Logical Tab
6.37.1
Component Palette
6.37.1.1
11
g
Compatible Dataset Component
6.37.1.2
Aggregate Component
6.37.1.3
Dataset Component
6.37.1.4
Distinct Component
6.37.1.5
Expression Component
6.37.1.6
Filter Component
6.37.1.7
Flatten Component
6.37.1.8
Input and Output Signature Components
6.37.1.9
Jagged Component
6.37.1.10
Join Component
6.37.1.11
Lookup Component
6.37.1.12
Pivot Component
6.37.1.13
Reusable Mapping Component
6.37.1.14
Set Component
6.37.1.15
Sort Component
6.37.1.16
Split Component
6.37.1.17
Subquery Filter Component
6.37.1.18
Table Function Component
6.37.1.19
Unpivot Component
6.37.2
Datastore Component
6.37.3
Mapping Diagram
6.38
Mapping Editor Physical Tab
6.38.1
Properties
6.38.1.1
Physical Mapping Design Tab
6.38.2
Source Group and Target Group Properties
6.38.2.1
Execution Unit
6.38.3
Access Point Properties
6.38.4
Physical Component Properties
6.39
Marker Group Editor
6.39.1
Definition
6.40
Model Editor
6.40.1
Definition
6.40.2
Reverse Engineer
6.40.3
Selective Reverse Engineering
6.40.4
Control
6.40.5
Journalizing
6.40.6
Journalized Tables
6.40.7
Services
6.41
Model Folder Editor
6.41.1
Definition
6.42
Modify Case Step
6.43
Modify Run Scenario Step 1
6.44
Modify Run Scenario Step 2
6.45
New Mapping Dialog
6.46
New Scenario Dialog
6.47
Package Editor
6.47.1
Definition
6.47.2
Execution
6.47.3
Scenarios
6.47.4
Diagram
6.47.4.1
General
6.47.4.2
Additional Variables
6.47.4.3
Command
6.47.4.4
Advanced
6.47.4.5
Options
6.48
Procedure Editor
6.48.1
Definition
6.48.2
Tasks
6.48.3
Options
6.48.4
Execution
6.49
Project Editor
6.49.1
Definition
6.49.2
Markers
6.49.3
Memo
6.49.4
Version
6.49.5
Privileges
6.49.6
Flexfields
6.50
Run <Object> Dialog
6.51
Reference Editor
6.51.1
Definition
6.51.2
Columns
6.51.3
Expression
6.51.4
Behavior
6.51.5
Control
6.52
Replace Object Dialog
6.53
Sequence Editor
6.53.1
Definition
6.53.2
Values
6.54
Scheduling Editor
6.54.1
Definition
6.54.2
Execution Cycle
6.54.3
Variables
6.55
Run... Dialog
6.56
Scenario Editor
6.56.1
Definition
6.56.2
Variables
6.57
Scenario Generation Editor
6.58
Scenario Execution Report Editor
6.58.1
Definition
6.59
Scenario Variable Dialog
6.60
Shortcut Conflicts Dialog
6.61
Shortcut Editor
6.61.1
Definition
6.61.2
Execution
6.62
Sign In Dialog
6.63
Label Editor
6.63.1
Definition
6.64
Path Selection Dialog
6.65
Step Report Editor
6.65.1
Definition
6.66
Sub-Model Editor
6.66.1
Definition
6.66.2
Distribution
6.67
Synchronizing Label Dialog
6.68
Target Load Order Dialog
6.69
User Function Editor
6.69.1
Definition
6.69.2
Implementations
6.70
Variable Editor
6.70.1
Definition
6.70.2
Refreshing
6.70.3
History
6.71
HTTP Analyzer
6.72
HTTP Analyzer Test Window
6.72.1
HTTP Analyzer Test Window
6.72.2
HTTP Analyzer Request/Response Area
6.73
HTTP Analyzer Instances Window
6.74
HTTP Analyzer Dialog
6.75
Proxy Settings Dialog
6.76
Rule Settings Dialog
6.77
HTTP Keystore Dialog
6.78
Rename Credentials Dialog
6.79
Select Web Service Description Dialog
6.80
Certificate Error Dialog
6.81
Dimension and Cube Accordion
6.82
Dimension Editor
6.82.1
Definition Tab
6.82.2
Levels Tab
6.82.2.1
Levels of Dimension
6.82.2.2
Level Attributes Table
6.82.2.3
Natural Key Members Table
6.82.2.4
Parent Level References Table
6.82.2.5
Parent Level Reference Key Members Table
6.82.3
Hierarchies Tab
6.82.3.1
Hierarchies Table
6.82.3.2
Hierarchy Members Table
6.82.3.3
Skip Levels Table
6.83
Cube Editor
6.83.1
Definition Tab
6.83.1.1
Binding Table
6.83.2
Details Tab
6.83.2.1
Dimensions Table
6.83.2.2
Key Binding Table
6.83.2.3
Measures Table
6.84
Dimension Component Properties
6.84.1
General Properties
6.84.2
History Properties
6.85
Cube Component Properties
6.85.1
General Properties
6.85.2
Target Properties
6.85.3
Connector Points
6.85.4
Cube Component Attribute Properties
6.85.4.1
Target Properties
7
Topology Navigator Editors
7.1
Action Editor
7.1.1
Definition
7.1.2
Details
7.1.3
Lines
7.2
Action Group Editor
7.2.1
Definition
7.3
Change Work Repository Password Dialog
7.4
Context Editor
7.4.1
Definition
7.4.2
Agents
7.4.3
Schemas
7.5
Create ODI Work Repository Wizard
7.5.1
Step 1 - Specify ODI Work Repository Connection Properties
7.5.2
Step 2 - Specify ODI Work Repository Properties
7.5.3
Step 3 - Specify the Password of the ODI Work Repository to attach
7.5.4
Step 4 - Specify the name of the ODI Work Repository to attach
7.6
Data Server Editor
7.6.1
Definition
7.6.2
JDBC
7.6.3
JNDI
7.6.4
On Connect/Disconnect
7.6.5
Properties
7.6.6
DataSources
7.6.7
JAgent
7.7
Datatype Editor
7.7.1
Definition
7.7.2
Converted to
7.7.3
Converted from
7.8
Enterprise Scheduler Dialog
7.9
Export Execution Environment Dialog
7.10
Export Logical Topology Dialog
7.11
Export Master Repository Dialog
7.12
Export Topology Dialog
7.13
Import Execution Environment Dialog
7.14
Import Logical Topology Dialog
7.15
Import Master Repository Dialog
7.16
Import Topology Dialog
7.17
Index Type Editor
7.17.1
Definition
7.18
Language Editor
7.18.1
Definition
7.19
Language Element Editor
7.19.1
Definition
7.19.2
Implementation
7.20
Logical Agent Editor
7.20.1
Definition
7.21
Logical Oozie Engine
7.21.1
Definition
7.22
Logical Schema Editor
7.22.1
Definition
7.23
Master Repository Editor
7.23.1
Definition
7.24
New Action Line Dialog
7.25
Oozie Runtime Engine
7.25.1
Definition
7.25.2
Properties
7.26
Physical Agent Editor
7.26.1
Definition
7.26.2
Datasources
7.26.3
Properties
7.26.4
Load balancing
7.27
Physical Schema Editor
7.27.1
Definition
7.27.2
Context
7.27.3
Process Definition
7.28
Schedule Dialog
7.29
Select Repository Dialog
7.30
Select Repositories Dialog
7.31
Server Template Generation Wizard
7.31.1
Step 1 - Agent Information
7.31.2
Step 2 - Libraries and Drivers
7.31.3
Step 3 - Datasources
7.31.4
Step 4 - Template Target and Summary
7.32
Sub-language Editor
7.32.1
Definition
7.33
Technical Environment Dialog
7.34
Technology Editor
7.34.1
Definition
7.34.2
SQL
7.34.3
Advanced
7.34.4
Language
7.35
Test Connection Dialog
7.36
Test Connection Dialog for Enterprise Scheduler
7.37
Topology Navigator
7.38
Work Repository Editor
7.38.1
Definition
8
Security Navigator Editors
8.1
Change ODI User Password Dialog
8.2
Clean Up Security Settings Dialog
8.3
Export Security Settings Dialog
8.4
Import Security Settings Dialog
8.5
Method Editor
8.5.1
Definition
8.6
Object Editor
8.6.1
Definition
8.6.2
Flexfields
8.7
Object Instance Editor
8.7.1
Security
8.7.2
Version
8.8
Password Policies Security Settings Dialog
8.9
Profile Editor
8.9.1
Definition
8.10
Profile Method Editor
8.10.1
Definition
8.11
Roles Editor
8.11.1
Definition
8.12
Security Navigator
8.13
User Editor
8.13.1
Definition
8.13.2
Authorization
8.14
User Connections Dialog
8.15
User Method Editor
8.15.1
Definition
Scripting on this page enhances content navigation, but does not change the content in any way.