Installation Guide for Oracle Self-Service E-Billing > Installing the ETL Module for Oracle Self-Service E-Billing >

Installing the ETL Module

This topic describes how to install the ETL module. The ETL Module is included in the Oracle Self-Service E-Billing software installation directory.

This topic assumes you have installed the Oracle Warehouse Builder Repository. For details on setting up the Oracle Warehouse Builder Repository, see Process of Installing the Oracle Warehouse Builder Repository.

For Windows, change the slashes (/ or \) and root as necessary.

This task is a step in Roadmap for Installing the ETL Module for Oracle Self-Service E-Billing.

To install the ETL Module

1. Open the ebilling_etl.properties ETL module configuration file in a text editor. This file is located in the EDX_HOME/db/ebilling/oracle directory (or the EDX_HOME\db\ebilling\oracle directory in Windows). In the path, EDX_HOME is the location where Oracle Self-Service E-Billing is installed.

   NOTE:  If you are installing on Oracle Database 11g Release 2, OWB_ORACLE_HOME is the same as ORACLE_HOME.

   Modify the following properties to reflect your Oracle Self-Service E-Billing environment. On Windows you must use two slashes (//) when entering file system paths. Note that the OUTPUT_DIR directory in the properties file must be the same as the directory of the DATA_FILES_LOCATION in the Oracle Warehouse Builder repository. The directory of the OUTPUT_DIR directory must not be the same as the directory of the INPUT_DIR.

    

   Property	Value
   OWB_ORACLE_HOME	export/home/oracle/11.2.0.1
   TCL_SCRIPTS_DIRECTORY	/opt/Oracle/eBilling/db/ebilling/oracle/olap/etl
   MDL_LOCATION	/opt/Oracle/eBilling/db/ebilling/oracle/olap/etl
   MDL_NAME	ebilling_etl_v6.0.4.mdl
   PROJECT_NAME	EBILLING_ETL
   TARGET_MODULE	MAPPINGS
   REP_USER	The repository admin user name.
   TGT_USER	The repository admin user name.
   TGT_PWD	The repository admin password.
   OWB_HOST	The host name of the OLAP database. Specify the HOST name of the OLAP database where the Oracle Warehouse Builder repository has been created.
   OWB_PORT	The port number of the database, such as 1521.
   OWB_SERVICE	The ORACLE_SID of the OLAP database.
   SYS_PASSWD	The SYS password of the OLAP database.
   OLAP_USER	The OLAP user name.
   OLAP_PASSWD	The OLAP password.
   OLAP_SID	The ORACLE_SID of the OLAP database.
   INPUT_DIR	/export/home/oracle/testdata/OWF_INDATA Specify the input directory path.
   OUTPUT_DIR	/export/home/oracle/testdata/OWF_OUTDATA Specify the output directory path.
   REJECT_DIR	/export/home/oracle/testdata/OWF_REJDATA Specify the reject directory path.
   SHELL_VAR	/usr/bin/sh

   Specify the following mail server parameters only if you have Oracle Database 11g. You can ignore these parameters if you have Oracle Database 10g.

   Parameter	Value
   MAIL_SERVER	Your company mail server name.
   LOWER_PORT	The lower port of the mail server.
   UPPER_PORT	The upper port of the mail server.

2. Open a command prompt, and go to the directory containing the ebilling_etl.properties file.
3. Run the following commands to set up your Oracle Warehouse Builder and Apache Ant environments, substituting the paths of your Oracle Warehouse Builder and Ant installations and correct slashes (/ or \) for your platform:

   set OWB_HOME=/export/home/oracle/product/owb_home (This command is not required if installing on Oracle Database 11g.)

   set ANT_HOME=/opt/apache-ant-1.6.5

   set PATH=%PATH%;%ANT_HOME%/bin

4. From the EDX_HOME/db/ebilling/oracle directory (the EDX_HOME\db\ebilling\oracle directory in Windows), run the following command to run the build.xml file:

   ant

5. Select Option 5, Install the ETL database.
6. Select Option 1, and press Enter to create the ETL package. When finished, check the etl_packages.log file found in the EDX_HOME/db/ebilling/oracle/olap/etl directory, for errors.

   You can ignore the following error message shown on screen and in the log file:

   Errors for PACKAGE BODY "EDX_RPT_ETL":

   LINE/COL ERROR

   -------- -----------------------------------------------------------------

   863/7 PL/SQL: Statement ignored

   864/10 PLS-00201: identifier 'EDX_RPT_ETL_IO_UTIL.MOVE_FILE' must be declared

7. After the create ETL package task completes, run Ant again, and choose Option 5, Install the ETL database, then choose Option 2, Import MDL. When finished, check the MDL File Name.log file, found in the EDX_HOME/db/ebilling/oracle/olap/etl directory, for errors. Log in to the Design Center, and make sure all modules are connected to the database locations. For ETL_PF_MODULE, check the LOCATION and Evaluation Location.
8. (Oracle Database 11g Release 2 only) Adjust JVM settings in OMBPlus.sh, found in the ORACLE_HOME/owb/bin/unix directory. In the following line, change MaxPermSize to 512M:

   *) OPTS="-XX:MaxPermSize=256M -XX:+DisableExplicitGC";;

   In this line, change Xms to 1024M Xmx to 2046M, and -Dlimit to 2046M:

   $JAVAPATH/bin/java -Xms64M -Xmx768M $OPTS -Dlimit=768M

9. After the import MDL task completes, run Ant again and choose Option 5, Install the ETL database, then choose Option 3, OWB Mappings Deployment. When finished, check the deploy.log file, found in the EDX_HOME/db/ebilling/oracle/olap/etl directory, for errors.