Installation Guide for Oracle Billing Insight > Configuring the ODI Data Load Processes >

Configuring Oracle Billing Insight for Your ODI Configuration

This topic describes how to set up Oracle Billing Insight to connect with your ODI configuration. This topic assumes you have installed Oracle Data Integrator as described in this chapter.

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

This task is a step in Roadmap for Configuring the Data Load Processes for Oracle Billing Insight.

To configure Oracle Billing Insight for your ODI configuration

1. Open the BillingInsight_etl.properties 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 Billing Insight is installed.

2. Modify the following properties to reflect your Oracle Billing Insight environment. The directory of the OUTPUT_DIR directory must not be the same as the directory of the INPUT_DIR.
    

   Property	Value
   OLAP_USER	The user name for the OLAP schema.
   OLAP_PASSWD	The password for the OLAP schema.
   EBILL_TNS_NAMES	The Oracle Billing Insight database TNS (Transparent Network Substrate) name.
   SYS_PASSWD	The SYS password of the Oracle Billing Insight database.
   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.
   BAD_FILE_LOCATION	Specify the directory path for bad files.
   DISCARD_FILE_LOCATION	Specify the directory path for discarded files.
   LOG_FILE_LOCATION	Specify the directory path for log files.
   TOPX_REC_CAP	Specify the number of records for a service and period to maintain in the Top Usage tables. The default is 51 (the first 50 records for a service and period will be inserted into the Top Usage tables). The higher the value, the greater the impact on performance in the data loading process. It is recommended not to exceed 100.
   ODI_HOME_DIR	The ODI home directory.
   AGENT_BIN_DIR	The location of bin directory where the stand alone agent is installed.
   XMLFILES_DIR	The folder location where the Oracle Billing Insight XML files are located, such as: EDX_HOME/db/oracle/olap/etl
   EBILL_DB_HOST	The Oracle Billing Insight database host name.
   EBILL_DB_PORT	The Oracle Billing Insight database port.
   EBILL_DB_SERVICE	The Oracle Billing Insight database service.
   ODI_USER	The ODI user name. The default is SUPERVISOR.
   ODI_PASSWD	The ODI user password.
   MASTERREP_HOST	The host name for the master repository database.
   MASTERREP_PORT	The port for the master repository database.
   MASTERREP_SERVICE	The database service for the master repository.
   MASTERREP_USER	The schema owner name for the master repository.
   MASTERREP_PASSWD	The schema owner password for the master repository.
   AGENT_HOST	The name of the host where the ODI agent is running. The default is localhost.
   AGENT_HOST_PORT	The host port where the ODI agent is running. The default is 20910.
   AGENT_PROTOCOL	The ODI agent protocol. The default is http.
   AGENT_NAME	The ODI physical agent name. The default is OracleDIAgent1.
   LOG_AGENT_NAME	The logical agent name. The default is ODIAgent.
   WORKREP_NAME	The default repository name. The default is WORKREP.

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

   set ANT_HOME=/opt/apache-ant-1.9.6

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

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

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

7. From the Main Menu, select Option 3, Create Database Schema & Objects.
8. Select Option 4, ETL Setup.
9. You have the option to create the packages, create ODI database and agent topology, and import the Oracle Billing Insight ODI processes in one step or in separate steps:
   • One step. To create the ETL objects, create the ODI database and agent topology, and import the ODI processes in one step, select Option 4, Run Steps 1, 2, and 3, from the ETL Setup menu. Ant returns to the current menu when finished. When these steps are complete, go to Step 15.
   • Separate steps. To create the ETL objects, create the ODI database and agent topology, and import the ODI Oracle Billing Insight processes in separate steps, continue with Step 10.
10. Select Option 1, Create ETL Objects.
11. Review all log files found in the EDX_HOME/db/oracle directory.
12. Select Option 2, Create ODI Database and Agent Topology
13. Review all log files for possible errors.
14. Select Option 3, Import ODI Billing Insight Processes.
15. Review all log files found in the EDX_HOME/db/oracle directory.