Unzip the content of the ODI Companion CD and then open up the /agent_standalone folder. Unzip the oracledi-agent-standalone.zip file to the location in which you would like to deploy your standalone agent.

Go to the directory in which you extracted the files required to run your standalone agent, then navigate to the oracledi/agent/bin directory, and open up the odiparams.sh or odiparams.bat file using your favorite text editor.

We will now modify some of the parameters included in the odiparams file starting with the Master repository information. Edit the file so that ODI_MASTER_DRIVER has the correct JDBC driver class name and the ODI_MASTER_URL value is a valid JDBC URL for the database hosting your Master repository. Finally, complete the Master repository configuration by providing the database username and its password using the ODI_MASTER_USER and ODI_MASTER_ENCODED_PASS parameters. We use the following values in this recipe:

REM #
REM # Repository Connection Information
REM #
set ODI_MASTER_DRIVER=oracle.jdbc.OracleDriver
set ODI_MASTER_URL=jdbc:oracle:thin:@localhost:1521:orcl
set ODI_MASTER_USER=ODI_REPO_11G
set ODI_MASTER_ENCODED_PASS=dpfHbipjYbBAfm7P,Dt69kPBV

Next we need to provide the name of the ODI Supervisor user along with its encoded password using the ODI_SUPERVISOR and ODI_SUPERVISOR_ENCODED_PASS variables.

REM #
REM # User credentials for agent startup program
REM #
set ODI_SUPERVISOR=SUPERVISOR
set ODI_SUPERVISOR_ENCODED_PASS=d,yXMMv0Rk6rgNVKEnBb1xE.E

Subsequently, we set the value of ODI_SECU_WORK_REP to the name of the Work repository that will be used by this standalone agent. The Work repository is named WORKREP in this recipe.

REM #
REM # Work Repository Name
REM #
set ODI_SECU_WORK_REP=WORKREP

Optionally we can also change the Java Virtual Machine settings for this agent using the ODI_INIT_HEAP and ODI_MAX_HEAP parameters. Out of the box, the JVM settings are quite low, so it is a good idea to increase their values; the values below are not example settings:

REM #
REM # Other Parameters
REM #
set ODI_INIT_HEAP=256m
set ODI_MAX_HEAP=1024m

Now save the odiparams.sh or odiparams.bat file and close it.

Open up ODI Studio and go to Topology Navigator.

In Physical Architecture, right-click on the Agents node and select New Agent.

In the Agent panel, specify the agent's name along with the machine hostname and its port. Save the settings.

Open up a terminal and navigate to your agent's installation /bin directory.

Start your standalone agent using the agent.sh or agent.bat script and by providing its name (same as the one specified in Topology) and its port. In this recipe we use the following command:

agent.bat –NAME=LOCAL_STANDALONE_AGENT –PORT=20910

Go back to Topology, open up your newly created Physical Agent, and click on Test to verify if all the parameters were entered correctly.