Oracle® Communications Data Model Reference Release 11.3.1 Part Number E28440-03 |
|
|
PDF · Mobi · ePub |
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.
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.
Figure 13-1 shows the Oracle Communications Data Model NCC Adapter Architecture.
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
Table 13-1 lists the mapping overview for NCC Adapter source tables to Oracle Communications Data Model target tables.
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 |