The ODI SDK Java classes provide complete administration capabilities including the ability to create and upgrade Master and Work repositories. In this recipe, we will be developing a Groovy script that creates a Master and a Work repository, allowing developers embedding ODI into their own applications to automate this task.
With the ODI SDK, you can fully implement the repositories creation in only a few lines of code. You can follow the instructions using the Groovy editor in ODI Studio 18.104.22.168 and higher. You need to have two Oracle schemas created,
SDK_WREP, and grant the
RESOURCE database roles to those schemas. To keep it simple we have used ...