Before creating an ODI agent, you must run the encode password command to generate an encrypted password and paste it into the odiparams.bat parameter file. To do so, perform the following steps:
| 1. | Navigate to the ODI_HOME directory, where ODI is installed
and open the agent\bin sub-directory: (
C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\bin). Navigate to the
odiparams.bat file, right-click this file and select Edit to open it
with a text editor. Leave this editor open; you will run a batch file
from a Command window and return to this text editor to copy the results
into the odiparams.bat file. Explanation: You need to edit the odiparams.bat file to set the repository connection information for the ODI Agent to use. The password information is stored as an encrypted string. You will generate the encrypted string in a Command window.  |
||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2. | Leave the text editor open, and open the Command window
(Start -> Run -> cmd) and change the directory to the
ODI_HOME\agent\bin directory: C:\Oracle\Middleware\Oracle_ODI1\oracledi\agent\bin  |
||||||||||||||||||||
| 3. | To generate the encrypted password string, you will be using the agent command: encode <password>. Because your password is the word “ oracle1”, enter and execute the following command in the Command window: encode oracle1 Keep the Command window open, as you will be returning to it after editing the odiparams.bat file.  |
||||||||||||||||||||
| 4. | Copy the generated encrypted password from the Command
window (from the Command window’s pull-down menu, select Edit > Mark,
then highlight the password with your mouse) and insert it into the
odiparams.bat file as the value for the ODI_MASTER_ENCODED_PASS
parameter. Verify and, if necessary, edit settings for other parameters from the table below, save the odiparams.batfile, and then close it. The agent’s connectivity is now set up.
User snpm1 is RDBMS schema/user (Oracle 11g) for Master repository. It was created for this and subsequent OBEs in OBE "Creating and Connecting to ODI Master and Work Repositories". Work Repository name is WORKREP. Because each time when you encode the password, it gets different values, your encoded password will differ from the one provided in the screenshot. Do not change the default value of the ODI_USER and ODI_ENCODED_PASS parameters. Those parameters were pre-coded during ODI installation.    |
No comments:
Post a Comment