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 ...

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.