PacktLib: Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

Credits

Foreword

About the Authors

About the Reviewers

www.PacktPub.com

Preface

Product Overview

ODI product architecture

ODI key concepts

Summary

Product Installation

Prerequisites

Installing ODI 11g

Post installation—parameter files review

Summary

Using Variables

Defining variables

Using variables for dynamic information

Using variables to alter workflows

Summary

ODI Sources, Targets, and Knowledge Modules

Defining Physical Schemas, Logical Schemas, and Contexts

Reverse-engineering metadata into ODI models

Examining the anatomy of the interface flow

Importing and choosing Knowledge Modules

Examining ODI Interfaces

Summary

Working with Databases

Sample scenario description

Exercise 1: Building the Load_Customer interface

Summary

Working with MySQL

What you can and can't do with MySQL

Working with MySQL

Using MySql with ODI

Summary

Working with Microsoft SQL Server

Example: Working with SQL Server

Sample scenario

Summary

Integrating File Data

Working with flat files

Step-by-step example

Summary

Working with XML Files

Introduction to XML

Introducing the ODI JDBC driver for XML

Example: Working with XML files

Summary

Creating Workflows—Packages and Load Plans

Packages

Load Plans

Summary

Error Management

Managing data errors

Managing execution errors

Handling operational errors

Summary

Managing and Monitoring ODI Components

Scheduling with Oracle Data Integrator

Fusion Middleware Console Control

Oracle Data Integrator Console

Summary

Concluding Remarks

Index