Creating models and datastores using the SDK

The SDK offers full control over the metadata defined in the ODI repositories. Developers can write scripts to create or modify datastores, models, as well as other artifacts linked to those objects such as constraints. In this recipe, we will be adding two new models and datastores to our environment.

Getting ready

You can follow the instructions using the Groovy editor in ODI Studio and higher. In this recipe, we will reuse the repositories created in the recipe Creating the Master and Work repositories using the SDK. Follow the necessary steps of this recipe to create them. You can also use the Repository Creation Utility (RCU) or ODI Studio. You will also need to create the DEMO_SRC

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.