Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing > Process of Installing the Oracle Warehouse Builder Repository >

Creating the Oracle Warehouse Builder Repository User

You must create an Oracle Warehouse Builder repository user using the Oracle Warehouse Builder Design Center.

Follow the appropriate procedure for your version of the Oracle Warehouse Builder.

This task is a step in Process of Installing the Oracle Warehouse Builder Repository.

To create the repository user using Oracle Warehouse Builder 10g Release 2

1. Start the Oracle Warehouse Builder Design Center.
   • UNIX. Log in as the oracle user, change the directory to OWB_HOME/bin/unix, and run the ./owbclient.sh script.
   • Windows. Log in as an administrator, and click the link in the Start Menu to the Design Center.

     If you want to connect to a UNIX-hosted Oracle Warehouse Builder repository you can use the Windows native client if Oracle Warehouse Builder is installed.

2. Log in to the Design Center as the repository owner by providing the host name, port, and SID of the OLAP database.
3. After successfully logging in to the Design Center, expand the security tree in the Global Navigator pane. Right-click the User element, and click New to start the Oracle Warehouse Builder User Wizard.
4. Click Create DB User.
5. Enter the SYSDBA password, user name map_user (required), and a password for the new database user. Click OK.
6. Check the Used as target schema box, then click Next.

To create the repository user using Oracle Warehouse Builder 11g

1. Start the Oracle Warehouse Builder Design Center.
   • UNIX. Log in as the Oracle user, change the directory to OWB_HOME/bin/unix, and run the ./owbclient.sh script.
   • Windows. Log in as an administrator. On the Start Menu, click the link to the Design Center.

     If you want to connect to a UNIX-hosted Oracle Warehouse Builder repository you can use the Windows native client if Oracle Warehouse Builder is installed.

2. Log in to the Design Center as the repository owner, providing the host name, port, and SID of the OLAP database.
3. After successfully logging in to the Design Center, expand the security tree in the Global Explorer pane. Right-click the User element, and click New to start the Oracle Warehouse Builder User Wizard.
4. Click Create DB User.
5. Enter the SYSTEM password, user name map_user (required), and a password for the new database user. Leave the default values for Tablespace, click OK, and then click Next.
6. (Oracle Database 11g Release 2 only) Uncheck the To Create a Location option, and click Next.
7. Click OK to create a user (on Oracle Database 11g Release 2 click Finish).