Creating a New Master Repository

Use ODI Studio to create a new Master Repository.

1. Launch ODI Studio.
2. Open the New Gallery by selecting File and then New.
   
3. In the Categories tree of the New Gallery, select ODI.
4. From the Items list, select Master Repository Creation Wizard, and click OK.

   The Master Repository Creation Wizard opens.

   
5. Specify the Database Connection properties:

   Property	Description
   Technology	Select the technology that will host your Master Repository.
   JDBC Driver	The driver used to access the technology that will host the repository.
   JDBC URL	The URL used to establish the JDBC connection to the database. 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 Master Repository will be stored.
   Password	The password for the schema.
   DBA User	The user ID on the database with DBA privileges such as SYSTEM. Do not use SYS, which requires logging in as SYSDBA.
   DBA Password	The password for the DBA User.

   
6. In the Repository Configuration area, enter a unique, three-digit numeric ID.
7. (Optional) Click Test Connection to test the connection to the Master Repository, then click Next.
8. In the Authentication screen, select Use External Authentication, and specify these properties, then click Next:

   Property	Description
   Supervisor User	The user name of the ODI Supervisor that was specified during the initial Oracle BI Applications installation.
   Supervisor Password	The Supervisor User's password that was specified during the initial Oracle BI Applications installation.

   
9. In the Password Storage screen, select Internal Password Storage.
   
10. Click Yes to indicate you want to remove the existing repository.
    
11. In the Master Repository Creation Wizard, click Finish.