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.
Preview in Mapt

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

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.

Quick links: > What will you learn?> Table of content> Product reviews

Mapt Subscription
FREE
$29.99/m after trial
eBook
$25.20
RRP $35.99
Save 29%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$25.20
$59.99
$29.99 p/m after trial
RRP $35.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial Book Cover
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
$ 35.99
$ 25.20
Oracle Data Integrator 11g Cookbook Book Cover
Oracle Data Integrator 11g Cookbook
$ 32.99
$ 23.10
Buy 2 for $35.00
Save $33.98
Add to Cart

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

Oracle Data Integrator 11g Cookbook Book Cover
Oracle Data Integrator 11g Cookbook
$ 32.99
$ 23.10
Oracle Database 11gR2 Performance Tuning Cookbook Book Cover
Oracle Database 11gR2 Performance Tuning Cookbook
$ 32.99
$ 23.10
Getting Started with Oracle Hyperion Planning 11 Book Cover
Getting Started with Oracle Hyperion Planning 11
$ 35.99
$ 25.20
Oracle Goldengate 11g Complete Cookbook Book Cover
Oracle Goldengate 11g Complete Cookbook
$ 41.99
$ 29.40
Oracle Essbase 11 Development Cookbook Book Cover
Oracle Essbase 11 Development Cookbook
$ 35.99
$ 25.20
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos Book Cover
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos
$ 38.99
$ 27.30