Free Sample
+ Collection

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

David Hecksel, Bernard Wheeler, Peter C. Boyd-Bowman, Julien Testut, Denis Gray, Christophe Dupupet

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.
RRP $35.99
RRP $59.99
Print + eBook

Want this title & more?

$12.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
Chapter 2: Product Installation
Installing ODI 11g
Post installation—parameter files review
Chapter 3: Using Variables
Defining variables
Using variables for dynamic information
Using variables to alter workflows
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
Chapter 5: Working with Databases
Sample scenario description
Exercise 1: Building the Load_Customer interface
Chapter 6: Working with MySQL
What you can and can't do with MySQL
Working with MySQL
Using MySql with ODI
Chapter 7: Working with Microsoft SQL Server
Example: Working with SQL Server
Sample scenario
Chapter 8: Integrating File Data
Working with flat files
Step-by-step example
Chapter 9: Working with XML Files
Introduction to XML
Introducing the ODI JDBC driver for XML
Example: Working with XML files
Chapter 10: Creating Workflows—Packages and Load Plans
Load Plans
Chapter 11: Error Management
Managing data errors
Managing execution errors
Handling operational errors
Chapter 12: Managing and Monitoring ODI Components
Scheduling with Oracle Data Integrator
Fusion Middleware Console Control
Oracle Data Integrator Console
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
  • Orchestrate your data integration processing by designing ODI packages and scenarios 
  • Discover how to develop ODI interfaces in order to effortlessly move data between servers and files 
  • Get the full lowdown on both Error Processing and Management and Monitoring
  • Give your knowledge a boost with in-depth coverage of various data sources and targets including Oracle, Microsoft SQL Server and XML files
  • Master key ODI concepts like Physical and Logical Architectures or the Knowledge Modules
  • Take advantage of expert advice from the authors’ combined 15 years of ODI experience

In Detail

Oracle Data Integrator (ODI) is Oracle's strategic data integration platform for high-speed data transformation and movement between different systems. From high-volume, SOA-enabled data services, to trickle operations – ODI is a cutting-edge platform that offers heterogeneous connectivity, enterprise-level deployment, and strong administrative, diagnostic, and management capabilities.

"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.

Finally ODI's workflow and task orchestration capabilities are explained before introducing you to Error Management with ODI's built-in 'error hospital' and 'error recycling' capabilities for non-compliant data, not to mention tackling ODI Studio, ODI Console and Enterprise Manager Fusion Middleware Control.


Read More

Recommended for You

Oracle Information Integration, Migration, and Consolidation
$ 32.99