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.

Getting ready

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.

How to do it...

1. In ODI Studio, go to Tools, then click on Groovy and select New Script, as you can see in the following screenshot:

   

2. In order to use the ODI SDK to create the...