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.

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

Starting
David Hecksel et al.

1 customer reviews
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.
$10.00
$59.99
RRP $59.99
RRP $59.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 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.

+ Collection
Free Sample

Book Details

ISBN 139781849680684
Paperback384 pages

Book Description

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.

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
  • 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

Authors

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

Book Details

ISBN 139781849680684
Paperback384 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

Do more with SOA Integration: Best of Packt
$ 10.00
Oracle Information Integration, Migration, and Consolidation
$ 10.00