Skip Headers
Oracle® Communications Data Model Adapters and Analytics User's Guide
Release 11.3.2

E37699-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 (NCC Adapter).

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 is Oracle Communication 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 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.

Overview of Network Charging and Control Application Adapter

The Oracle Communications Network Charging and Control Adapter for Oracle Communications Data Model (sometimes called the NCC Adapter for Oracle Communications Data Model) is an option of the Oracle Communications Data Model. You can use the NCC Adapter for Oracle Communications Data Model 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 (NCC) system.

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

Figure 4-1 Overview of NCC-OCDM Adapter Architecture

Description of Figure 4-1 follows
Description of "Figure 4-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

Components of the NCC Adapter for Oracle Communications Data Model

The NCC Adapter for Oracle Communications Data Model uses the following components:

Database Schemas Used by the NCC Adapter for Oracle Communications Data Model

The NCC Adapter for Oracle Communications Data Model uses the following Database schemas:

  • Source schemas The source of the NCC Adapter for Oracle Communications Data Model is an 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 for Oracle Communications Data Model uses a staging area when loading data from the NCC system to foundation layer objects of an Oracle Communications Data Model warehouse. This staging area 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 for Oracle Communications Data Model defines the staging 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 for Oracle Communications Data Model is an Oracle Communications Data Model warehouse. The specific target objects are the foundation layer objects of the 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 for Oracle Communications Data Model defines additional procedures in the ocdm_sys schema. These procedures are outlined in "Definitions Added to the ocdm_sys Schema".

Oracle Data Integrator

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

For more information on the use of ODI with the NCC Adapter for Oracle Communications Data Model, see the following topics:

Oracle GoldenGate

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

For more information on the use of Oracle GoldenGate with the NCC Adapter for Oracle Communications Data Model, see the following topics:

NCC Adapter for Oracle Communications Data Model Execution Flows

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

Execution Flow When Using the Adapter Oracle GoldenGate and ODI

When you use the NCC Adapter for Oracle Communications Data Model 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 for Oracle Communications Data Model execution flow when using the adapter with Oracle GoldenGate.

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

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

When using Oracle GoldenGate with the NCC Adapter for Oracle Communications Data Model, the execution flow is as follows:

  1. Assuming that all Oracle GoldenGate processes for the NCC Adapter for Oracle Communications Data Model are in running mode, whenever new data comes into the source database, the GoldenGate parameter files extract that new incoming data and use it to populate the normal staging tables.

  2. (Steps 2 and 3 in the diagram) The pre_ocdm_load procedure executes and 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 always synchronized with source data. Once 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 in the diagram) ODI 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 When Using the Adapter with only ODI

You can use the NCC Adapter for Oracle Communications Data Model with Oracle Data Integrator (ODI) alone. This method of using the NCC Adapter for Oracle Communications Data Model is sometimes called the ODI-pull version of the NCC Adapter for Oracle Communications Data Model.

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

Figure 4-3 illustrates the NCC Adapter for Oracle Communications Data Model execution flow when using the adapter only with ODI.

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

Description of Figure 4-3 follows
Description of "Figure 4-3 Execution Flow When Using the Adapter without Oracle GoldenGate"

When using this approach, the execution process is as follows:

  1. (Steps 1 and 3 in the diagram) The adapter, using ODI, loads the data from the source database into stage database.

  2. (Steps 2 and 5 in the diagram) Using pre and post procedures, the adapter loads data into several tables stage database tables; for example, lastday, delta, and history tables.

  3. (Step 4 in the diagram) The adapter loads the delta tables in the staging area using normal table 'MINUS' last day table.

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