Create an Oracle BI Repository

You can use the Create New Repository Wizard in the Administration Tool to create a new Oracle BI repository in either binary Oracle BI repository file (RPD) or MDS XML format.

If you've a repository, you can use the existing data source settings as a template to connect to different data sources. To use the existing data source settings and change the database type and connection pool information, see Set Up Database Objects and Create or Change Connection Pools.

  1. In the Administration Tool, select File, then select New Repository.

    If an existing repository is open, you're prompted to save your changes, and the existing repository is closed.

  2. Select Binary to create an Oracle BI repository file. To create a repository in MDS XML format, select MDS XML Documents.
  3. For binary repositories, type a name for the repository. Keep the name to 156 characters or less to avoid problems with the metadata dictionary URL. An Oracle BI repository RPD file extension is automatically added if you don't explicitly specify it.
  4. For Location, follow the steps appropriate for your repository type:

    • For binary repositories, select a location for the Oracle BI repository file. By default, new binary repositories are stored in the repository subdirectory, located at ORACLE_INSTANCE\bi\bifoundation\server.

    • For MDS XML format repositories, select a root folder location for the set of MDS XML files.

  5. If you want to import metadata into the repository now, select Yes (the default) for Import Metadata. If you don't want to import metadata, select No.
  6. Enter and confirm the password you want to use for this repository. The repository password must be eight characters, containing one or more numerals.

    You enter the same repository password that you used to open the repository in online or offline mode. Your password is used to encrypt the repository contents.

  7. If you selected Yes for Import Metadata, click Next.

    You might need to set up your data sources before you importing metadata.

  8. If you selected No for Import Metadata, click Finish to create an empty repository.