Installing the metadata schemas

The final installation task in this chapter is the creation of the schemas that will be used by the WebLogic part of the Fusion Middleware software. For this step, we will use the Repository Creation Utility (RCU) that has been installed as part of the Fusion Middleware system software.

Creating the database and user

Before we begin, let's create and configure a user and database in our SQL Server database:

  1. Open SQL Server Management Studio.
  2. Create a new login, called obiee_sa, which uses SQL Server Authentication. Make a note of the password you create for this user.
  3. Create a new database.
  4. Enter the database name of obiee_book.
  5. Set the owner as obiee_sa.
  6. Select Options in the left-hand panel.
  7. Scroll to the Miscellaneous ...

Get Oracle Business Intelligence Enterprise Edition 12c - second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial