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 Database Modules

You must create the following Oracle database modules, using the Oracle Warehouse Builder Design Center:

• STAGE_TABLES
• TARGET_TABLES
• MAPPINGS
• OLTP

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

To create the Oracle database modules

1. Expand the newly created project tree, and navigate to Databases, Oracle.
2. Right-click the Oracle element, and click New to start the Create Module Wizard.
3. For each module, enter the module name, module location, EBILL service name, and schema user name as shown in the following table. (Be careful to specify the correct service name and schema user name for the MAPPINGS and the OLTP modules). Enter the schema password. The Oracle database parameters for each module must be the ones used for the Oracle Self-Service E-Billing installation.

   Module Name	Module Location	Service Name	Schema User Name
   STAGE_TABLES	STAGE_TABLES_LOCATION	EBILL	OLAP
   TARGET_TABLES	TARGET_TABLES_LOCATION	EBILL	OLAP
   MAPPINGS	MAPPINGS_LOCATION	EBILL	MAP_USER
   OLTP	OLTP_LOCATION	EBILL	OLTP

4. Click Edit next to the location field. Enter the location name and database connection details for the Oracle Self-Service E-Billing database. For the RAC environment, enter the Single Client Access Name (SCAN) host name, port number, and the Cluster Database Service Name, such as scanhostname:port:ebill.
5. Verify that the correct database version is selected.
6. Click Test Connection to test the database connection.
7. Click OK, then click Finish to create the new database module.
8. Repeat from Step 2 for each remaining module.