Creating a New Work Repository

Use this procedure to create a new Work Repository.

1. In the Topology Navigator, go to the Repositories panel.
2. Right-click the Work Repositories node, and select New Work Repository.
   

   The Create Work Repository Wizard opens.

3. Specify the ODI Work Repository connection details.

   The Work Repository needs to be in the same schema as the Master Repository. Provide the same credentials used to create the Master Repository.

   Property	Description
   Technology	Select the technology that will host your Work Repository.
   JDBC Driver	The driver used to access the technology that will host the repository.
   JDBC URL	The complete path of the data server to host the Work Repository. Note that the JDBC Driver and URL properties are synchronized and the default values are technology dependent.
   User	The name of the schema where the Work Repository will be stored.
   Password	The password for the schema.

   
4. (Optional) Click Test Connection to verify the connection is working, then click Next.

   An informational dialog notifies you that a Work Repository already exists.

   
5. Click No to overwrite the existing repository.
6. Specify the Work Repository properties:

   Property	Description
   ID	Enter the same ID used when creating the new Master Repository.
   Name	A name for the Work Repository.
   Password	This field is optional. The value can be any value. It does not correspond to the ODI Supervisor or database passwords.
   Work Repository Type	Select Development.

   
7. Click Finish.
   
8. When the Confirmation dialog asks if you would like to create a login for the Work Repository, click No.
9. Edit the repository connection details to connect to the Work Repository:
   1. Log off of the Work Repository.
   2. Open the Repository Connection Information dialog.
   3. In the Work Repository area, select the Work Repository option, and then select the name of the Work Repository you just created.
      
   4. Click OK.