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

by David Hecksel, Peter C. Boyd Bowman, Denis Gray

About the Book: Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial Oracle Data Integrator (ODI) is Oracle's strategic dataintegration platform for high-speed data transformation andmovement between different systems. From high-volume, SOA-enableddata services, to trickle operations-ODI is a cutting-edge platformthat offers heterogeneous connectivity, enterprise-leveldeployment, and strong administrative, diagnostic, and managementcapabilities. "Getting Started with Oracle Data Integrator 11g: A Hands-OnTutorial" provides you with everything you to get up and runningwith Oracle Data Integrator, and more! Following an examplescenario, the book covers essential information about the ODIarchitecture and using ODI across different databases (Oracle,Microsoft SQL Server and MySQL), and file types such as XML, beforecovering Orchestrating Data Integration Workflows, ErrorManagement, Operational Management and Monitoring, and beyond. "Getting Started with Oracle Data Integrator 11g: A Hands-OnTutorial" begins by describing the Oracle Data Integratorarchitecture and teaching you to install the product following bestpractices. You'll then be introduced to some of the key concepts ofODI such as the Knowledge Modules. Later topics include moving and transforming data from sourcesto targets including the Oracle Database, Microsoft SQL Server,MySQL, Flat files, and XML files, each with illustrated hands-onexamples for the different technologies. Your learning experiencewill be made all the more rich with chapters introducing,explaining and leveraging additional ODI functionality such asvariables, reusable procedures, temporary indexes and more. Finally ODI's workflow and task orchestration capabilities areexplained before introducing you to Error Management with ODI'sbuilt-in 'error hospital' and 'error recycling' capabilities fornon-compliant data, not to mention tackling ODI Studio, ODI Consoleand Enterprise Manager Fusion Middleware Control. Contents Chapte

Paperback

First published April 29, 2012

Reviews

[Sarah · Rating 4 out of 5]

For a technical book, this is very straight-forward and clear. There is a good balance between text narrative and screenshots, and the explanations are thorough yet concise. In particular, the first chapter is an excellent overview to the Oracle Data Integrator product and gives a great introduction to its topology as well as the general workflow involved in using this product for development.