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
- 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.
- 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.
|
|
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. |
- Specify the following mail server parameters.
|
|
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. |
- Open a command prompt, and go to the directory containing the ebilling_etl.properties file.
- 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
- Go to the following directory:
- UNIX.
EDX_HOME /db/oracle
- Windows.
E DX_HOME \db\oracle
- Enter
Ant to run the build script.
By default, the Ant command runs the build.xml file in the current directory.
- From the Main Menu, select Option 2, Standalone Install.
- Select Option 5, ETL Setup.
- 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.
- Select Option 1, Import MDL.
This step can be used to create the ETL packages and import the MDL file.
- 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.
- Review all log files for possible errors
- Select Option 2, OWB Mappings Deployment.
Ant returns to the current menu when finished.
- Review all log files for possible errors
- 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
|