Thursday 21 March 2013

Executing Scenario through Web Agent

There are number of ways to execute Scenario.
a. Designer
b. Operator
c. Metadata Navigator.
d. Web agent

In this Section we will be focus on Web Agent & hardly it will took  few minutes to launch web agent & execute scenario through them.  It is always recommended that to use Option B & C in the real time production environments


The advantages of Launching scenario through web agent is:
It is very simple & fast to configure.
Doesn't require any maintenance & easy to debug.
In real time it can be used by Testers.


To Launch agent first we need to set up the parameters in odiparams.bat or sh file at ODI installed location
 i.e C:\OraHome_1\oracledi\bin
set the following parameters

STEP A

rem
rem Repository Connection Information
rem
set ODI_SECU_DRIVER=oracle.jdbc.driver.OracleDriver
set ODI_SECU_URL=jdbc:oracle:thin:@localhost:1521:NEERAJ
set ODI_SECU_USER=SNAPON_M
set ODI_SECU_ENCODED_PASS=fDyXo2Vl73xS4g932Hags
set ODI_SECU_WORK_REP=REP_SNAPON_W
set ODI_USER=SUPERVISOR
set ODI_ENCODED_PASS=LELKIELGLJMDLKMGHEHJDBGBGFDGGH

Now there is a question how to get encoded or encrypted password for password parameters.
This is very simple open the command prompt --> go to C:\OraHome_1\oracledi\bin -->
Now run
agent ENCODE <password>
you will get encoded password

Make sure your all the JAVA HOME & ODI_JAVA_HOME is set already 



-SECU_DRIVER=<driver name>
The JDBC driver used to access the master repository.

-SECU_URL=<url>

The JDBC URL used to access the master repository.

-SECU_USER=<user>
The database user for the master repository connection.
-SECU_PASS=<password>
Password of the user for the master repository connection.
This password must be encrypted using the
command agent ENCODE <password>.
-WORK_REPOSITORY=<work repository name>
Name of the work repository that contains the scenarios to be executed.



STEP B.
 open the command prompt --> go to ODI bin location i.e C:\OraHome_1\oracledi\bin -->

 execute the batch file agentweb with parameter
“-port=20300” “-web_port=8080”.

STEP C.
Now in the browser  & open the link
http://localhost:8080/






Now Launcher is ready for use.

Please follow the link http://gerardnico.com/doc/odi/webhelp/en/usermanual/agent/topo_agent_startweb.htm

0 comments:

Post a Comment