Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
  • Table Of Contents Toc
  • Feedback & Rating feedback
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

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

4.1 (15)
Buy this Book
close
close
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial

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

4.1 (15)
Buy this Book

Overview of this book

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 (21 chapters)
close
close
close
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
Icon
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
Credits
Icon
Credits
Foreword
chevron up
Icon
Foreword
About the Authors
Icon
About the Authors
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Free Chapter
1
Product Overview
Icon
Product Overview
Icon
ODI product architecture
Icon
ODI key concepts
Icon
Summary
2
Product Installation
Icon
Product Installation
Icon
Prerequisites
Icon
Installing ODI 11g
Icon
Post installation—parameter files review
Icon
Summary
3
Using Variables
Icon
Using Variables
Icon
Defining variables
Icon
Using variables for dynamic information
Icon
Using variables to alter workflows
Icon
Summary
4
ODI Sources, Targets, and Knowledge Modules
Icon
ODI Sources, Targets, and Knowledge Modules
Icon
Defining Physical Schemas, Logical Schemas, and Contexts
Icon
Reverse-engineering metadata into ODI models
Icon
Examining the anatomy of the interface flow
Icon
Importing and choosing Knowledge Modules
Icon
Examining ODI Interfaces
Icon
Summary
5
Working with Databases
Icon
Working with Databases
Icon
Sample scenario description
Icon
Exercise 1: Building the Load_Customer interface
Icon
Summary
6
Working with MySQL
Icon
Working with MySQL
Icon
What you can and can't do with MySQL
Icon
Working with MySQL
Icon
Using MySql with ODI
Icon
Summary
7
Working with Microsoft SQL Server
Icon
Working with Microsoft SQL Server
Icon
Example: Working with SQL Server
Icon
Sample scenario
Icon
Summary
8
Integrating File Data
Icon
Integrating File Data
Icon
Working with flat files
Icon
Step-by-step example
Icon
Summary
9
Working with XML Files
Icon
Working with XML Files
Icon
Introduction to XML
Icon
Introducing the ODI JDBC driver for XML
Icon
Example: Working with XML files
Icon
Summary
10
Creating Workflows—Packages and Load Plans
Icon
Creating Workflows—Packages and Load Plans
Icon
Packages
Icon
Load Plans
Icon
Summary
11
Error Management
Icon
Error Management
Icon
Managing data errors
Icon
Managing execution errors
Icon
Handling operational errors
Icon
Summary
12
Managing and Monitoring ODI Components
Icon
Managing and Monitoring ODI Components
Icon
Scheduling with Oracle Data Integrator
Icon
Fusion Middleware Console Control
Icon
Oracle Data Integrator Console
Icon
Summary
13
Concluding Remarks
Icon
Concluding Remarks
Index
Icon
Index

Foreword

The May 26, 2011 edition of the Economist magazine cites a report by the the McKinsey Global Institute (MGI) about data becoming a factor of production, such as physical or human capital. Across the industry, enterprises are investing significant resources in harnessing value from vast amounts of data to innovate, compete, and reduce operational costs.

In light of this global focus on data explosion, data revolution, and data analysis the authors of this book couldn't have possibly chosen a more appropriate time to share their unique insight and broad technical experience in leveraging Oracle Data Integrator (ODI) to deliver key data integration initiatives across global enterprises.

Oracle Data Integrator constitutes a key product in Oracle's Data Integration product portfolio. ODI product architecture is built on high performance ELT, with guiding principles being: ease of use, avoiding expensive mid-tier transformation servers, and flexibility to integrate with heterogeneous platforms.

I am delighted that the authors, six of the foremost experts on Oracle Data Integrator 11g have decided to share their deep knowledge of ODI in an easy to follow manner that covers the subject material both from a conceptual and an implementation aspect. They cover how ODI leverages next generation Extract-Load-Transformation technology to deliver extreme performance in enabling state of the art solutions that help deliver rich analytics and superior business intelligence in modern data warehousing environments. Using an easy-to-follow hands-on approach, the authors guide the reader through successively complex and challenging data integration tasks—from the basic blocking and tackling of creating interfaces using a multitude of source and target technologies, to more advanced ODI topics such as data workflows, management and monitoring, scheduling, impact analysis and interfacing with ODI Web Services. If your goal is to jumpstart your ODI 11g knowledge and productivity to quickly deliver business value, you are on the right track. Dig in, and Integrate.

Alok Pareek

Vice President, Product Management/Data Integration

Oracle Corp

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
Next Chapter

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY