Working with more than one work repository in Console

 

When we are working on more than two different work repositories, we should not configure the work repository with the same schema, if it does then the latest configuration will be saved ( it will show the pop-up as below)

If we click NO, then it will save the latest one else it will re-attach the WR.

If we want to get the projects created in two different work repositories separately in ODI Console, then first we need to configure the work repository details in WebLogicConsole.

Go to weblogic console -> Services -> Datasource ->new->generic data store

The JNDI Name in WLS console and Work JNDI Url should be same; if not the selected work repository details will not be displayed in odi console.

 

Click next

Next, we need to configure in ODI Console also, so that we will get the projects, scenarios etc. in ODI console also.

Configuring Repository in ODI console

Login to the ODI console with MR then goto-> management->Repository Connections->create

After clicking create a pop up will come, where we need to configure the WR.

Connection alias name: Name of WR to be displayed while logging in ODI Console.

Master JNDI URL: JNDI URL of the datasource to connect the master repository database.

Example: jdbc/odiMasterRepository

Supervisor Key: user name of the ODI having supervisor privileges, recommended to use SUPERVISOR.

Work JNDI URL: JNDI URL of the datasource to connect the work repository database. If no value is given in this field, the repository connection will allow connection to the master only, and the Navigation will be limited to Topology information.

The name which we gave at weblogic console (JNDI name), same should be given here too

Example: jdbc/odiWorkRepository

JNDI URL in JNDI Standard format?: Check this option if you want to use the Environment Naming Context (ENC). When this option is checked, Oracle Data Integrator Console automatically prefixes the data source name with the string java:comp/env/ to identify it in the application server's JNDI directory. Note that the JNDI Standard is not supported by Oracle WebLogic Server or for global data sources.

For example: jdbc/odiWorkRepository

Default: Check this option if you want this Repository Connection to be selected by default on the login page.

Then the name given at connection alias name will be displayed while logging into ODI Console.

Select the WR and give the credentials to login.