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

Get Oracle Data Integrator 11g Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.