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 11.1.1.6 and higher. You need to have two Oracle schemas created, SDK_MREP
and SDK_WREP
, and grant the CONNECT
and RESOURCE
database roles to those schemas. To keep it simple we have used the schema names as their passwords. No other prerequisites are required.