Warning: Illegal string offset 'ssb_og_tags' in /home/content/10/4632510/html/wp-content/plugins/simple-social-buttons/simple-social-buttons.php on line 1466


The blog for Oracle Data Integrator ( ODI )

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

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”


  1. Hi, I have given dba access to my super user and still getting odi-23049 error. Can you please help me with this error.
    Thanks in advance,

  2. Hi Cezar,

    we have master and work repository having one to many relationship.
    Can two work repositories sharing one single Master repository reside on same schema of Database?

  3. Thanks guys for the great work you are doing!!

    Looking at that post I was wondering about RCU (Repository Creation Utility) … is there anybody who has used it to create their 11g repositories … was just wondering.

Leave a Reply

Required fields are marked *.

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