ODIConsole Installation

Metadata Navigator is for ODI 10g and its named as odiconsole in 11g

And you will need a standalone weblogic server to deploy the odiconsoel.jar. In ODI, we can choose the option of deploying ODIconsole at the time of installation itself. Or it can extendede to deply it later

Note:

• Weblogic 10.3.5 is needed to host the ODIconsole of version 11.1.1.5
• Also Installing ODI on 64 bit machine does not support 64 bit JDK. Its a known bug in ODI 11g. so  a 32-bit JDK is needed to start up the ODIStudio

Below are the steps to install ODI standalone agent as well the ODIConsoel.


PreRequisites:

Weblogic server installed

Steps :

1. Download the requied version of ODI installaer from the oracle site
2. Follw the screenshots below and install the ODI

Select the ODIStudio, standalone agent and ODIConsoela s well


Specify the middleware home and ODI home

You can skip the repository connection step. Repositories can be created later

Specify the agent name and port to be used

 Now you can cretae the master and work repositories for ODI and establish connection to them.


Installing ODIConsole:

1. Run the config.jar to configure the domain

Select the ODI console data source

 enter the domain name and domain location

Specify the weblogic server username and password


 configure master and work repository schemas


 Target the deploymetn to the admin srever and if neede the managed servers as well


Make sure to select the check box for ODI console

 Make sure to select the check box for JDBC Resource of amster nad work repositories

 Select create to create the domain


2. Now login to the weblogic server and look under servers
3. servers->Admin server->deployments->odiconsole
4. Expand odiconsole to click the modules
5. Go to Testing tab and click the url on default.
6. It will take you to the odiconosle
7. It will be of the form http://localhost:7001/odiconsole
8. Login with master and work repository credential
9. Now you will be able to see the work and master repository screen

Post Deployment Configuration:

1. go to ODI_HOME\Common\bin folder
2. execute the wlst.cmd
3. connect to the weblogic domain by providing username nad password
4. create the credential with the SUPERVISOR user account and password details and finally disconnect
5. Below is the script to execute the above steps

• connect(‘weblogic’,'welcome1′,’t3://localhost:7001′)
• createCred(map=”oracle.odi.credmap”, key=”SUPERVISOR”, user=”SUPERVISOR”, password=”SUNOPSIS”, desc=”Key for Supervisor”)
• disconnect()

BINGO..!! you are done with ODI installation and configuring ODIConsole...:)