Creating Repositories in ODI 11.1.1.5

Creating Repositories in ODI 11.1.1.5:

Today we are going to create master and work repository in ODI 11.1.1.5. We can create it using ODI Studio or using RCU. Lets start with ODI Studio.

1st you have to create 3 user as follows.
1. User for master repository (Any name)
2. User for work repository (Any name )
3. User with dba privilege (Here username should be sysdba)

create user sysdba identified by system
grant connect,resource to sysdba
grant dba to sysdba

create user odi_master_user identified by odi
grant connect,resource to odi_master_user

create user odi_work_user identified by odi
grant connect,resource to odi_work_user

If you want to provide tablespace then just append below query in every create user statement.

default tablespace users temporary tablespace temp

Now open ODI Studio. Press CTRL+N on keyboard.

createrep1

createrep2

Remember the ID of master repository.

createrep3

 

createrep4

 

createrep5
createrep6
createrep7

Now click on Connect to repository and you will get below popup window. Then click on the plus symbol.

createrep8

createrep9
createrep10
createrep11
createrep12

Here provide a ID other than the ID supplied in master repository.

createrep13
createrep14

After finish disconnect master repository as given in below screenshot.

createrep17
Click again on connect repository and select the work repository from dropdown. Now provide the password SUNOPSIS and then click OK.

createrep18

 

Thats all. Now you can see the designer tab enabled.

Comments are always welcome.

0

About the author

Bhabani(http://dwteam.in) - Currently Bhabani is working as Sr Development Engineer at Harman International. He has good expertise on Oracle, Oracle Data Integrator, Pervasive Data Integrator, MSBI, Talend and Java. He is also contributing in ODI-OTN forum for last 5 years. He is from India. If you want to reach him then please visit contact us page. If you have any doubts or concerns on the above article, please put your question here. Dw Team will try to respond it as soon as possible. Also dont forget to provide your comments / suggestions / feedback for further improvement. Thanks for your time.

Similar Posts

4 comments

Please provide the details.
Can you please tell the procedure to create physical and logical schema with snapshots and what are all the initial steps to create a transformations in ODI11g

Hi ,
I have gone through your assignment it’s really good.

Could you tell me if I created the 2nd WORK REPOSITORY i.e. WORKREP23, then I am not able to log in using the 1st WORK REPOSITORY i.e. odi_work_rep.

Could you tell me, why this is happened?

If I want to log-in using both 1st and 2nd WORK REPOSITORY , then it is possible?

AT any point of time you can only login to one work repository. However you can see all the work repository name including the current one you have logged on but all of them must be associated with one master repository

Hi,

How do we connect to multiple environment using ODI studio? We have a DEV and TEST environment with different master repositories. We have copied one set of cwallet and jps*.xml files in the client directory. This is causing issues where we couldn’t connect to multiple environments. Any suggestions for this issue?

Thanks,
Dinesh Veera

Leave a replay to Dinesh Veera Cancel reply

required*

Are you a human? *