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

Modifying and expanding datatypes


ODI is not limited to the datatypes that it knows out of the box. In this recipe, we will create an entirely new datatype and we will leverage it in an interface to see how it can be handled.

Getting ready

For this recipe, you will need a project where the following KMs have been imported:

  • LKM SQL to Oracle

  • IKM SQL Control Append

How to do it...

  1. First we will create a new datatype in the database. You can do this with many databases; our example here is with Oracle. Use your favorite tool to connect to the database (SQL+, SQL Developer, Toad, and so on). If you re-created the environment described in the Preface of this book, log in as the owner of the source schema DEMO_SRC and enter the following commands:

    create type FULL_SALARY AS OBJECT (BASE_SALARY number(8), BONUS_SALARY number(8));
    
    create table SRC_YEARLY_SALARY (
      EMP_ID number(4),
      YEAR  number(4),
      SALARY full_salary);
  2. Go to ODI Topology. If you followed the first recipe of this chapter, you...