13 Oracle Communications Data Model NCC Application Adapter

This chapter describes the Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model (NCC Adapter).

This chapter includes the following sections:

Oracle Communication Prepaid Charging and Network Charging and Control Overview
Network Charging and Control Application Adapter Architecture Overview
NCC Adapter to Oracle Communications Data Model ETL Table Mapping

For more information on Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model Oracle Communications Data Model Implementation and Operations Guide.

CDMRF1626

Oracle Communication Prepaid Charging and Network Charging and Control Overview

Oracle Communications Prepaid Charging provides critical prepaid capabilities within the overall Oracle Communications Network Charging and Control strategy. Complementary options to Oracle Prepaid Charging include Oracle Communications Messaging Manager and Oracle Communications Number Services Manager.

As the telecommunications market rapidly migrates from a voice-centric to a data-centric, multimedia business environment, Communication Service Providers (CSPs) need reliable real-time charging capabilities for an increasingly diverse set of services. Oracle Communications Prepaid Charging is designed to help operators (MNOs, MVNEs & MVNOs) generate revenue, grow market share, and sustain competitive advantage by providing an agile platform to launch and charge for a full range of innovative service offerings to subscribers. Built to accommodate all content types and network protocols, Oracle Communications Prepaid Charging helps operators to rapidly and cost effectively create new streams of value-added services revenue.

CDMRF1627

Network Charging and Control Application Adapter Architecture Overview

Figure 13-1 shows the Oracle Communications Data Model NCC Adapter Architecture.

CDMRF1628Figure 13-1 Overview of NCC-OCDM Adapter Architecture

Description of "Figure 13-1 Overview of NCC-OCDM Adapter Architecture"

The NCC Adapter with Oracle Communications Data Model includes the following components:

Source System (NCC)
Oracle GoldenGate: To use real-time feed to staging
Oracle Data Integrator: to load from the source system (NCC) to staging (if you decide not to use real-time feed with Oracle GoldenGate, the use a pull version with Oracle Data Integrator) ).
Oracle Communications Data Model

CDMRF1686

NCC Adapter to Oracle Communications Data Model ETL Table Mapping

Table 13-1 lists the mapping overview for NCC Adapter source tables to Oracle Communications Data Model target tables.

CDMRF1687 Table 13-1 NCC Adapter to Oracle Communications Data Model Mapping

ID	Source Table	Target Table
1	BE_BALANCE	DWB_ACCT_BAL_HIST
2	CCS_BALANCE_TYPE	DWL_ACCT_BAL_TYP
3	BE_BUCKET	DWB_ACCT_BAL_BUCKET
4	BE_WALLET	DWR_ACCT
5 & 6	CCS_ACCT, CCS_ACCT_ACCT_REFERENCES	DWR_ACCT
7	CCS_ACCT_REFERENCE	DWR_CUST
8	CCS_ACCT_TYPE	DWL_ACCT_TYP
9	CCS_BALANCE_UNIT	DWL_UOM
10	CCS_WALLET_TYPE	DWL_ACCT_TYP
11	CCS_VOUCHER_REFERENCE	DWR_PRPD_VCHR_INSTNC
12	CCS_VOUCHER_BATCH	DWR_PRPD_VCHR_BTCH
13	CCS_MB_RECHARGE	DWR_PRPD_VCHR_RCHRG_OPTN
14	CCS_RECHARGE_TYPE	DWR_PROD
15	CCS_VOUCHER_TYPE	DWR_PROD
16	CDR (VOUCHER_RECHARGE)	DWB_ACCT_RCHRG
17	CDR (VOICE_CALL)	DWB_WRLS_CALL_EVT
18	CDR (FREEFORM_RECHARGE)	DWB_ACCT_RCHRG
19	CDR (SMS)	DWB_SMS_EVT
20	CDR (PREPAID_DATA)	DWB_DATA_SRVC_EVT