ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

11g Oracle Data Integrator – Part 5/11g – odiConsole, the new Metada Navigator

Dear Friends,

In ODI 10g we used Metadata Navigator to login which acted as Web portal to Trigger and view the listed Scenarios and also Light weight designer .

In ODI 11g we have odiconsole which can be configured using the Oracle WebLogic.This post shows step by step configuration  and initial setup to login into ODI console and setting up of Standalone agent to trigger scenarios from odiconsole.

[ Note – The Server name , Port No and other configuration used is for demonstration only and Please use the appropriate  for your environment ]

Launch the Initial configuration Wizard of weblogic.

image

Select the Following options as shown below.

image

Give a meaningful domain name.

image

Provide the Administrator User Name and Password ,required to login into domain account.

image

Select the required JDK from the options

image

Provide the details of the MASTER Repository account

image

Provide the details of the WORK Repository account

image

Click Next and test the accounts . If you have error in this step , its means the account information is wrong , Please go back and do the required changes and once the account are correct ,you will get a Test successful message.

image

Click the Following as we need to do few settings changes.

image

If required change the Listener address to the required IPaddress or hostname you want to domain to be and similarly the Port No . For this post the default is used .

image

Configure the Machine Name with Node Manager listener address and  Port

image

Assign the Server , although by default the odi_server1 is assigned but I have assigned Adminserver too so that I can access the odiconsole from 7001 port itself.

image

Make sure you check the option oraclediagent and odiconsole under Application

image

Check the JDBC  Services and odiMasterRepository and odiWorkRepository

image

Confirm all the setting and options are correct and click on Create.

image

Finally ,you will get a Domain created with the Admin Server URL . Check  mark Start Admin Server

image

Go to your Web Browser and type in the following address –http://localhost:7001/console/login/LoginForm.jsp

Change the local host  and port to whatever is listed in the Admin Server URL above .

image

Once logged in , Under Environment – > click on Servers

image

You will able to see all the Server .

image

Click on Adminserver . You will be taken to a page as shown below  , click  Deployments and you will be able to see odiconsole , oraclediagent .

image

Expand odiconsole and you will be able to see odiconsole under Modules . Click that and you will be taken to another page

image

Go to Testing tab and expand odiconsole there .ah! finally we got our url . Click the url on default.  http://localhost:7001/odiconsole

image

Once logged in you will be able to see the Master and Work Repository.

image

Use the required SUPERVISOR account to login

image

Sample Work Repository Console Screen

image

Sample Master Repository Console Screen

image

image

Here I am trying to trigger the Scenario EMPLOYEES  from odiconsole and I get the following error.

image

To Resolve the above error , go your <ODI_HOME>COMMONBIN folder and type in the following command

D:OracleMiddleware_32bitOracle_ODI_32bitcommonbin >wlst.cmd

We need to connect to the above created weblogic connection ,provide the user name , password  and url as shown in the image . [ Please find the scripts below the images  ]

image

image

Once connected , create the credential with the SUPERVISOR user account and password details

image

Finally disconnect

image

The scripts is mentioned here  , Please change accordingly.

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

Here the weblogic is the username , odiexperts01 is the password to login into weblogic and localhost:7001 is the  listener address and port number

In the createCred , provide your SUPERVISOR user id and password

Learn more about the above scripts here in this Oracle Link –http://download.oracle.com/docs/cd/E14571_01/core.1111/e16453/install.htm#ODING412

I triggered the same Scenario again and this time the execution was successful.

image

Successfully executed in the Operator

image

Successful execution report in odiconsole.

image

We are trying to bring more post and blog on ODI 11g to make your transition to ODI 11g as smooth as possible. Smile

Keep looking for odiexperts for  more tips , tricks on ODI 11g .

Thank you for visit us!

6 Comments

  1. Hi

    I have done the installation as per your post, but I am not able to get the projects which I had created in ODI studio, can you please say me how you have got the details of the projects of the work repository,
    I have created projects in ODI console of WORKREP1. I am logging into ODI console with repository: WORKREPOSITORY and user: supervisor. then inside it is showing nothing about the work repository.

    please enlighten me or post about this. 🙁

    Thanks,
    Santhosh

  2. can somebody explain how to identify and kill the agents showing ideal in ODI and even how to stop them going ideal, what happens if we do so?

  3. Hi

    I have to execute scanerio by ODI weblogic console and pass variable as argument during run time to scanerio.

    Is there any way to implement this?

    Thanks

    • How are you executing the weblogic Console. Doesn’t the ODI console when triggering the scenario asks for the variable parameters to be passed.

    • Hi

      I have done the installation as per your post, but I am not able to get the projects which I had created in ODI studio, can you please say me how you have got the details of the projects of the work repository,
      I have created projects in ODI console of WORKREP1. I am logging into ODI console with repository: WORKREPOSITORY and user: supervisor. then inside it is showing nothing about the work repository.

      please enlighten me or post about this. 🙁

      Thanks,
      Santhosh

  4. Thanks! It helped me a lot on how to install de ODI console!

Leave a Reply

Required fields are marked *.