The steps in this section can take a significant amount of time to complete.

The NCC Adapter that is installed with the Add-ons type installation feeds pre-paid billing data from the Oracle Communications Network Charging and Control application to the Oracle Communications Data Model. The NCC Adapter includes an option to feed data in real-time using Oracle GoldenGate to the Oracle Communications Data Model staging layer, or to extract, load and transform the data in batch mode using Oracle Data Integrator.

Prerequisites for NCC Adapter Configuration

The following are prerequisites for installing the Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model (NCC Adapter):

Before following the steps in this appendix, if you select to use real-time feeds with Oracle GoldenGate, then you need to download the Goldengate software according to the NCC Adapter source database version and Oracle Communications Data Model target database version before starting this adapter installation. For more information, see "Installing Oracle GoldenGate on Target for NCC Adapter".

The installation and set up steps assume the following recommended Oracle Data Integrator configuration:

The Data Warehouse database schema is hosted on the same database instance as the ODI Repository.

Confirming that Oracle GoldenGate is Installed

If you install the Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model (NCC Adapter), using, installing, and configuring Oracle GoldenGate is optional depending on whether you want to use Real-time staging with the NCC Adapter.

Oracle Communications Data Model NCC Adapter Installation Overview

To begin working, you need to set up ODI Master Repository and Work Repository and use Oracle Data Integrator (ODI) and optionally if you are using Oracle GoldenGate, you need to install and configure Oracle GoldenGate to perform real-time ETL.

Double-click the NCC_STG_LS node to display the Logical Data Server: Name dialog.

Display the Definition tab.

Edit the NCC_STG_LS Logical Data Server and ensure that for the appropriate Context (for example, Global, Development...), the value in the Physical Schemas column is set to NCC_STG.NCC_STG (Physical Schema created in Physical Data Server).

For Oracle GoldenGate schema, the default password is set during the setup phase. For example, ggate. To change the password, change the default password in the related prm and oby files. For more information, see "Edit Oracle GoldenGate schema and password."

For Oracle GoldenGate schema, the default password is set during the setup phase. For example, ggate. To change the password, change the default password in the related prm and oby files. For more information, see Edit Oracle GoldenGate schema and password. "Edit ggate default schema and password".

To do Trandata, you need to enable supplemental logging on the source. To enable Supplemental logging, use the following command:

alter database add supplemental log data;

Copy source config file to $GGATE directory. The files for the source system are generated at the following location:

$ORACLE_HOME/ocdm/addon/adapter/ncc/goldengate_param/src/src_ccs

Note:

Files in $ORACLE_HOME/ocdm/addon/adapter/ncc/goldengate_param/src/src_be are configuration files for source where e2be_admin schema located.

These files must be copied on the source to the following location $GGATEE using the same directory structure:

Copy files in goldengate_param/src/src_ccs/dirprm to $GGATEE/dirprm

Copy files in goldengate_param/src/src_ccs/diroby to $GGATEE/diroby

Config manager port. The default manager port at source is 7890. As required, edit this port in the file:

$GGATEE/dirprm/mgr.prm

Config RMTHOST. Change the RMTHOST and MGRPORT in dpump.prm files in the $GGATEE/dirprm directory as required for your working environment:

RMTHOST Remote Host Name, MGRPORT Port

For example:

rmthost slc00tcw, mgrport 7809

Config CCS_ADMIN schema at EXTRACT. The default CCS_ADMIN schema for the NCC Adapter is NCC_SRC_DEMO. Change the source schema name according to your source schemas. For example, change schema NCC_SRC_ DEMO to CCS_ADMIN.

Configure Change Capture using a Data Pump. The goals of this method are to:

Configure and add the Extract process that will capture changes

Add the local trail that will store these changes.

Configure and add a data pump Extract to read the local trail and create a remote trail on the target.

Add the remote trail.

Execute the following command on the source CCS_ADMIN system to define an extract group named ext1 and to define a data pump extract named dpump to pull data from the local Oracle GoldenGate trail and route these changes to Oracle GoldenGate on the target.