Book Image

Oracle Data Integrator 11g Cookbook

Book Image

Oracle Data Integrator 11g Cookbook

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
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Using diagrams to develop and maintain models


During the course of application development, there are times when it may be necessary to migrate data from one system technology to another. In the simplest of cases, the structure of the given object may require only minimal changes such as data type conversions. Using ODI diagrams to perform these basic functions is an easy way to accomplish these tasks.

Getting ready

In order to follow this recipe, it is assumed that the reader has performed the preliminary installation steps outlined in the Preface. If these steps were done correctly, the reader should already have a DEMO_FILE data model containing two flat file data stores and a DEMO_TRG model that defines objects found in the DEMO_TRG database schema.

Now, let's suppose that we wish to quickly build an application that migrates data from a flat file into a database table. What we will do in this recipe is to use an ODI diagram to automatically construct a database data store based upon...