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”
February 29, 2016 at 12:04 PM
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,
Aakash
July 30, 2015 at 2:28 AM
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?
September 9, 2010 at 7:30 AM
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.