Use your business data to your advantage with the help of Syncfusion’s new data science offerings. Discover how a custom big data solution can provide your company with valuable predictions about key market trends.

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

This is a brilliant crash course in Oracle Data Integrator that pulls you straight into the platform through practical instructions and real-world situations rather than dry theory. Written by a team of seasoned experts.

$35.99

$59.99

RRP $35.99

RRP $59.99

eBook

Print + eBook

Want this title & more?

$21.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849680684

Paperback384 pages

About This Book

Discover the comprehensive and sophisticated orchestration of data integration tasks made possible with ODI, including monitoring and error-management

Get to grips with the product architecture and building data integration processes with technologies including Oracle, Microsoft SQL Server and XML files

A comprehensive tutorial packed with tips, images and best practices

Who This Book Is For

If you are a software/ETL developer or database administrator who is new to Oracle Data Integrator but want to get hands-on with the product quickly, then "Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" is for you. You should have some experience with databases, SQL and ETL technologies.

Table of Contents

Chapter 1: Product Overview

ODI product architecture

ODI key concepts

Summary

Chapter 2: Product Installation

Prerequisites

Installing ODI 11g

Post installation—parameter files review

Summary

Chapter 3: Using Variables

Defining variables

Using variables for dynamic information

Using variables to alter workflows

Summary

Chapter 4: 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

Chapter 5: Working with Databases

Sample scenario description

Exercise 1: Building the Load_Customer interface

Summary

Chapter 6: Working with MySQL

What you can and can't do with MySQL

Working with MySQL

Using MySql with ODI

Summary

Chapter 7: Working with Microsoft SQL Server

Example: Working with SQL Server

Sample scenario

Summary

Chapter 8: Integrating File Data

Working with flat files

Step-by-step example

Summary

Chapter 9: Working with XML Files

Introduction to XML

Introducing the ODI JDBC driver for XML

Example: Working with XML files

Summary

Chapter 10: Creating Workflows—Packages and Load Plans

Packages

Load Plans

Summary

Chapter 11: Error Management

Managing data errors

Managing execution errors

Handling operational errors

Summary

Chapter 12: Managing and Monitoring ODI Components

Scheduling with Oracle Data Integrator

Fusion Middleware Console Control

Oracle Data Integrator Console

Summary

Chapter 13: Concluding Remarks

What You Will Learn

Get to grips with the various components of the Oracle Data Integrator architecture

Learn how to install ODI quickly and effectively using recommended best practices

"Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" provides you with everything you to get up and running with Oracle Data Integrator, and more! Following an example scenario, the book covers essential information about the ODI architecture and using ODI across different databases (Oracle, Microsoft SQL Server and MySQL), and file types such as XML, before covering Orchestrating Data Integration Workflows, Error Management, Operational Management and Monitoring, and beyond.

"Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" begins by describing the Oracle Data Integrator architecture and teaching you to install the product following best practices. You’ll then be introduced to some of the key concepts of ODI such as the Knowledge Modules.

Later topics include moving and transforming data from sources to targets including the Oracle Database, Microsoft SQL Server, MySQL, Flat files, and XML files, each with illustrated hands-on examples for the different technologies. Your learning experience will be made all the more rich with chapters introducing, explaining and leveraging additional ODI functionality such as variables, reusable procedures, temporary indexes and more.

Authors

David Hecksel

David Hecksel is a Principal Data Integration Architect at Oracle. Residing in Dallas Texas, David joined Oracle in 2006 as a pre-sales Architect for Oracle Fusion Middleware. Six months after joining, David volunteered to add pre-sales coverage for a recently acquired product called Oracle Data Integrator and the rest (including the writing of this book) has been a labor of love working with a platform and solution that simultaneously provides phenomenal user productivity and system performance gains to the traditionally separate IT career realms of Data Warehousing, Service Oriented Architects, and Business Intelligence developers. Before joining Oracle, David spent six years with Sun Microsystems in their Sun Java Center, was CTO for 4 years at Axtive Software architecting and developing several one-to-one marketing and web personalization platforms such as e.Monogram. In 1997, David also invented, architected, developed, and marketed online the award-winning JCertify product – the industry's first electronic delivery of study content and exam simulation for the Certified Java Programmer exam. Prior to Axtive Software, David was with IBM for 12 years as a software developer working on operating system, storage management, and networking software products. David holds a BS Computer Science degree from the University of Wisconsin-Madison and a Masters of Business Administration from Duke University.

Bernard Wheeler

Bernard Wheeler is a Customer Solutions Director at Oracle in the UK, where he has a focus on Information Management. He has been at Oracle since 2005, working in pre-sales technical roles covering Business Process Management, SOA, and Data Integration technologies and solutions. Before joining Oracle, Bernard held various pre-sales, consulting, and marketing positions with vendors such as Sun Microsystems, Forte Software, Borland, and Sybase as well as working for a number of systems integrators. Bernard holds an Engineering degree from Cambridge University.

Peter C. Boyd-Bowman

Peter C. Boyd-Bowman is a Technical Director and Consultant with the Oracle Corporation. He has over 30 years of software engineering and database management experience, including 12 years of focused interest in data warehousing and business intelligence. Capitalizing on his extensive background in Oracle database technologies dating back to 1985, he has spent recent years specializing in data migration. After many successful project implementations using Oracle Warehouse Builder, and shortly after Oracle's acquisition of the Sunopsis Corporation, he switched his area of focus over to Oracle's flagship ETL product: Oracle Data Integrator. Peter holds a BS degree in Industrial Management and Computer Science from Purdue University and currently resides in North Carolina.
Peter is a co-author of the book Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial.

Julien Testut

Julien Testut is a Product Manager in the Oracle Data Integration group focusing on Oracle Data Integrator. Julien has an extensive background in Data Integration and Data Quality solutions and is a co-author of Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial. Prior to joining Oracle, he was an Applications Engineer at Sunopsis, which was then acquired by Oracle. Julien holds a Masters degree in Software Engineering.

Denis Gray

Denis Gray is a Director of Product Management for Data Integration at Oracle. Denis has over 15 years of experience in the data-integration field. For the past seven years, Denis has been an integral part of Oracle Development Organization as a Product Manager within Fusion Middleware, delivering data integration solutions. Prior to this, Denis was a data integration consult for Hyperion Solutions (Oracle). Here, Denis worked at many of the largest Fortune 100 companies, building data warehouses and implementing business intelligence solutions. Denis has a Bachelor's Degree in Computer Science from the University of Missouri and currently resides in St. Louis, MO. Denis also co-authored the Packt book Getting Started with Oracle Data Integrator 11g: A Hands-on Tutorial.

Christophe Dupupet

Christophe Dupupet is a Director in the Fusion Middleware Architects Team, where he leads the expertise on ODI. The team works closely with strategic customers that implement ODI, and helps define best practices on the product in terms of architecture, implementation, and operations.
Prior to Oracle, Christophe was part of the team that started the operations for Sunopsis in the US, where he lead the technical team (presales, support, and training). Sunopsis was acquired by Oracle in 2006.
Christophe holds an Operations Research degree from EISTI in France, a Masters Degree in Operations Research from Florida Tech, and a certificate in Management from Harvard University.

Alerts & Offers

Series & Level

We understand your time is important. Uniquely amongst the major publishers, we seek to develop and publish the broadest range of learning and information products on each technology. Every Packt product delivers a specific learning pathway, broadly defined by the Series type. This structured approach enables you to select the pathway which best suits your knowledge level, learning style and task objectives.

Learning

As a new user, these step-by-step tutorial guides will give you all the practical skills necessary to become competent and efficient.

Beginner's Guide

Friendly, informal tutorials that provide a practical introduction using examples, activities, and challenges.

Essentials

Fast paced, concentrated introductions showing the quickest way to put the tool to work in the real world.

Cookbook

A collection of practical self-contained recipes that all users of the technology will find useful for building more powerful and reliable systems.

Blueprints

Guides you through the most common types of project you'll encounter, giving you end-to-end guidance on how to build your specific solution quickly and reliably.

Mastering

Take your skills to the next level with advanced tutorials that will give you confidence to master the tool's most powerful features.

Starting

Accessible to readers adopting the topic, these titles get you into the tool or technology so that you can become an effective user.

Progressing

Building on core skills you already have, these titles share solutions and expertise so you become a highly productive power user.