O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required