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.
Table of Contents (21 chapters)
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
10
Creating Workflows—Packages and Load Plans
13
Concluding Remarks
Index

About the Authors

Peter C. Boyd-Bowman is a Technical Consulting Director with the Oracle Corporation. He has over 30 years of software engineering and database management experience, including 12 years of focused interest in data warehousing and business intelligence. Capitalizing on his extensive background in Oracle database technologies dating back to 1985, he has spent recent years specializing in data migration. After many successful project implementations using Oracle Warehouse Builder and shortly after Oracle's acquisition of the Sunopsis Corporation, he switched his area of focus over to Oracle's flagship ETL product: Oracle Data Integrator. He holds a BS degree in Industrial Management and Computer Science from Purdue University and currently resides in North Carolina.

Christophe Dupupet is a Director of Product Management for ODI at Oracle. In this role, he focuses on the Customer Care program where he works closely with strategic customers implementing ODI. Prior to Oracle, he was part of the team that started the operations for Sunopsis in the US (Sunopsis created the ODI product and was acquired by Oracle in 2006).

He holds an Operations Research degree from EISTI in France, a Masters Degree in Operations Research from Florida Tech, and a Certificate in Management from Harvard University.

He writes blogs (mostly technical entries) at http://blogs.oracle.com/dataintegration as well as white papers.

David Hecksel is a Principal Data Integration Architect at Oracle. Residing in Dallas, Texas, he joined Oracle in 2006 as a Pre-sales Architect for Oracle Fusion Middleware. Six months after joining, he volunteered to add pre-sales coverage for a recently acquired product called Oracle Data Integrator and the rest (including the writing of this book) has been a labor of love working with a platform and solution that simultaneously provides phenomenal user productivity and system performance gains to the traditionally separate IT career realms of Data Warehousing, Service Oriented Architects, and Business Intelligence developers. Before joining Oracle, he spent six years with Sun Microsystems in their Sun Java Center and was CTO for four years at Axtive Software, architecting and developing several one-to-one marketing and web personalization platforms such as e.Monogram. In 1997, he also invented, architected, developed, and marketed the award-winning JCertify product online—the industry's first electronic delivery of study content and exam simulation for the Certified Java Programmer exam. Prior to Axtive Software, he was with IBM for 12 years as a Software Developer working on operating system, storage management, and networking software products. He holds a B.S. in Computer Science from the University of Wisconsin-Madison and a Masters of Business Administration from Duke University.

Julien Testut is a Product Manager in the Oracle Data Integration group focusing on Oracle Data Integrator. He has an extensive background in Data Integration and Data Quality technologies and solutions. Prior to joining Oracle, he was an Applications Engineer at Sunopsis which was then acquired by Oracle. He holds a Masters degree in Software Engineering.

Bernard Wheeler is a Customer Solutions Director at Oracle in the UK, where he focuses on Information Management. He has been at Oracle since 2005, working in pre-sales technical roles covering Business Process Management, SOA, and Data Integration technologies and solutions. Before joining Oracle, he held various pre-sales, consulting, and marketing positions with vendors such as Sun Microsystems, Forte Software, Borland, and Sybase as well as worked for a number of systems integrators. He holds an Engineering degree from Cambridge University.