Book Image

Oracle Data Integrator 11g Cookbook

By : Christophe Dupupet, Peter Boyd-Bowman, Julien Testut, Denis Gray
Book Image

Oracle Data Integrator 11g Cookbook

By: Christophe Dupupet, Peter Boyd-Bowman, Julien Testut, Denis Gray

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 batches, to 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."Oracle Data Integrator 11g Cookbook" will take you on a journey past your first steps with ODI to a new level of proficiency, lifting the cover on many of the internals of the product to help you better leverage the most advanced features.The first part of this book will focus on the administrative tasks required for a successful deployment, moving on to showing you how to best leverage Knowledge Modules with explanations of their internals and focus on specific examples. Next we will look into some advanced coding techniques for interfaces, packages, models, and a focus on XML. Finally the book will lift the cover on web services as well as the ODI SDK, along with additional advanced techniques that may be unknown to many users.Throughout "Oracle Data Integrator 11g Cookbook", the authors convey real-world advice and best practices learned from their extensive hands-on experience.
Table of Contents (19 chapters)
Oracle Data Integrator 11g Cookbook
About the Authors
About the Reviewers

Generating interfaces from data models or diagrams

Another often overlooked feature of ODI is its ability to generate interfaces from either data models or model diagrams. By selecting one or more data stores from a data model or diagram, ODI can create either an inbound or outbound interface capable of moving data in or out of the specified data store.

Getting ready

In this recipe, we will generate three such interfaces and compare the results. To follow along with the examples listed here, you will need an ODI project with at least the following KMs: LKM SQL to SQL, IKM SQL Control Append, and IKM Oracle Incremental Update. From a resource perspective, you will need to have imported the DEMO_SRC and DEMO_TRG data models as described in the Preface.

How to do it...

  1. To create the first two examples, expand and right-click on the DEMO_TRG data model and select the Generate Interfaces IN option.

  2. Use the browse magnifying-glass to select the folder into which the procedure will be generated....