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

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

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