Oracle Data Integrator 12c Integration And Administration
Oracle Data Integrator 12c:Integration and AdministrationStudent Guide – Volume ID82167GC20Edition 2.0 August 2016 D97384Learn more from Oracle University at oracle.com/education/
AuthorsCopyright 2016, Oracle and/or its affiliates. All rights reserved.Elio BonazziDisclaimerSteve FriedbergThis document contains proprietary information and is protected by copyright andother intellectual property laws. You may copy and print this document solely for yourown use in an Oracle training course. The document may not be modified or altered inany way. Except where your use constitutes "fair use" under copyright law, you maynot use, share, download, upload, copy, print, display, perform, reproduce, publish,license, post, transmit, or distribute this document in whole or in part without theexpress authorization of Oracle.Technical Contributorsand ReviewersJulien TestutAlex KotopoulisEditorsThe information contained in this document is subject to change without notice. If youfind any problems in the document, please report them in writing to: Oracle University,500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is notwarranted to be error-free.Raj KumarVijayalakshmi NarasimhanRestricted Rights NoticeNikita AbrahamIf this documentation is delivered to the United States Government or anyone usingthe documentation on behalf of the United States Government, the following notice isapplicable:Graphic DesignerSeema BopaiahPublishersU.S. GOVERNMENT RIGHTSThe U.S. Government’s rights to use, modify, reproduce, release, perform, display, ordisclose these training materials are restricted by the terms of the applicable Oraclelicense agreement and/or the applicable U.S. Government contract.Giri VenugopalTrademark NoticeJoseph FernandezOracle and Java are registered trademarks of Oracle and/or its affiliates. Other namesmay be trademarks of their respective owners.
Contents1Introduction to Integration and AdministrationCourse Objectives 1-2Lesson Objectives 1-3Agenda of Lessons 1-4Agenda 1-7Why Oracle Data Integrator? 1-8Conventional Integration Process: ETL 1-10Extract Load Transform (E-LT) 1-11ODI Architecture and Components 1-13ODI Architecture 1-14ODI Components: Overview 1-16Using ODI Studio 1-17Designer Navigator (Work Repository) 1-18Operator Navigator (Work Repository) 1-19Topology Navigator (Master Repository) 1-20Security Navigator (Master Repository) 1-21What Is an Agent? 1-22ODI Agents 1-23Three Types of Agents: Java EE, Standalone, Collocated Standalone 1-24Using the Three Types of Agents 1-25Standalone Agent: Example 1-26ODI Console 1-27Enterprise Manager FMW Console 1-28Management Pack for ODI for Enterprise Manager Cloud Control 1-29Management Pack for ODI for EM CC ODI Home Page 1-30Agenda 1-31ODI Repositories 1-32Master and Work Repositories 1-33Repository Setup: Example 1-35Repository Setup: Multiple Master Repositories 1-36Components: Global View 1-37Possible ODI Methodology 1-38Checklist of Practice Activities 1-39Starting Oracle Data Integrator 1-40Using Online Help 1-41iii
Quiz 1-42Summary 1-44Practice 1-1 Overview: Logging In and Using Help 1-452Administering ODI RepositoriesObjectives 2-2Agenda 2-3Initial Repository Administration Tasks 2-4Steps to Set Up the ODI Repositories 2-51. Run Repository Creation Utility 2-61a. Create Schemas 2-71b. Create Passwords and Tablespaces 2-82. Connect to the Master/Work Repository 3. Create a Wallet 2-9Connecting to the Master/Work Repository 2-10Exporting the Master Repository 2-11Importing the Master Repository 2-13Creating a Work Repository – 1 2-14Creating a Work Repository – 2 2-15Changing the Work Repository Password 2-16Quiz 2-17Summary 2-18Checklist of Practice Activities 2-19Practice 2-1 Overview: Creating and Connecting to ODI Master and Work Repositories 2-203ODI Topology ConceptsObjectives 3-2Agenda 3-3What Is Topology? 3-4What Is in the Topology? 3-5Agenda 3-6What Is a Data Server? 3-7Data Servers: Examples 3-8Important Guideline 1 3-9What Is a Physical Schema? 3-10Physical Schemas: Properties 3-11Technology Terminology Among Vendors 3-12Important Guideline 2 3-13Agenda 3-14Infrastructure for Two Production Sites: Example 3-15ODI Design: Physical Architecture of the Two Production Sites 3-16Logical Schemas and Contexts 3-17iv
What Is a Logical Schema? 3-18Important Guideline 3 3-19Logical Versus Physical Architecture 3-20Design Time Versus Run Time 3-21What Is a Context? 3-22A Context Maps a Logical to a Physical Schema 3-23Defining Contexts 3-24Mapping Logical and Physical Resources 3-25Agenda 3-27ODI Physical Agents 3-28Creating a Physical Agent 3-29ODI Agent Parameters 3-30Launching a Stand-Alone Agent: Examples 3-32Stopping the ODI Agent 3-33Deploying and Configuring a Java EE Agent 3-34Load Balancing: Example 3-37Important Guideline 5 3-39Infrastructure with Agents: Example 3-40Defining Agents: Example 3-41Special Case: Fragmentation Problem 3-42Special Case: Important Guideline 6 3-44Special Case: Defining the Physical Architecture 3-45Special Case: The Infrastructure 3-46Special Case: Physical Architecture in ODI 3-47Agenda 3-48Planning the Topology 3-49Matrix of Logical and Physical Mappings 3-50Quiz 3-51Summary 3-54Checklist of Practice Activities 3-55Practice 3-1 Overview: Configuring a Standalone Agent by Using the Common AdministrationModel 3-564Describing the Physical and Logical ArchitectureObjectives 4-2Agenda 4-3What Topology Navigator Contains 4-4Topology Navigator: Overview 4-5Review: Context Connects Logical to Physical 4-7Objects You Create in the Practice 4-8Defining a Context 4-9v
Agenda 4-10Physical Architecture View 4-11Prerequisites for Connecting to a Server 4-12Important Note 4-13Creating a Data Server 4-14Creating a Data Server: JDBC 4-15JDBC Driver 4-16JDBC URL 4-17Creating a Data Server: JNDI 4-18Testing a Data Server Connection 4-19Creating a Physical Schema 4-20Agenda 4-21Logical Architecture and Context Views 4-22Creating a Logical Schema 4-23Creating a Logical Agent 4-24Editing a Context to Link Logical and Physical Agents 4-25Quiz 4-26Summary 4-28Checklist of Practice Activities 4-29Practice 4-1 Overview: Working with Topology 4-305Setting Up a New ODI ProjectObjectives 5-2Agenda 5-3What Is a Project? 5-4Oracle Data Integrator Projects: Overview 5-5How to Use ODI Projects in Your Work 5-6Creating a New Project 5-7Agenda 5-8What Is a Folder? 5-9Creating a New Folder 5-10Organizing Projects and Folders 5-11Agenda 5-12What Is a Knowledge Module? 5-13Types of Knowledge Modules 5-14Which Knowledge Modules Are Needed? 5-15Knowledge Modules: Examples 5-16Importing Knowledge Modules 5-17Replacing Existing KMs 5-18Knowledge Module Editor 5-20Editing a Knowledge Module 5-21vi
Agenda 5-22Exporting and Importing 5-23Exporting an Object 5-24Importing an Object 5-25ID Numbers: Overview 5-26Import Types 5-27Choosing the Import Mode 5-28Import Report 5-29Agenda 5-30What Is a Marker? 5-31Tagging Objects with Markers 5-32Removing Markers 5-33Marker Groups 5-34Project and Global Markers 5-35Creating a Marker Group 5-36Quiz 5-37Summary 5-39Checklist of Practice Activities 5-40Practice 5-1 Overview: Setting Up a New ODI Project 5-416Oracle Data Integrator Model ConceptsObjectives 6-2What Is a Model? 6-3Agenda 6-4Relational Model 6-5Relational Model: Tables and Columns 6-6Relational Model: Keys 6-7Relational Model: Foreign Keys 6-8Relational Model: Constraints 6-9Relational Model: Indexes 6-11Relational Model Support in ODI 6-12Additional Metadata in ODI 6-13FlexFields 6-15Agenda 6-16What Is Reverse-Engineering? 6-17Methods for DBMS Reverse-Engineering 6-18Other Methods for Reverse-Engineering 6-19Standard Versus Customized Reverse-Engineering 6-20Reverse-Engineering Life Cycle 6-21Agenda 6-22Creating a Model by Reverse-Engineering 6-23vii
Step 1: Creating and Naming a New Model 6-24Note: Creating and Naming a New Model 6-25Step 2: Defining a Reverse-Engineering Strategy 6-26Step 3: Starting the Reverse-Engineering Process 6-28Using RKM for Customized Reverse-Engineering 6-29Selective Reverse-Engineering 6-31Step 4: Fleshing Out Models 6-32Shortcuts 6-33Smart Export and Import 6-34Quiz 6-35Summary 6-37Checklist of Practice Activities 6-38Practice 6-1 Overview: Creating Models by Reverse-Engineering 6-397Organizing ODI Models and Creating ODI DatastoresObjectives 7-2Agenda 7-3What Is a Model Folder? 7-4Creating a Model Folder 7-5What Is a Submodel? 7-6Creating a Submodel 7-7Organizing Datastores into Submodels 7-8Setting Up Automatic Distribution 7-9Agenda 7-10Creating Datastores 7-11Creating a Datastore in a Model 7-12Adding Columns to a Datastore 7-13Agenda 7-14What Is a Constraint in ODI? 7-15Constraints in ODI 7-16Creating a Mandatory Column 7-17Agenda 7-18Creating a Key 7-19Checking a Key 7-20Creating a Reference 7-21Creating a Simple Reference 7-22Creating a Complex Reference 7-23Checking a Reference 7-24Agenda 7-25Creating a Condition 7-26Checking a Condition 7-27viii
Agenda 7-28Audit/Explore: When and Why 7-29Audit/Explore Process: Overview 7-30Agenda 7-31Displaying the Contents of a Datastore 7-32Viewing the Distribution of Values 7-33Analyzing the Contents of a Datastore 7-34Agenda 7-35Defining Business Rules in ODI 7-36From Business Rules to Constraints 7-37Deducing Constraints from Data Analysis 7-38Testing a Constraint 7-39Auditing a Model or Datastore 7-40Reviewing Erroneous Records 7-41Quiz 7-42Summary 7-44Checklist of Practice Activities 7-45Practice 7-1 Overview: Checking Data Quality in the Model 7-468ODI Mapping ConceptsObjectives 8-2Agenda 8-3What Is a Mapping? 8-4Business Rules for Mappings 8-5Where Are the Rules Defined? 8-6Agenda 8-7What Is an Expression? 8-8What Is a Join? 8-9What Is a Filter? 8-10What Is a Lookup? 8-11What Is a Set? 8-12What Are Some of the Others? 8-13New with Patch: Pivot and Unpivot 8-14Agenda 8-15How Does ODI Implement Business Rules? 8-16Business Problem 8-17Implementing the Rules 8-18Integration Process 8-19Process Details 8-20Process Implementation: Example 1 8-21Process Implementation: Example 2 8-22ix
Process Implementation: Example 3 8-23Agenda 8-24What Is a Staging Area? 8-25Execution Location 8-26Agenda 8-27From Business Rules to Processes 8-28Knowledge Modules 8-29What Is a Knowledge Module? 8-30Code Generation 8-31KM Types Used in Mappings 8-32Agenda 8-33Purpose of a Mapping 8-34What Is an Expression? 8-35Creating a One-to-One Mapping 8-36Creating and Naming a Mapping 8-37Defining the Target Datastore 8-38Multiple Targets 8-39Defining the Source Datastore 8-40Connecting the Ports to Make the Map 8-41Defining the Expressions 8-42Valid Expression Types 8-43Saving the Mapping 8-44Running the Mapping 8-45Quiz 8-46Summary 8-48Checklist of Practice Activities 8-49Practice 8-1 Overview: Mapping: Simple Transformations 8-509Designing MappingsObjectives 9-2Agenda 9-3Multiple-Source Datastores 9-4Creating a Join Manually 9-5Advanced Joins 9-6Types of Joins 9-7Setting Up a Join 9-8Creating Lookups 9-10Using Lookups 9-11Agenda 9-13Filters in ODI 9-14Defining a Filter Manually 9-15x
Setting Up a Filter 9-16Agenda 9-17Physical Mapping Diagram 9-18Flow in the Physical Diagram 9-20What Defines the Flow? 9-21Scenario 9-22Basic Process 9-23Agenda 9-24Purpose of a Staging Area 9-25Placing the Staging Area 9-26Important Note 9-27Specifying the Staging Area 9-28Agenda 9-29Options for Expressions 9-30Setting Options for Expressions 9-31Disabling an Expression 9-32Enabling a Mapping for Inserts or Updates 9-33Agenda 9-34Execution Location and Syntax 9-35Why Change the Execution Location? 9-36Changing the Execution Location 9-37ODI Mapping Execution Simulation 9-38Agenda 9-39Which KMs for Which Flow? 9-40Knowledge Modules: Additional Information 9-42Identifying IKMs and LKMs 9-43IKMs and LKMs: Strategies and Methods 9-44Specifying an LKM 9-45Specifying an IKM 9-46Common KM Options 9-47Flow: Example 1 9-48Flow: Example 2 9-49Flow: Example 3 9-50Quiz 9-51Summary 9-52Checklist of Practice Activities 9-53Practice 9-1 Overview: Mapping: Complex Transformations 9-54Practice 9-2 Overview: Mapping: Implementing Lookup 9-55xi
10 Mappings: Monitoring and TroubleshootingObjectives 10-2Agenda 10-3Operator Navigator: Viewing the Log 10-4Using the Operator Navigator 10-5Hierarchy: Sessions, Steps, Tasks 10-6Viewing Details of Sessions, Steps, and Tasks 10-7Monitoring Execution of a Mapping 10-8Troubleshooting a Session 10-91. Identifying the Error 10-102. Reviewing the Code 10-113. Fixing the Code and Restarting the Session 10-124. Fixing the Mapping 10-13Keys to Reviewing the Generated Code 10-14Agenda 10-15Common Errors and Symptoms 10-16Important Note 10-18Tips for Preventing Errors 10-19Using the Attributes Panel for Quick Edits 10-20Quiz 10-21Summary 10-23Checklist of Practice Activities 10-24Practice 10-1 Overview: Creating ODI Mapping: Exporting a Flat File to a RelationalTable 10-2511 Designing Mappings: Advanced Topics 1Objectives 11-2Agenda 11-3Business Rules in Mappings 11-4Business Rule Elements 11-5More Elements 11-6Expression Editor 11-7Agenda 11-9Using a Variable in Code 11-10Binding Versus Substitution 11-12Case Sensitivity 11-13Agenda 11-14Defining a Dataset 11-15Using Set-Based Operators 11-16Example of SET: UNION 11-17Agenda 11-18xii
Types of Sequences 11-19Support for Native Sequences 11-20Creating a Native Sequence 11-21Referring to Sequences 11-22Note: Sequences Updated by Agent 11-23Using Standard Sequences in Mappings Correctly 11-24Using ODI Standard Sequences in Mappings 11-25Populating Native Identity Attributes 11-26Sequences: Best Practices 11-27Automatic Temporary Index Management 11-28Tracking Variables and Sequences 11-29How Variable and Sequence Tracking Works 11-30Variable Actions 11-31Definition Tab of Session Step or Session Task 11-32Quiz 11-33Summary 11-34Checklist of Practice Activities 11-35Practice 11-1: Using Native Sequences with ODI Mapping 11-36Practice 11-2: Using Temporary Indexes 11-37Practice 11-3: Using Sets with ODI Mapping 11-3812 Designing Mappings: Advanced Topics 2Objectives 12-2Agenda 12-3Partitioning 12-4Definition in Datastore After Reverse-Engineering 12-5Using Partitioning in a Mapping 12-6Agenda 12-7Reusable Mappings 12-8Using Reusable Mappings: Example 12-9Derived Select (Subselect) for Reusable Mappings 12-10Agenda 12-11What Is a User Function? 12-12Why Use User Functions? 12-13Properties of User Functions 12-15Using User Functions 12-16Creating a User Function 12-17Defining an Implementation 12-18Syntax and Implementations 12-19User Functions at Design Time 12-20User Functions at Run Time 12-21xiii
Note: Functions in Execution Log 12-22Agenda 12-23Using Substitution Methods 12-24Substitution Methods: Examples 12-26Agenda 12-27Description of KM Steps 12-28Details of the Steps 12-29Setting KM Options 12-30Developing Your Own KM: Guidelines 12-31Complex File Technology 12-33Quiz 12-34Summary 12-35Checklist of Practice Activities 12-36Practice 12-1: Creating and Using Reusable Mappings 12-37Practice 12-2: Developing a New Knowledge Module 12-3813 Using ODI ProceduresObjectives 13-2Agenda 13-3What Is a Procedure? 13-4Procedure: Examples 13-5Creating Procedures: Overview 13-7Agenda 13-8Creating a New Procedure 13-9Agenda 13-10Creating a Command 13-11Arranging Tasks in Order 13-13Which Parameters Should Be Set? 13-14Valid Types of Commands 13-15More Elements 13-16Why Use a Source Command? 13-17Agenda 13-18Types of Options 13-19Creating a New Option 13-20Making a Command Optional 13-21Using an Option Value in a Command 13-22Agenda 13-23Procedure Execution 13-24Using the Operator Navigator to View Results 13-25Quiz 13-26Summary 13-28xiv
Checklist of Practice Activities 13-29Practice 13-1: Creating an ODI Procedure 13-3014 Using ODI PackagesObjectives 14-2Agenda 14-3What Is a Package? 14-4Creating a Package 14-5Agenda 14-6Creating and Naming a Package 14-7Package Diagram 14-8Package Diagram Toolbar 14-9Agenda 14-11Package Steps 14-12Creating a Package Step 14-13What Is an ODI Tool? 14-14Creating an ODI Tool Step 14-15Tool Steps: Best Practices 14-16Agenda 14-17Sequencing Steps 14-18A Simple Package 14-19Sequencing Package Steps 14-20Agenda 14-21Executing a Package 14-22Agenda 14-23Basic Step Types 14-24Advanced Step Types 14-25Agenda 14-26Creating Model, Submodel, and Datastore Steps 14-27Models, Submodels, and Datastore Steps 14-28Agenda 14-30Creating a Variable Step 14-31Variable Steps 14-32Agenda 14-34Controlling Execution 14-35Error Handling 14-36Creating a Loop 14-37The Advanced Tab 14-38Quiz 14-39Summary 14-41Checklist of Practice Activities 14-42xv
Practice 14-1: Creating an ODI Package 14-43Practice 14-2: Using ODI Packages with Variables and User Functions 14-4415 Step-by-Step DebuggerObjectives 15-2Agenda 15-3Overview 15-4Agenda 15-5Process Overview 15-6Starting a Session in Debug mode 15-7Specifying Debug Properties 15-8Control Execution Flow 15-9Screen Step Numbering 15-10Agenda 15-11New Functionalities 15-12Benefits for End Users 15-15Agenda 15-16Debug Toolbar 15-17Toolbar: Current Cursor 15-18Toolbar: Get Data 15-19Toolbar: Step Into 15-20Toolbar: Run to Task End 15-21Toolbar: Run to Next Task 15-22Toolbar: Run to Step End 15-23Toolbar: Run to Next Step 15-24Toolbar: Pause 15-25Toolbar: Resume 15-26Summary 15-27Checklist of Practice Activities 15-28Practice 15-1: Debugging Mappings 15-2916 Managing ODI ScenariosObjectives 16-2Agenda 16-3What Is a Scenario? 16-4Properties of Scenarios 16-5Agenda 16-6Scenario-Related Tasks 16-7Generating a Scenario 16-8Regenerating a Scenario 16-9Generation Versus Regeneration 16-10xvi
Executing a Scenario from the GUI 16-11Executing a Scenario from a Command Line 16-12Executing a Scenario from a Package 16-13Exporting a Scenario 16-14Agenda 16-15Preparing Scenarios for Deployment 16-16Automating Scenario Management 16-17Scheduling the ODI Scenario 16-18Scheduling ODI Scenario with External Scheduler 16-21Managing Schedules 16-22Quiz 16-23Summary 16-24Checklist of Practice Activities 16-25Practice 16-1: Creating and Scheduling an ODI Scenario 16-2617 Using Load PlansObjectives 17-2Should You Organize Executions with Load Plans? 17-3What Are Load Plans? 17-4Load Plan Editor 17-5Load Plan Steps 17-6Defining the Restart Behavior 17-7Are Load Plans Substitutes for Packages or Scenarios? 17-9Benefits of Using Load Plans 17-10Handling Failed Load Plans 17-11Quiz 17-12Summary 17-13Checklist of Practice Activities 17-14Practice 17-1 Overview: Using Load Plans 17-1518 Enforcing Data Quality with ODIObjectives 18-2Agenda 18-3Why Data Quality? 18-4When to Enforce Data Quality 18-5Data Quality in Source Applications 18-6Data Quality Control in the Integration Process 18-7Data Quality in the Target Applications 18-8Agenda 18-9Data Quality Business Rules 18-10From Business Rules to Constraints 18-11xvii
Agenda 18-12Data Quality System: Overview 18-13Static and Flow Controls: Differences 18-14Data Quality Control: Properties 18-15Synchronous Control 18-16What Is a Constraint? 18-17What Can Be Checked? 18-18Enforcing Data Quality in a Mapping 18-19Agenda 18-20Setting Up Static or Flow Control 18-21Enabling Static or Flow Control 18-22Agenda 18-23Setting the Physical Options 18-24Setting the Logical Options 18-25Agenda 18-26Selecting Which Constraints to Enforce 18-27Selecting Which Constraints to Check 18-28Differences Between Control Types 18-29Agenda 18-30Reviewing Erroneous Records 18-31EnterpriseDataQuality Tool 18-32Using the EDQ Tool 18-33Quiz 18-34Summary 18-36Checklist of Practice Activities 18-37Practice 18-1: Enforcing Data Quality with ODI Mappings 18-3819 Working with Changed Data Capture (CDC)Objectives 19-2Why Changed Data Capture? 19-3CDC Techniques 19-4Changed Data Capture in ODI 19-5Journalizing Components 19-6CDC Infrastructure in ODI 19-7Simple Versus Consistent Set Journalizing 19-8Limitations of Simple CDC Journalizing: Example 19-9Consistent CDC Journalizing 19-10Consistent CDC: Infrastructure 19-11Setting Up Journalizing 19-12Setting CDC Parameters: Example 19-13Adding a Subscriber: Example 19-14xviii
Starting Journal: Example 19-15Journalizing Status 19-16Viewing Data/Changed Data: Example 19-17Using Changed Data 19-18Oracle GoldenGate Integration 19-20Oracle GoldenGate Integration in ODI 12c 19-21Quiz 19-22Summary 19-24Checklist of Practice Activities 19-25Practice 19-1: Implementing Changed Data Capture 19-2620 Advanced ODI AdministrationObjectives 20-2Agenda 20-3Introduction to ODI Security Navigator 20-4Security Concepts: Overview 20-6Defining Security Policies 20-8Creating Profiles 20-9Using Generic and Nongeneric Profiles 20-10Built-in Profiles 20-11Creating Users 20-12Assigning a Profile to a User 20-13Assigning an Authorization by Profile or User 20-14Defining Password Policies 20-15Setting User Preferences 20-17ODI Security Integration: Overview 20-18Implementing External Authentication (OPSS) 20-19Implementing External Authentication (OPSS): Switching the Authentication Mode 20-21Implementing External Password Storage 20-22Agenda 20-24Types of ODI Reports 20-25Generating Topology Reports 20-26Generated Topology Report: Example 20-27Version Comparison Report: Example 20-28Generating Object Reports 20-29Agenda 20-30Integration of ODI with Enterprise Manager 20-31Java EE Agent and Enterprise Manager Configuration with WebLogic Domain:Overview 20-32Using ODI Console: Example 20-33Quiz 20-34xix
Summary 20-35Checklist of Practice Activities 20-36Practice 20-1: Setting Up ODI Security 20-37Practice 20-2: Integration with Enterprise Manager and Using ODI Console 20-3821 Integrating ODI with SubversionObjectives 21-2Agenda 21-3ODI-VCS Integration 21-4ODI-VCS Integration Features 21-5ODI: Selecting the Required VCS 21-6ODI Repository Change 21-7Agenda 21-8SVN Connections 21-9Creating an SVN Connection 21-10Configuring ODI Subversion Settings 21-11Configuring the Subversion Repository with ODI 21-12Creating a Default Subversion Project Structure 21-13Configuring the Subversion Repository with ODI: Options 21-14SVN Configuration Options 21-15Creating the Default Project Structure 21-16Disconnection from ODI (Required) 21-17Agenda 21-18Adding ODI Objects to SVN: Options 21-19Adding a Single Non-Versioned Object to SVN: 1 21-20Adding a Single Non-Versioned Object to SVN: 2 21-21Adding Multiple Non-Versioned Objects to SVN: 1 21-22Adding Multiple Non-Versioned Objects to SVN: 2 21-23Creating a New Version for an Object 21-24Adding a Version Comment 21-25Agenda 21-26Creating Full or Partial Tags in the Subversion Repository 21-27Creating a Full Tag 21-28Full Tag Parameters 21-29Creating a Partial Tag 21-30Partial Tag: Adding a Subset of ODI Objects 21-31Agenda 21-32Version History 21-33Comparing Versions 21-34Version Search Criteria 21-35Version Compare Results 21-36xx
Display Color Options 21-37Display Version Tree 21-38Agenda 21-39Performing a Branch Merge 21-40Merge Summary Report 21-41Merge Results Window 21-42Resolving Merge Conflicts 21-43Merge Conflict Resolution 21-44Quiz 21-45Summary 21-46Practice 21-1: Subversion ODI Setup 21-47Practice 21-2: Branch and Label Management 21-4822 Integrating Big Data with ODIObjectives 22-2Agenda 22-3Big Data 22-4Google BigTable, a Big Data Pioneer 22-5Emergence of Apache Hadoop 22-6Agenda 22-7Apache Hadoop 22-8Hadoop Ecosystem 22-9Apache HBASE 22-10Apache Hive 22-11Apache Pig 22-12Apache Spark 22-13Apache Sqoop 22-14Apache Oozie 22-15Agenda 22-16Hadoop Data Integration: Overview 22-17Big Data Knowledge Modules Matrix:1 22-18Big Data Knowledge Modules Matrix: 2 22-19Big Data Knowledge Modules Matrix: 3 22-20ODI: Hadoop Integration Process 22-21ODI: Further Processing After Hadoop Analysis 22-22ODI: Code Generation 22-23Agenda 22-24Apache Oozie and ODI Integration 22-25ODI to Oozie Workflow Tasks 22-26Agenda 22-27ODI Support for Unstructured Data 22-28xxi
ODI Support for Complex Data 22-29Summary 22-30xxii
Why Oracle Data Integrator? 1 -8 Conventional Integration Process: ETL 1 -10 Extract Load Transform (E -LT) 1 -11 ODI Architecture and Components 1 -13 ODI Architecture 1 -14 ODI Components: Overview 1 -16 Using ODI Studio 1 -17 Designer Navigator (Work Rep
Oracle SOA Suite 12c Oracle Cloud Control 12c Oracle OSB 12c y Consulting Architecture Analysis and Development Testing and Production Support Infrastructure and Tuning Application Maintenance Technology Oracle BPM 12c Oracle SOA 12c OAG 12c OER 12c Oracle Virtual Directory Oracle Identity Manager
Oracle Data Integrator 12c New Features Overview Advancing Autonomous Database and Big Data O R A C L E W H I T E P A P E R SEPTEMBER 2 0 1 9 . ORACLE DATA INTEGRATOR 12C NEW FEATURES WHITEPAPER Table of Contents Executive Overview 6 Oracle Data Integrator 12.2.1.4.0 7 Oracle Sales Cloud 7 .
OEM 12c Upgrade - Two System (Different Hardware) em.cisco.com. OEM DB. 10g RAC. 10g repository. Targets 10g. Targets 12c. em12c.cisco.com. OEM DB. 11g RAC. 12c repository. Deploy 12c agents. Clone and upgrade repository DB to 11g. Install 12c OMS & upgrade EM repository to 12c. Start 12c OMS & Deferred Data Migration Job. Incremental .
Oracle Data Integrator 12c New Features Overview Advancing Big Data and Cloud O R A C L E W H I T E P A P E R DECEMBER 2 0 1 8 . ORACLE DATA INTEGRATOR 12C NEW FEATURES WHITEPAPER Table of Contents Executive Overview 6 Oracle Data Integrator 12.2.1.3.1 7 Oracle Object Storage and Oracle Object Storage Classic 7 .
Oracle Data Integrator Log Locations and Configuration 4-5 Oracle Data Integrator High Availability and Failover Considerations 4-6 Oracle Data Integrator Clustered Deployment 4-7 Oracle Data Integrator Protection from Failure and Expected Behavior 4-8 WebLogic Server or Standalone Agent Crash 4-8
Oracle Database 12c - Disaster recovery solution using Oracle Data Guard and HPE Serviceguard for Linux across production and recovery data centers Oracle Database 12c - High availability solution using Oracle Real Application Clusters (RAC) Oracle Database 12c - Application-consistent Oracle
Database 12c, Oracle Data Integrator 12c, Oracle BI Answers 12c and Oracle BI Publisher 12c and Oracle BI Dashboards. The Courts BI solution includes data from multiple data sources; subject areas, repository definitions, and a multitude of ad-hoc analysis; Judicial, Executive and operational dashboards. In the past six (6) years besides
Oracle Data Integrator (ODI) is a best-of-breed data integration platform focused on fast bulk data movement and handling complex data transformations. Oracle Data Integrator is fully integrated with the Oracle tech
