4 About NCC Adapter for Oracle Communications Data Model

This chapter describes the Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model (referred to as the NCC Adapter in this chapter).

This chapter includes the following sections:

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

What Are Oracle Communications Prepaid Charging and Network Charging and Control

Oracle Communications Prepaid Charging provides critical prepaid capabilities within the overall Oracle Communications Network Charging and Control strategy. Complementary options to Oracle Communications 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 and MVNOs) generate revenue, grow market share, and sustain competitive advantages 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.

Overview of NCC Adapter

The Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model (referred to as the NCC Adapter in this chapter) is an option for Oracle Communications Data Model. You can use the NCC Adapter to populate the foundation layer (that is, the base, reference, and lookup tables) of an Oracle Communications Data Model warehouse with data from an Oracle Communications Network Charging and Control system.

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

Figure 4-1 Overview of NCC Adapter Architecture

Description of Figure 4-1 follows
Description of ''Figure 4-1 Overview of NCC Adapter Architecture''

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

  • Source system Oracle Communications Network Charging and Control (NCC)

  • Oracle GoldenGate: To use a real-time feed to staging layer

  • Oracle Data Integrator: to load from the source system Oracle Communications Network Charging and Control (NCC) to staging layer (if you decide not to use real-time feed with Oracle GoldenGate, then you can refresh data with Oracle Data Integrator). For more information see "Execution Flow Using the NCC Adapter with Only Oracle Data Integrator".

  • Oracle Communications Data Model Oracle

Components of the NCC Adapter

The NCC Adapter uses the following components:

Database Schemas Used by the NCC Adapter

The NCC Adapter uses the following database schemas:

  • Source schemas: The source of the NCC Adapter is an Oracle Communications Network Charging and Control (NCC) system as defined by the NCC BE and CSS schemas.

    See "NCC Source Schema Objects" for details on the specific source objects.

  • Staging layer schema: The NCC Adapter uses a staging layer when loading data from the NCC system to the foundation layer objects of an Oracle Communications Data Model warehouse. This staging layer is used for changed data and historical data storage and as a source schema when loading the foundation layer objects of the Oracle Communications Data Model. The NCC Adapter defines the staging layer as a database schema named ncc_stg.

    See "NCC_STG Schema Objects" for more information on the ncc_stg schema.

  • Target schema: The target of the NCC Adapter is an Oracle Communications Data Model warehouse. The specific target objects are the foundation layer objects of Oracle Communications Data Model. These objects are defined in the ocdm_sys schema, which is delivered with Oracle Communications Data Model and documented in Oracle Communications Data Model Reference.

    The NCC Adapter defines additional procedures in the ocdm_sys schema. These procedures are shown in "Definitions Added to the ocdm_sys Schema".

Oracle Data Integrator

The NCC Adapter uses extract, transform, and load (ETL) created in Oracle Data Integrator as the ETL for performing an initial load of the foundation layer objects of Oracle Communications Data Model (that is, the base, reference, and lookup tables). You can also use Oracle Data Integrator ETL to perform a scheduled refresh of the staging layer.

For more information on the use of Oracle Data Integrator with the NCC Adapter, see the following:

Oracle GoldenGate

After you have performed an initial load of the foundation layer objects of Oracle Communications Data Model using Oracle Data Integrator, you can use Oracle GoldenGate for to perform a real-time feed of the NCC source data to the staging layer.

For more information on the use of Oracle GoldenGate with the NCC Adapter, see the following:

NCC Adapter Execution Flows

The NCC Adapter uses a slightly different execution flow depending on whether you are using the adapter with Oracle GoldenGate:

Execution Flow Using the NCC Adapter with Oracle GoldenGate and Oracle Data Integrator

When you use the NCC Adapter with Oracle GoldenGate to refresh the foundation layer of the Oracle Communications Data Model warehouse as described in "Refreshing the Foundation Layer with Real-Time Data", the foundation layer data is always synchronized with the NCC source data.

Figure 4-2 illustrates the NCC Adapter execution flow when using the adapter with Oracle GoldenGate.

Figure 4-2 Execution Flow When Using the NCC Adapter with Oracle GoldenGate

Description of Figure 4-2 follows
Description of ''Figure 4-2 Execution Flow When Using the NCC Adapter with Oracle GoldenGate''

When using Oracle GoldenGate with the NCC Adapter, the execution flow is as follows (as shown in Figure 4-2):

  1. (Step 1) When all Oracle GoldenGate processes for the NCC Adapter are running, whenever new data comes into the source database, Oracle GoldenGate extracts that new incoming data and uses it to populate the normal staging tables.

  2. (Steps 2 and 3) The pre_ocdm_load procedure loads the delta tables in the staging area with data from the normal staging tables and the delta history tables in the staging area with data from the delta tables.

    Note:

    Only the data in the delta history tables remains forever and is always synchronized with source data. After the data in the delta staging tables is loaded into the foundation layer of the Oracle Communications Data Model warehouse, the delta tables are truncated.
  3. (Step 4) Oracle Data Integrator loads data from the delta tables in the staging layer into the foundation layer of the Oracle Communications Data Model warehouse when the data in the staging table changes.

Execution Flow Using the NCC Adapter with Only Oracle Data Integrator

You can use the NCC Adapter with Oracle Data Integrator alone. This method of using the NCC Adapter is sometimes called the Oracle Data Integrator-pull version of the NCC Adapter.

You always use the Oracle Data Integrator-pull version of the NCC Adapter for the initial load that you perform right after installation as described in "Initial Loading Using the NCC Adapter". Later, you can also use it to perform a scheduled data refresh as described in "Refreshing the Foundation Layer on a Scheduled Basis".

Figure 4-3 illustrates the NCC Adapter execution flow when using the adapter only with Oracle Data Integrator.

Figure 4-3 Execution Flow When Using the NCC Adapter Without Oracle GoldenGate

Description of Figure 4-3 follows
Description of ''Figure 4-3 Execution Flow When Using the NCC Adapter Without Oracle GoldenGate''

When using this approach, the execution process is as follows (as shown in Figure 4-3):

  1. (Steps 1 and 3) The NCC Adapter, using Oracle Data Integrator, loads the data from the source database into the staging database.

  2. (Steps 2 and 5) Using procedures, the NCC Adapter loads data into several staging database tables; for example, last day, delta, and history tables.

  3. (Step 4) The NCC Adapter loads the delta tables into the staging area using the normal table 'MINUS' last day table.

  4. (Step 6 in diagram) The NCC Adapter loads the data from the delta tables into the foundation layer of the Oracle Communications Data Model warehouse.