Create a New Oracle Data Integrator Repository Login

Perform the following steps to create a new Oracle Data Integrator repository login:

- Steps

Checkbox

Navigate to ODI > File > New > Create a New ODI Repository Login.

Checkbox

Click OK. The Repository Connection Information screen is displayed.

Checkbox

Enter the following values:

  • Login Name - For example, WIL_REPOSITORY_LOGIN
  • User - SUPERVISOR
  • Password - Provide the Oracle Data Integrator Login password entered during installation (see Run the Installer)
  • User - <database schema created for the master repository>
  • Password - <database schema password created for the master repository>
  • Driver List - Select OracleJDBC Driver from the drop-down list
  • Driver Name - oracle.jdbc.oracledriver
  • Url - Set appropriate values based on your database details
  • Work Repository - Select the Work Repository option, browse to select the work repository shown (for example, for the Warehouse Integration loader, select WIL_WORK_REPOSITORY), and click OK.

Checkbox

Click OK. The login name is created with the name specified in the previous step.

Checkbox

Navigate to ODI > Connect > ODI Studio.

Checkbox

Enter the following details:

  • Login Name - Select WIL_REPOSITORY_LOGIN
  • User - Supervisor
  • Password - Provide the Oracle Data Integrator login password entered during installation (see Run the Installer).

Similarly, follow the above steps to create the login for the Terminology loaders, Common Data Mart loader, and Cohort Data Mart loader.