O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required