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

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. Enter the name of the module to create, such as STAGE_TABLES. The database parameters for each module must be those used for the Oracle Self-Service E-Billing installation. For each module, enter the OLAP database schema user name and password (OLTP and OLTP for the OLTP Module). Use the default values for other fields (default module type is Warehouse Target), and click Next.

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

4. Click Edit next to the location field. Enter the location name and database connection details of the Oracle Self-Service E-Billing OLAP database.
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.