Add agent on ODI

Basic steps to setup agent on ODI:
1. launch odi using command /oracledi/client/odi.sh
2. Connect to the work repository. Go to Topology Navigator. Right click ‘Agents’

agent1

in the editor, specify below values,

Name: OracleDIAgent1
Host: Host name of the managed server (simple domain) or proxy server (cluster)
Port: Port of the managed server (simple domain) or proxy server (cluster) (The default is 20910)
Web Application Context: XXXXX

3. Click ‘Save’ and right click the agent created on Step 2, and choose ‘Test’, it will complain that fails to connect.

4. Go to /agent/bin/, add line  JAVA_HOME=/xxx/jdk6/bin/java before JAVA_HOME is referenced on file odiparams.sh.

-bash-3.2$ pwd
/xxx/oracledi/agent/bin
-bash-3.2$ diff odiparams.sh odiparams.sh_orig
114,116c114,116
< ODI_MASTER_URL=jdbc:oracle:thin:@xxx.xx.xx.com:yourport:yoursid
< ODI_MASTER_USER=xxxx
< ODI_MASTER_ENCODED_PASS=c5gXSB9x.gTpEKIv1etscXxSUj.kdsqGpsBv6bWjaIkQtp

> ODI_MASTER_URL=jdbc:oracle:thin:@localhost:1521:ORA111
> ODI_MASTER_USER=USER_NAME
> ODI_MASTER_ENCODED_PASS=gxfpqkz074jeaCpL4XSEFzxoj8E0p
121,122c121,122
< ODI_SUPERVISOR=LUHUANG
< ODI_SUPERVISOR_ENCODED_PASS=aYyX,RufCmXcQTv3wKyN,y

> ODI_SUPERVISOR=SUPERVISOR
> ODI_SUPERVISOR_ENCODED_PASS=fJya.vR5kvNcu9TtV,jVZEt
140c140
< ODI_SECU_WORK_REP=xxxx

> ODI_SECU_WORK_REP=WORKREP
165d164
< JAVA_HOME=/xxxx/jdk6
-bash-3.2$

You need to use encode.sh to encode your password. E.g, sh encode.sh FUSION_ODI_XXX_XXXX

5. Start it.

./agent.sh -NAME=OracleDIAgent1 -PORT=20910

6. Test the connection again from studio. It works. And also you can visit it from browser, http://xxx.xx.xxx.com:20910/oraclediagent/

7. Do the same steps to create another agents. And link them as a group to do load balance in the editor.

agent2