O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle Data Integrator Essentials

Video Description

Develop, deploy, and maintain your own data integration projects with a clear view of Oracle Data Integrator essentials and best practices

About This Video

  • Develop the necessary skills for effectively carrying out data integration and transformations in ODI interfaces

  • Understand the use of ODI development objects with methods and concepts illustrated from real projects

  • Master the key concepts of ODI’s physical and logical architecture and the use of Knowledge Modules and data models

  • In Detail

    Oracle Data Integrator (ODI) is Oracle’s strategic tool covering all your data integration requirements. ODI lets you write custom code easily, extract data from source files, transform data in a staging area, and load this data to your target database. So, if you are a database administrator with an aim to effectively use ODI as a powerful tool for data integration solutions, it’s time you started making the most of it.

    This video course will show you how to use ODI for your data transformation and integration projects. It will also provide you with valuable input on which methods to use for various ODI objects according to the situation, with examples based on real-life requirements.

    Covering all the key ODI concepts, this video course shows you how to make the best use of ODI’s declarative approach to define your strategy with Knowledge Modules.

    First, you are made familiar with the basics of ETL processes and then learn how to use of ODI development objects with the help of practical examples. You then move on to get an understanding of ODI’s transformation vehicles and its interface, followed by how ODI packages can be used to develop more workflow-based data integration tasks. Next we show you how reusable objects can be customized by using variables to suit your needs. The following sections broaden your understanding of topologies, scenarios, load plans, and data integration solutions.

    By the end of the course, you will have enough knowledge of ODI, development, deployment, and maintenance techniques to give you the confidence to develop your own data integration projects.

    Table of Contents

    1. Chapter 1 : The ODI Core Concepts
      1. Key ODI Concepts 00:02:53
      2. Differentiating between ETL and ELT 00:01:43
      3. Exploring the Graphical UI 00:04:38
      4. ODI Basics 00:08:00
      5. Defining Your Strategy 00:02:53
      6. The ODI Staging Area 00:04:10
    2. Chapter 2 : Developing in ODI – the Core Objects
      1. Organizing Your Project 00:03:07
      2. Creating an Interface 00:10:29
      3. Using Joins, Data Sets, Filters, and Sequences 00:04:50
      4. Using Temporary Interfaces and Lookups 00:03:22
    3. Chapter 3 : Your Data Transformation Strategy – Knowledge Modules
      1. Adapting Knowledge Modules to Your Needs 00:05:35
      2. Executing Data Transformation in an ODI Interface 00:03:08
      3. Executing a Mapping on Your Source 00:02:26
    4. Chpater 4 : Workflows in ODI
      1. Creating a Workflow in ODI 00:07:18
      2. Reusable Workflows: Procedures 00:03:54
      3. User Functions as Useful Functions 00:03:33
      4. Customize Development Objects in ODI 00:04:25
    5. Chapter 5 : Data Quality and Delta Detection
      1. Oracle Data Quality Products 00:05:16
      2. Using Data Integrity Controls and Integrating Data Quality in ODI 00:02:29
      3. Running EDQ 00:02:55
      4. Delta Detection via CDC 00:04:31
    6. Chapter 6 : Version Management and Deployment
      1. Version Management 00:03:34
      2. Scenarios: Smallest Deployment Units 00:04:03
      3. Solutions 00:02:37
      4. Export and Import 00:02:55
    7. Chapter 7 : Operating and Maintenance
      1. Loadplans 00:05:11
      2. ODI Repository Tables 00:03:11
      3. Security 00:04:29
    8. Chapter 8 : Additional Supporting Functions
      1. How to Automate ODI Object Creation 00:04:29
      2. Impact and Data Lineaging 00:03:03
      3. ODI Studio Enhancements 00:03:39