Monday 4 August 2014

Creating Stand alone Agent

  1. Agents are useful to schedule Procedures (Load plans ,scenarios ..etc)
  2. These are three types
    1. completely standalone agent (no WLS installed. This OBE uses this kind of agent.)
    2. standalone collocated agent (WLS is installed, but is not being used. The agent is started as its own binary.)
    3. JEE agent (WLS installed and used. The domain, admin server, managed servers, node managers, and so on are started in the normal WLS way. The agent is one of many possible JEE apps running in the domain. )

Exercise 1 : Creating Stand alone Agent

Step 1 : Creating Physical Agent
  1. open ODI studio and connect using SUPERVISOR user
  2. Go to topology tab → in physical Architecture right click on Agents → Click on new agent name it as OracleDIAgent → click on save → Click on close

Step 2 : Creating Logical Agent and Mapping Physical and logical agents in context
  1. Go to topology tab → in LogicalArchitecture right click on Agents → Click on new agent name it as OracleDIAgent → under physical agent select OracleDIAgent opposite to development context → click on save → Click on close

Step 3 : Modifying parameter file odiparams.bat
  1. Take backup of file odiparams.bat
  2. Change Repository Connection Information
    1. Let us say Master repository database name : ORCL
    2. username : B109ODIMR
    3. password : RRitec123
  3. encode password of master repository
  4. open CMD → and execute as shown
  5. Change odi params.bat file repository section as shown
  6. Change User credentials for agent startup program
  7. Let us say ODI username : SUPERVISOR and password : RRitec123
  8. As already we encoded RRItec123 password we can use same
  9. Change odi params.bat file user credentials section as shown
  10. Change work repository section as shown
  11. save and close



Step 4 : Running and Testing  Agent


  1. Go to location C:\OBIEE_HOME\Oracle_ODI1\oracledi\agent\bin
  2. double click on agent.bat file
  3. Observe cmd prompt
  4. On go if agent is not running then debug using log file

No comments:

Post a Comment