Sign In Start Free Trial
Account

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

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
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
In Progress | 0 / 1 sections completed | 0%
Credits
In Progress | 0 / 1 sections completed | 0%
Foreword
In Progress | 0 / 1 sections completed | 0%
About the Authors
In Progress | 0 / 1 sections completed | 0%
About the Reviewers
In Progress | 0 / 1 sections completed | 0%
www.PacktPub.com
In Progress | 0 / 1 sections completed | 0%
Preface
In Progress | 0 / 1 sections completed | 0%
Free Chapter
1
Product Overview
In Progress | 0 / 4 sections completed | 0%
2
Product Installation
In Progress | 0 / 5 sections completed | 0%
5
Working with Databases
In Progress | 0 / 4 sections completed | 0%
6
Working with MySQL
In Progress | 0 / 5 sections completed | 0%
7
Working with Microsoft SQL Server
In Progress | 0 / 4 sections completed | 0%
8
Integrating File Data
In Progress | 0 / 4 sections completed | 0%
10
Creating Workflows—Packages and Load Plans
In Progress | 0 / 4 sections completed | 0%
11
Error Management
In Progress | 0 / 5 sections completed | 0%
13
Concluding Remarks
In Progress | 0 / 1 sections completed | 0%
Index
In Progress | 0 / 1 sections completed | 0%

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

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

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

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