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 figure displays the New tab in the ODI Studio.
  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 figure displays the categories tree of the New Gallery.
  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.

    Note:

    *Use the same credentials used by the installer to create the original repository.
    This figure displays the Master Repository Creation Wizard.
  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.