Creating an Oracle BI Repository

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

If you have 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 Setting Up Database Objects and Creating or Changing Connection Pools.

See Performing Data Source Preconfiguration Tasks.

Refer to the following sections for information about your data source type:

• Importing Metadata from Relational Data Sources

• Importing Metadata from Multidimensional Data Sources

• About Importing Metadata from XML Data Sources

• Working with ADF Data Sources

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

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

2. Select Binary to create a repository in RPD format. 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 RPD file extension is automatically added if you do not explicitly specify it.
4. For Location, follow the steps appropriate for your repository type:

   • For binary repositories, select a location for the RPD 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 do not 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.