10/11

5 Creating a New Oracle Data Integrator Repository Login

This chapter contains the following sections:

• Section 5.1, "Creating a New OHADI ODI Repository Login"

• Section 5.2, "Creating a New HLI ODI Repository Login"

• Section 5.3, "Updating Topology for HLI"

• Section 5.4, "Configuring File Physical Schema"

5.1 Creating a New OHADI ODI Repository Login

Perform the following steps to create a new OHADI ODI repository login:

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

   Figure 5-1 Create a New ODI Repository Login

   
   Description of "Figure 5-1 Create a New ODI Repository Login"
   
   

2. Click OK. The Repository Connection Information screen is displayed.

3. Enter the following values:

   • Login Name: For example, OHADI_LOGIN

   • User: SUPERVISOR

   • Password: Provide the ODI Login password which was entered during installation (Figure 3-11)

   • User: <database schema created for the master repository>

   • Password: <database schema password created for the master repository>

   • Driver List: Select Oracle JDBC 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 and select OHADI_WORK_REPOSITORY from the Work Repositories List, and click OK.

   Figure 5-2 Repository Connection Information

   
   Description of "Figure 5-2 Repository Connection Information"
   
   

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

5. Navigate to ODI > Connect > ODI Studio.

6. Enter the following details:

   • Login Name: Select OHADI_LOGIN

   • User: Supervisor

   • Password: Provide the ODI Login password which was entered during installation (Figure 3-11)

   Figure 5-3 Oracle Data Integrator Login for OHADI

   
   Description of "Figure 5-3 Oracle Data Integrator Login for OHADI"
   
   

5.2 Creating a New HLI ODI Repository Login

Perform the following steps to create a new HLI ODI repository login:

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

2. Click OK. The Repository Connection Information screen is displayed.

3. Enter the following values:

   • Login Name: For example, HLI_LOGIN

   • User: SUPERVISOR

   • Password: Provide the ODI Login password which was entered during installation (Figure 4-8 and Figure 4-9)

   • User: <database schema created for the master repository>

   • Password: <database schema password created for the master repository>

   • Driver List: Select Oracle JDBC 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 and select EHA_HLI_WORK_REPOSITORY from the Work Repositories List, and click OK.

   Figure 5-4 Repository Connection Information

   
   Description of "Figure 5-4 Repository Connection Information"
   
   

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

5. Navigate to ODI > Connect > ODI Studio.

6. Enter the following details:

   • Login Name: Select HLI_LOGIN

   • User: Supervisor

   • Password: Provide the ODI Login password which was entered during installation (Figure 4-8 and Figure 4-9)

   Figure 5-5 Oracle Data Integrator Login for HLI

   
   Description of "Figure 5-5 Oracle Data Integrator Login for HLI"
   
   

5.3 Updating Topology for HLI

To override the path updated during installation for the source file, perform the following steps:

1. Open ODI studio and click Connect to Repository.

2. Select the HLI login (created in Section 5.2 and click OK.

3. Navigate to Topology > Physical Architecture > Technologies > File. Double-click HLI_DATA.

   Figure 5-6 HLI_DATA File Data Server

   
   Description of "Figure 5-6 HLI_DATA File Data Server"
   
   

4. In the JDBC tab, update the following values:

   • JDBC Driver: com.sunopsis.jdbc.driver.file.FileDriver

   • JDBC URl: jdbc:snps:dbfile

   Figure 5-7 Update JDBC Values

   
   Description of "Figure 5-7 Update JDBC Values"
   
   

5.4 Configuring File Physical Schema

To update the existing physical schema for HLI_DATA, perform the following steps:

1. Navigate to Topology > Physical Architecture > Technologies > File > HLI_DATA.

2. Double-click physical schema.

3. In the Definition tab, specify the actual physical folder location of the HLI Data Files for the properties Directory (Schema) and Directory (Work Schema).

   Figure 5-8 Update the Physical Schema for HLI_Data

   
   Description of "Figure 5-8 Update the Physical Schema for HLI_Data"
   
   

4. Click Save from the menu bar. The existing physical schema is saved.

Note:

For references on Topology configuration, see Oracle Data Integrator documentation.