O'Reilly logo

Oracle Business Intelligence Enterprise Edition 12c - second Edition by Haroun Khan, Christian Screen, Adrian Ward

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required