D82167OROracleOR-D82167Ed 3<ul> <li>Administer ODI resources and setup security with ODI</li><li>Apply ODI Topology concepts for data integration</li><li>Describe ODI Model concepts</li><li>Describe architecture of Oracle Data Integrator 12c</li><li>Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations</li><li>Explore, audit data, and enforce data quality with ODI</li><li>Implement Changed Data Capture with ODI</li><li>Integrate ODI with Version Control Systems (Subversion)</li><li>Extend ODI to include the Big Data Hadoop ecosystem</li></ul><p>Basic knowledge of ELT data processing</p><ul> <li>Database Administrators</li><li>Business Analysts</li><li>Technical Consultant</li><li>Data Modelers</li><li>SOA Architect</li><li>Data Scientist</li><li>Data Warehouse Administrator</li></ul><ul> <li>Introduction</li><li>Administering ODI Repositories and Agents</li><li>ODI Topology Concepts</li><li>Describing the Physical and Logical Architecture</li><li>Setting Up a New ODI Project</li><li>Oracle Data Integrator Model Concepts</li><li>Organizing ODI Models and Creating Data stores</li><li>ODI Mapping Concepts</li><li>Designing Mappings</li><li>Mapping: Monitoring and Debugging</li><li>Designing Mappings: Advanced Topics 1</li><li>Designing Mappings: Advanced Topics 2</li><li>Creating and Running ODI procedures</li><li>Using ODI Packages</li><li>Step-by-Step Debugger</li><li>Managing ODI Scenarios and Versions</li><li>Using Load Plans</li><li>Enforcing Data Quality and Auditing Data with ODI</li><li>Working with Changed Data Capture</li><li>Advanced ODI Administration</li><li>Integrating ODI with Subversion</li><li>Integrating Big Data with ODI</li></ul><h5>Introduction</h5><ul> <li>Identifying the Course Units</li><li>Why Oracle Data Integrator?</li><li>Overview of ODI Architecture</li><li>Overview of ODI Components</li><li>About Graphical Modules</li><li>Types of ODI Agents</li><li>Overview of Oracle Data Integrator Repositories</li></ul><h5>Administering ODI Repositories and Agents</h5><ul> <li>Administrating the ODI Repositories</li><li>Creating Repository Storage Spaces</li><li>Creating and Connecting to the Master Repository</li><li>Creating and Connecting to the Work Repository</li><li>Creating a Wallet to Securely Store Credentials</li><li>Managing ODI Agents</li><li>Creating a Physical Agent</li><li>Launching a Listener, Scheduler and Web Agent</li></ul><h5>ODI Topology Concepts</h5><ul> <li>Overview of ODI Topology</li><li>About Data Servers and Physical Schemas</li><li>Defining the Physical Architecture</li><li>Defining the Logical Architecture</li><li>Mapping Logical and Physical Resources</li><li>Defining Agents</li><li>Defining a Topology</li><li>Planning the Topology</li></ul><h5>Describing the Physical and Logical Architecture</h5><ul> <li>Overview of Topology Navigator</li><li>Creating Physical Architecture</li><li>Creating a Data Server</li><li>Testing a Data Server Connection</li><li>Creating a Physical Schema</li><li>Creating Logical Architecture</li><li>Overview of Logical Architecture and Context Views</li><li>Linking the Logical and Physical Architecture</li></ul><h5>Setting Up a New ODI Project</h5><ul> <li>Overview of ODI Projects</li><li>Creating a New Project</li><li>Creating and Maintaining Folders</li><li>Organizing Projects and Folders</li><li>Understanding Knowledge Modules</li><li>Exchanging ODI Objects and Sharing Global Objects</li><li>Exporting and Importing Objects</li><li>Creating and Labeling with Markers</li></ul><h5>Oracle Data Integrator Model Concepts</h5><ul> <li>What is a Model?</li><li>Understanding Metadata in ODI</li><li>Understanding Reverse Engineering</li><li>Creating Models</li><li>Organizing Models</li><li>Creating Data stores</li><li>Configuring Constraints in ODI</li><li>Creating Keys and References</li></ul><h5>Organizing ODI Models and Creating Data stores</h5><ul> <li>What is a Mapping?</li><li>Business Rules for Mappings</li><li>Creating a Basic Mapping</li><li>What is a Join?</li><li>What is a Filter?</li><li>What is a Constraint?</li><li>What is a Staging Area?</li></ul><h5>ODI Mapping Concepts</h5><ul> <li>What is a Mapping?</li><li>Business Rules for Mapping</li><li>What is a Mapping, a Filter, a Join?</li><li>Overview of Integration Process</li><li>What is a Staging Area?</li><li>Execution Location</li><li>Mapping with Knowledge Modules (KM)</li><li>Creating an Intermediate Mapping</li></ul><h5>Designing Mappings</h5><ul> <li>Designing a Mapping</li><li>Multiple Source Data stores</li><li>Creating Joins</li><li>Filtering Data</li><li>Disabling Transformations</li><li>Overview of the Flow</li><li>Specifying the Staging Area</li><li>Selecting Knowledge Modules</li></ul><h5>Mapping: Monitoring and Debugging</h5><ul> <li>Monitoring Mappings</li><li>Creating Objects with Operator</li><li>Viewing Sessions and Tasks</li><li>How to Monitor Execution of a Mapping</li><li>How to Troubleshoot a Session</li><li>Keys to Reviewing the Generated Code</li><li>Working with Errors</li><li>Tips for Preventing Errors</li></ul><h5>Designing Mappings: Advanced Topics 1</h5><ul> <li>Mapping with Business Rules</li><li>Overview of Business Rule Elements</li><li>Creating and Tracking Variables</li><li>Creating User Functions</li><li>Mapping Substitution Methods</li><li>Modifying a KM</li><li>Showing Variable Values in Log</li><li>Customizing Reverse Engineering Using RKM</li></ul><h5>Designing Mappings: Advanced Topics 2</h5><ul> <li>Using Partitioning in a Mapping</li><li>Reusable Mappings</li><li>Derived Select (Subselect) for Reusable Mappings</li><li>Using User Functions</li><li>Creating a User Function</li><li>Using Substitution Methods</li><li>Developing Your Own Knowledge Module</li></ul><h5>Creating and Running ODI procedures</h5><ul> <li>What is a Procedure?</li><li>Examples of Procedures</li><li>Creating Procedures</li><li>Adding Commands</li><li>Adding Options</li><li>Running a Procedure</li><li>Viewing Results with Operator</li></ul><h5>Using ODI Packages</h5><ul> <li>What is a Package?</li><li>Creating a Package</li><li>Executing a Package</li><li>Creating Advanced Packages</li><li>Error Handling</li><li>Controlling an Execution Path</li><li>Creating a Loop</li><li>Using the Advanced tab</li></ul><h5>Step-by-Step Debugger</h5><ul> <li>Starting a Session in Debug mode</li><li>Specifying Debug Properties</li><li>Control Execution Flow</li><li>Screen Step Numbering</li></ul><h5>Managing ODI Scenarios and Versions</h5><ul> <li>What is a Scenario?</li><li>Managing Scenarios with Load Plans</li><li>Preparing Scenarios for Deployment</li><li>Automating Scenario Management</li><li>Scheduling the ODI Scenario</li><li>Overview of ODI version management</li><li>Handling concurrent changes</li></ul><h5>Using Load Plans</h5><ul> <li>What Are Load Plans?</li><li>Load Plan Editor</li><li>Load Plan Steps</li><li>Defining the Restart Behavior</li><li>Benefits of Using Load Plans</li><li>Handling Failed Load Plans</li></ul><h5>Enforcing Data Quality and Auditing Data with ODI</h5><ul> <li>Why Data Quality?</li><li>When to Enforce Data Quality?</li><li>Data Quality in Source Applications</li><li>Data Quality Control in the Integration Process</li><li>Data Quality in the Target Applications</li><li>Enforcing Data Quality</li><li>Exploring Your Data</li><li>Auditing Data Quality</li></ul><h5>Working with Changed Data Capture</h5><ul> <li>Overview of ODI version management</li><li>Techniques of Changed Data Capture</li><li>Changed Data Capture in ODI</li><li>CDC Strategies and Infrastructure</li><li>CDC Consistency</li><li>Creating Change Data Capture (CDC)</li><li>Viewing Data/Changed data</li><li>Journalizing</li></ul><h5>Advanced ODI Administration</h5><ul> <li>Introduction to ODI Security Navigator</li><li>Security Concepts: Overview, Defining Security Policies</li><li>Creating Profiles, Creating Users, Assigning a Profile to a User, Assigning an Authorization by Profile or User</li><li>Defining Password Policies, Implementing External Authentication</li><li>Generating Topology Reports</li><li>Integration of ODI with Enterprise Manager</li><li>Java EE Agent and Enterprise Manager Configuration with WebLogic Domain</li><li>Using ODI Console</li></ul><h5>Integrating ODI with Subversion</h5><ul> <li>ODI: VCS Integration</li><li>ODI: Selecting the Required VCS</li><li>SVN Connections</li><li>Configuring the Subversion Repository with ODI</li><li>Adding a Single Non-Versioned Object to SVN, Adding Multiple Non-Versioned Objects to SVN</li><li>Creating a New Version for an Object</li><li>Creating Full or Partial Tags in the Subversion Repository</li><li>Performing a Branch Merge</li></ul><h5>Integrating Big Data with ODI</h5><ul> <li>Big Data Concepts</li><li>Emergence of Apache Hadoop</li><li>Hadoop Ecosystem</li><li>Apache HBase, Apache Hive, Apache Pig</li><li>Apache Spark, Apache Sqoop, Apache Oozie</li><li>Hadoop Data Integration: Overview</li><li>Big Data Knowledge Modules Matrix</li><li>ODI: Hadoop Integration Process</li></ul>- Administer ODI resources and setup security with ODI - Apply ODI Topology concepts for data integration - Describe ODI Model concepts - Describe architecture of Oracle Data Integrator 12c - Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations - Explore, audit data, and enforce data quality with ODI - Implement Changed Data Capture with ODI - Integrate ODI with Version Control Systems (Subversion) - Extend ODI to include the Big Data Hadoop ecosystemBasic knowledge of ELT data processing- Database Administrators - Business Analysts - Technical Consultant - Data Modelers - SOA Architect - Data Scientist - Data Warehouse Administrator- Introduction - Administering ODI Repositories and Agents - ODI Topology Concepts - Describing the Physical and Logical Architecture - Setting Up a New ODI Project - Oracle Data Integrator Model Concepts - Organizing ODI Models and Creating Data stores - ODI Mapping Concepts - Designing Mappings - Mapping: Monitoring and Debugging - Designing Mappings: Advanced Topics 1 - Designing Mappings: Advanced Topics 2 - Creating and Running ODI procedures - Using ODI Packages - Step-by-Step Debugger - Managing ODI Scenarios and Versions - Using Load Plans - Enforcing Data Quality and Auditing Data with ODI - Working with Changed Data Capture - Advanced ODI Administration - Integrating ODI with Subversion - Integrating Big Data with ODIIntroduction - Identifying the Course Units - Why Oracle Data Integrator? - Overview of ODI Architecture - Overview of ODI Components - About Graphical Modules - Types of ODI Agents - Overview of Oracle Data Integrator Repositories Administering ODI Repositories and Agents - Administrating the ODI Repositories - Creating Repository Storage Spaces - Creating and Connecting to the Master Repository - Creating and Connecting to the Work Repository - Creating a Wallet to Securely Store Credentials - Managing ODI Agents - Creating a Physical Agent - Launching a Listener, Scheduler and Web Agent ODI Topology Concepts - Overview of ODI Topology - About Data Servers and Physical Schemas - Defining the Physical Architecture - Defining the Logical Architecture - Mapping Logical and Physical Resources - Defining Agents - Defining a Topology - Planning the Topology Describing the Physical and Logical Architecture - Overview of Topology Navigator - Creating Physical Architecture - Creating a Data Server - Testing a Data Server Connection - Creating a Physical Schema - Creating Logical Architecture - Overview of Logical Architecture and Context Views - Linking the Logical and Physical Architecture Setting Up a New ODI Project - Overview of ODI Projects - Creating a New Project - Creating and Maintaining Folders - Organizing Projects and Folders - Understanding Knowledge Modules - Exchanging ODI Objects and Sharing Global Objects - Exporting and Importing Objects - Creating and Labeling with Markers Oracle Data Integrator Model Concepts - What is a Model? - Understanding Metadata in ODI - Understanding Reverse Engineering - Creating Models - Organizing Models - Creating Data stores - Configuring Constraints in ODI - Creating Keys and References Organizing ODI Models and Creating Data stores - What is a Mapping? - Business Rules for Mappings - Creating a Basic Mapping - What is a Join? - What is a Filter? - What is a Constraint? - What is a Staging Area? ODI Mapping Concepts - What is a Mapping? - Business Rules for Mapping - What is a Mapping, a Filter, a Join? - Overview of Integration Process - What is a Staging Area? - Execution Location - Mapping with Knowledge Modules (KM) - Creating an Intermediate Mapping Designing Mappings - Designing a Mapping - Multiple Source Data stores - Creating Joins - Filtering Data - Disabling Transformations - Overview of the Flow - Specifying the Staging Area - Selecting Knowledge Modules Mapping: Monitoring and Debugging - Monitoring Mappings - Creating Objects with Operator - Viewing Sessions and Tasks - How to Monitor Execution of a Mapping - How to Troubleshoot a Session - Keys to Reviewing the Generated Code - Working with Errors - Tips for Preventing Errors Designing Mappings: Advanced Topics 1 - Mapping with Business Rules - Overview of Business Rule Elements - Creating and Tracking Variables - Creating User Functions - Mapping Substitution Methods - Modifying a KM - Showing Variable Values in Log - Customizing Reverse Engineering Using RKM Designing Mappings: Advanced Topics 2 - Using Partitioning in a Mapping - Reusable Mappings - Derived Select (Subselect) for Reusable Mappings - Using User Functions - Creating a User Function - Using Substitution Methods - Developing Your Own Knowledge Module Creating and Running ODI procedures - What is a Procedure? - Examples of Procedures - Creating Procedures - Adding Commands - Adding Options - Running a Procedure - Viewing Results with Operator Using ODI Packages - What is a Package? - Creating a Package - Executing a Package - Creating Advanced Packages - Error Handling - Controlling an Execution Path - Creating a Loop - Using the Advanced tab Step-by-Step Debugger - Starting a Session in Debug mode - Specifying Debug Properties - Control Execution Flow - Screen Step Numbering Managing ODI Scenarios and Versions - What is a Scenario? - Managing Scenarios with Load Plans - Preparing Scenarios for Deployment - Automating Scenario Management - Scheduling the ODI Scenario - Overview of ODI version management - Handling concurrent changes Using Load Plans - What Are Load Plans? - Load Plan Editor - Load Plan Steps - Defining the Restart Behavior - Benefits of Using Load Plans - Handling Failed Load Plans Enforcing Data Quality and Auditing Data with ODI - Why Data Quality? - When to Enforce Data Quality? - Data Quality in Source Applications - Data Quality Control in the Integration Process - Data Quality in the Target Applications - Enforcing Data Quality - Exploring Your Data - Auditing Data Quality Working with Changed Data Capture - Overview of ODI version management - Techniques of Changed Data Capture - Changed Data Capture in ODI - CDC Strategies and Infrastructure - CDC Consistency - Creating Change Data Capture (CDC) - Viewing Data/Changed data - Journalizing Advanced ODI Administration - Introduction to ODI Security Navigator - Security Concepts: Overview, Defining Security Policies - Creating Profiles, Creating Users, Assigning a Profile to a User, Assigning an Authorization by Profile or User - Defining Password Policies, Implementing External Authentication - Generating Topology Reports - Integration of ODI with Enterprise Manager - Java EE Agent and Enterprise Manager Configuration with WebLogic Domain - Using ODI Console Integrating ODI with Subversion - ODI: VCS Integration - ODI: Selecting the Required VCS - SVN Connections - Configuring the Subversion Repository with ODI - Adding a Single Non-Versioned Object to SVN, Adding Multiple Non-Versioned Objects to SVN - Creating a New Version for an Object - Creating Full or Partial Tags in the Subversion Repository - Performing a Branch Merge Integrating Big Data with ODI - Big Data Concepts - Emergence of Apache Hadoop - Hadoop Ecosystem - Apache HBase, Apache Hive, Apache Pig - Apache Spark, Apache Sqoop, Apache Oozie - Hadoop Data Integration: Overview - Big Data Knowledge Modules Matrix - ODI: Hadoop Integration Process5 Tage4065.004270.00