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.
You can follow the instructions using the Groovy editor in ODI Studio 188.8.131.52 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 ...