The blog for Oracle Data Integrator ( ODI )

11g Oracle Data Integrator – Part 2/11g – Creating Repositories

Hello Dear Readers 😉

Nothing better to start our analysis that the real first step to start an Oracle Data Integrator 11g environment. It’s means REPOSITORIES!

The visual interface is all new but the functionality is just the same… I liked this new interface to create “ODI things” once it’s just one place to do all.

The big difference from 10g version is that, now, is possible to define a “external user validation” since the Master Repository creation. Pretty good to security protocols!

Let’s show you the screen and process to create the repositories… it will allow all of you to see the new design and learn how to manipulate it:

When you First Login to ODI Studio, you will see an option to connect to Repository.


Creating Master Repository

File – > New -> Master Repository Creation Wizard

For this post we are going with ODI authentication , the default  SUPERVISOR password is still  SUNOPSIS.

Click Finish for ODI to create the required Master Repository. Once completed Login into Topology.

Click Connect to Repository and furnish the required information,similar to 10g

Creating Work Repository

Once logged in , Go to Repositories and Right click on  Work Repositories  – > New Work Repository

You can specify the password for ODI Work Repository , as any one trying to open the Work Repository need to enter the password created now.

Provide the ID and Name of the Work Repository and click Finish and once created .

Click Connect to Repository and provide the necessary details and also selec the Work repository and once done Login into Designer.

Well guys, as you can see, it’s not so different from previous version but, in my opinion, looks really better!!!!!

See you all in the “3/11g post”


Leave a Reply

Required fields are marked *.

This site uses Akismet to reduce spam. Learn how your comment data is processed.