Creating Repositories in ODI 220.127.116.11:
Today we are going to create master and work repository in ODI 18.104.22.168. 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.
Remember the ID of master repository.
Now click on Connect to repository and you will get below popup window. Then click on the plus symbol.
Here provide a ID other than the ID supplied in master repository.
After finish disconnect master repository as given in below screenshot.
Thats all. Now you can see the designer tab enabled.
Comments are always welcome.