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 11g

1. Start the Oracle Warehouse Builder Design Center as the repository owner.
   • 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, then you can use the Windows native client if Oracle Warehouse Builder is installed.

2. Log in to the Design Center as the repository owner. Select the EBILLING_ETL project.
   • Single Node Environment. Use the host name, port number, and SID for the Oracle Self-Service E-Billing database.
   • RAC Environment. Use SQL*Net Connection to log in to the Design Center, using the RAC Net Service Name, such as ebill, as the Net Service Name.
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).