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

by David Hecksel, Bernard Wheeler, Peter Boyd-Bowman

<!--[if gte mso 9]> <![endif][if gte mso 9]> Normal 0 false false false EN-US X-NONE X-NONE <![endif][if gte mso 9]> <![endif][if gte mso 10]> /* Style Definitions */ table.MsoNormalTable {"Table Normal"; ""; 5.4pt 0in 5.4pt; %; "Calibri","sans-serif"; "Times New Roman"; } <![endif]--> Combine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guide In Detail 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 11 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 11 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. "Getting Started with Oracle Data Integrator 11 A Hands-On Tutorial" is a practical tutorial bursting with tips, illustrations and real-world best practices to get you on your way with ODI. If you are a software/ETL developer or database administrator who is new to Oracle Data Integrator but want to get hands-on with the product quickly, then "Getting Started with Oracle Data Integrator 11 A Hands-On Tutorial" is for you. You should have some experience with databases, SQL and ETL technologies.

384 pages, 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.