After our collaboration on the ODI book Getting Started with Oracle Data Integrator 11g: A
Hands-on Tutorial, we thought that there might be a need for a more advanced book on the
same subject. So when Packt Publishing approached us to see if it would be possible to write
a Cookbook on ODI, we knew that we had the medium for this new adventure. Our objective
with this book was to avoid any repetition from the first book and to offer recipes that go
beyond what is readily available in the ODI documentation and on the Web. Hopefully, you
will agree that we have achieved our goal.
What this book covers
Chapter 1, Installation, Deployment, and Configuration, answers several deployment
questions that we have been asked by ODI users over time. A hands-on approach to these
topics allows the reader to learn the answers that we regularly give to our counterparts.
Chapter 2, Defining the Oracle Data Integrator Security, expands the descriptions available
in the ODI documentation with “how-to” examples by providing recipes to implement several
different aspects of ODI security.
Chapter 3, Advanced Topology, delves into Topology beyond the definition of servers and
schemas. These recipes will explore specific elements of Topology that are not typically
explored by the average ODI user: definition of new technologies and datatypes, use of
actions, and controlling case sensitivity.
Chapter 4, Using Variables, expands the use of variables by implementing them in ways not
often documented within the product, such as using variables in resource names and how
to best use variables as parameters.
Chapter 5, Knowledge Module Internals, will shed new light on what is possible with KMs,
explaining how substitution methods are processed by ODI and even experimenting with
Java code inside the KMs
Chapter 6, Inside Knowledge Modules – SCD and CDC, offers an opportunity to expand on
the concepts covered in the previous chapter by focusing on KMs that may not be well known
or well understood. We will also experiment with a few alterations of these KMs to provide an
even more hands-on experience.
Chapter 7, Advanced Coding Techniques, begins by looking into code generation that can
be performed directly from the models using diagrams. This chapter then explores specific
advanced topics such as temporary interfaces, embedded SQL queries, pivots, and partition
Chapter 8, Package Loop and File Processing, was written because we noticed that too many
users limit their workflows by not knowing how to use them for more mature integration
techniques. The recipes in this chapter demonstrate some of the more sophisticated
integration techniques, including a focus on flat files processing that will help a developer
greater take advantage of ODI orchestration.
Chapter 9, XML and Web Services, discusses two areas of growing importance within ETL
processing: using XML files as input and using web services. Recipes will start with the basics
of the definition of an XML file and go all the way to invoking web services with callbacks.
Chapter 10, Advanced Coding Techniques Using the SDK, is rich in sample code that
automates tasks usually done with the graphical interface, including installation,
development, and execution monitoring.
Chapter 11, More with ODI, is a catch-all chapter that addresses questions we’ve often had
to answer, including misconceptions on how the product should be used, and little known
secrets that we didn’t want to leave aside.
Who this book is for
This book has been designed to present the reader with solutions to specific problems that
sometimes challenge even the most accomplished ODI developer. As such, it is not meant to
teach the fundamentals of the ODI product, but rather to extend the reader’s understanding
of Oracle Data Integrator’s capabilities. In order to expedite the presentation of the material
within this book, there is an assumption that the reader already has a basic understanding
of the ODI product and has ready access to a database. For those readers looking for an
introduction to ODI, we recommend the book Getting Started with Oracle Data Integrator
11g: A Hands-on Tutorial by Packt publishing