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

Creating an interface using the SDK


It is possible to create design-time objects such as interfaces using the ODI SDK Java classes. This can be very useful to build dynamic interfaces on the fly using metadata contained in excel spreadsheets or flat files, or to simply design data flows without using the GUI.

Getting ready

You can follow the instructions using the Groovy editor in ODI Studio 11.1.1.6 and higher. In this recipe, we will reuse the project created in the recipe Creating a project using the SDK and the models and datastores created in the recipe Creating models and datastores using the SDK. Follow the necessary steps to create the required objects; you can also create them manually from ODI Studio.

This recipe uses two Oracle tables called SRC_EMP and TRG_EMP described in the Preface of this book. No other prerequisites are required.

How to do it...

  1. Follow steps 1 and 2 from the recipe Creating a project using the SDK.

  2. Import classes that are specific to interfaces, such as InteractiveInterfaceHelperWithActions...