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, set up the repository, standalone agent, and topology 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
   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
   AGENT_NAME	The default Oracle Data Integrator agent name.
   WORKREP_NAME	The default repository name.
   SYS_PASSWD	The SYS password of the Oracle Billing Insight database.
   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.
   TOPX_REC_CAP	Specify the number of records for a service and period to maintain in the Top X tables. The default is 51 (the first 50 records for a service and period will be inserted into the Top X tables). The higher the value, the greater the impact on performance in the data loading process. It is recommended not to exceed 100.
   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.
   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.
   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. 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.8.3

   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 and import the Oracle Billing Insight ODI processes in one step or in separate steps:
   • One step. To create the ETL objects and import the ODI processes 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 14.
   • Separate steps. To create the ETL objects and import the ODI Oracle Billing Insight processes in separate steps, continue with Step 10.
10. Select Option 1, Create ETL Objects.
11. Check the log file, found in the EDX_HOME/db/oracle directory, for errors.
12. Review all log files for possible errors
13. Select Option 2, Import ODI Billing Insight Processes.

    Ant returns to the current menu when finished.

14. Review all log files found in the EDX_HOME/db/oracle directory.