Book Image

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

Book Image

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

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.

Related Content you might be interested in

Current Title:

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

Fusion Middleware Console Control

Management and monitoring capabilities are required for virtually all enterprise class software projects. In addition, audit requirements have become increasingly important to businesses of all sizes.

ODI addresses management and monitoring requirements through integration with Enterprise Manager Fusion Middleware Control Console (FMCC). The FMCC provides current visibility into the health and key performance and activity metrics for the ODI Agent, Master and Work repositories and integration with the ODI Console web application.

Taking a hands-on approach to the FMCC, the following FMCC features and capabilities are illustrated in this section:

  • Illustrate how to launch and access the diverse and rich management and monitoring capabilities for an ODI domain

  • Examine reports on the health, key performance, and activity metrics of the ODI runtime agent(s)

  • Define once, control, and reconfigure anywhere

  • Examine the ODI log files visibility and management within the...

Previous Section
End of Section 3
Next Section