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.
    This screenshot is described in surrounding text.
  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.

    This screenshot is described in surrounding text.
  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.

    Note:

    Use the same credentials used by the installer to create the original repository.

    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.
    This screenshot is described in surrounding text.
  6. In the Repository Configuration area, enter a unique, three-digit numeric ID.

    Note:

    Ensure that the repository ID is a value greater than the original repository ID value of 500. This prevents import issues while importing exported (backup) files from your original repository.
  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.
    This screenshot is described in surrounding text.
  9. In the Password Storage screen, select Internal Password Storage.
    This screenshot is described in surrounding text.
  10. Click Yes to indicate you want to remove the existing repository.
    This screenshot is described in surrounding text.
  11. In the Master Repository Creation Wizard, click Finish.