Bookshelf Home | Contents | Index | PDF     

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 directory 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 following directory:
    • UNIX. EDX_HOME/db/oracle
    • Windows. EDX_HOME\db\oracle

      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, then OWB_ORACLE_HOME is the same as ORACLE_HOME.

  2. Modify the following properties to reflect your Oracle Self-Service E-Billing environment. 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

    The location of the Oracle Warehouse Builder home folder. If you are installing on Oracle Database 11g, then this directory is the same as the ORACLE_HOME path, such as export/home/oracle/11.2.0.3

    TCL_SCRIPTS_DIRECTORY

    The directory where the Oracle Self-Service E-Billing TCL scripts are located, such as:
    EDX_HOME/db/oracle/olap/etl.

    MDL_LOCATION

    The folder location where the Oracle Self-Service E-Billing MDL file is located, such as:
    EDX_HOME/db/oracle/olap/etl

    MDL_NAME

    ebilling_etl_v6.2.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 Oracle Self-Service E-Billing database.

    In a RAC environment, specify the host information where you created the repository owner.

    OWB_PORT

    The port number of the Oracle Self-Service E-Billing database, such as 1521.

    OWB_SERVICE

    The ORACLE_SID of the Oracle Self-Service E-Billing database.

    In a RAC environment, specify the unique service name of the node where you created the repository owner, such as ebill1.

    SYS_PASSWD

    The SYS password of the Oracle Self-Service E-Billing database.

    OLAP_USER

    The user name for the OLAP schema.

    OLAP_PASSWD

    The password for the OLAP schema.

    EBILL_SID

    The ORACLE_SID of the Oracle Self-Service E-Billing database.

    In a RAC environment, specify the SID of the node where you created the repository owner, such as ebill1.

    OLTP_USER

    The user name for the OLTP schema.

    INPUT_DIR

    Specify the input directory path, such as:
    /export/home/oracle/testdata/OWF_INDATA

    In a RAC environment, specify a shared location that all RAC nodes can access.

    OUTPUT_DIR

    Specify the output directory path, such as:
    /export/home/oracle/testdata/OWF_OUTDATA

    In a RAC environment, specify a shared location that all RAC nodes can access.

    REJECT_DIR

    Specify the reject directory path, such as:
    /export/home/oracle/testdata/OWF_REJDATA

    In a RAC environment, specify a shared location that all RAC nodes can access.

    GRP_MOVE_INDIR

    Specify the group move input directory path, such as:
    /export/home/oracle/testdata/GRPMV_INDATA

    In a RAC environment, specify a shared location that all RAC nodes can access.

    GRP_MOVE_OUTDIR

    Specify the group move output directory path, such as:
    /export/home/oracle/testdata/GRPMV_OUTDATA

    In a RAC environment, specify a shared location that all RAC nodes can access.
  3. Specify the following mail server parameters.
    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.
  4. Open a command prompt, and go to the directory containing the ebilling_etl.properties file.
  5. 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 ANT_HOME=/opt/apache-ant-1.6.5

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

  6. Go to the following directory:
    • UNIX. EDX_HOME/db/oracle
    • Windows. EDX_HOME\db\oracle
  7. Enter Ant to run the build script.

    By default, the Ant command runs the build.xml file in the current directory.

  8. From the Main Menu, select Option 2, Standalone Install.
  9. Select Option 5, ETL Setup.
  10. You have the option to create the ETL packages, import the MDL file, and deploy the OWB mappings in one step or in separate steps:
    • To create the ETL packages, import the MDL file, and deploy the OWB mappings in one step, select Option 3, Run Steps 1 and 2, from the ETL Setup menu. Ant returns to the current menu when finished. When these steps are complete, go to Step 16.
    • To create the ETL packages, import the MDL file, and deploy the OWB mappings in separate steps, continue with Step 11.
  11. Select Option 1, Import MDL.

    This step can be used to create the ETL packages and import the MDL file.

  12. Check the MDLFileName.log file, found in the EDX_HOME/db/oracle/olap/etl directory, for errors. Log in to the Design Center, and make sure all modules are connected to the database locations. For the ETL_PF_MODULE module, check the LOCATION and Evaluation Location.
  13. Review all log files for possible errors
  14. Select Option 2, OWB Mappings Deployment.

    Ant returns to the current menu when finished.

  15. Review all log files for possible errors
  16. Review all log files found in the EDX_HOME/db/oracle/olap/etl and EDX_HOME/db/oracle directories. You can ignore the following error message shown on screen and in the ETLPackages.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

    
Installation Guide for Oracle Self-Service E-Billing Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.