Creating the Master and Work repositories using the SDK
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 188.8.131.52 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 ...