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

E37699-03
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

5 Using the NCC Adapter

Provides information about populating an Oracle Communications Data Model warehouse using the NCC Adapter for Oracle Communications Data Model.

This chapter contains the following topics:

For information on installing and configuring the NCC Adapter for Oracle Communications Data Model, see Oracle Communications Data Model Adapters and Analytics User's Guide.

For detailed information about the objects and ETL associated with the NCC Adapter for Oracle Communications Data Model, see Oracle Communications Data Model Reference.

Populating a Warehouse Using the NCC Adapter for Oracle Communications Data Model

You use the NCC Adapter for Oracle Communications Data Model to populate or refresh the foundation layer of the Oracle Communications Data Model warehouse (that is, the base, reference, and lookup tables defined in the ocdm_sys schema). For more information, see:

After you use the NCC Adapter for Oracle Communications Data Model to populate the foundation layer, you populate or refresh the access layer of the Oracle Communications Data Model (that is, the derived tables, aggregate tables, OLAP cubes, and data mining models defined in the ocdm_sys schema) in the same manner as you would if you were not using an application adapter for Oracle Communications Data Model to populate the foundation layer. For more information, see Oracle Communications Data Model Implementation and Operations Guide.

Initial Loading Using the NCC Adapter for Oracle Communications Data Model

To perform an initial load of the foundation layer of an Oracle Communications Data Model warehouse using the NCC Adapter for Oracle Communications Data Model, you use Oracle Data Integrator (ODI), take the following steps:

  1. Verify that the installation and configuration created the schema objects described in "Schema Definitions Added by the NCC Adapter for Oracle Communications Data Model".

    See:

    Oracle Communications Data Model Installation Guide for instructions on installing and configuring the NCC Adapter for Oracle Communications Data Model for use by ODI.
  2. From ODI Studio Designer, go to the NCC_OCDM project, then take the following steps:

    1. Select SRC_STG_NONOGG, then Packages, and then, select and execute the following packages:

      • SRC_STG_LOAD_NON_OGG_PKG

      • SRC_STG_EDR_LOAD_INITIAL_PKG

    2. Select STG_OCDM, then Packages, and then, select and execute the following packages:

      • STG_OCDM_INITIAL_LOAD_PKG

      • STG_OCDM_EDR_PKG

See:

"NCC Adapter ODI NCC_OCDM Project" for more information on the packages and "Execution Flow When Using the Adapter with only ODI" for a description of the execution flow for the initial load.

Refreshing the Data Using the NCC Adapter for Oracle Communications Data Model

Once you have performed an initial data load of an Oracle Communications Data Model warehouse, you need to refresh the data.

You use the NCC Adapter for Oracle Communications Data Model to refresh the data in the foundation layer of an Oracle Communications Data Model warehouse. There are two different ways that you can refresh the data in the foundation layer:

Refreshing the Foundation Layer on a Scheduled Basis

If you are not using the NCC Adapter for Oracle Communications Data Model with Oracle GoldenGate to populate the foundation layer of an Oracle Communications Data Model warehouse (that is, the base, reference, and lookup tables) with real-time data, you refresh the foundation layer on a scheduled basis using Oracle Data Integrator (ODI).

To refresh the data in the foundation layer using only ODI, take the following steps:

  1. Verify that the installation and configuration created the schema objects described in "Schema Definitions Added by the NCC Adapter for Oracle Communications Data Model".

    See:

    Oracle Communications Data Model Installation Guide for instructions on installing and configuring the NCC Adapter for Oracle Communications Data Model for use by ODI.
  2. From ODI Studio Designer, go to the NCC_OCDM project, then take the following steps:

    1. Select SRC_STG_NONOGG, then Packages, and then, select and execute the following packages:

      • SRC_STG_LOAD_NON_OGG_PKG

      • SRC_STG_EDR_LOAD_INCREMENTAL_PKG

    2. Select STG_OCDM, then Packages, and then, select and execute the following packages:

      • STG_OCDM_INITIAL_LOAD_PKG

      • STG_OCDM_EDR_PKG

Refreshing the Foundation Layer with Real-Time Data

After performing an initial load of the Oracle Communications Data Model warehouse as described in "Initial Loading Using the NCC Adapter for Oracle Communications Data Model", you can refresh the data in the foundation layer of an Oracle Communications Data Model warehouse on a real-time basis.

Take the followings steps to ensure that to the data in the foundation layer of an Oracle Communications Data Model warehouse in this manner:

  1. Install the NCC Adapter for Oracle Communications Data Model and configure it for use by both Oracle GoldenGate and Oracle Data Integrator (ODI) and as described in Oracle Communications Data Model Installation Guide.

    Verify that the installation and configuration created the schema objects described in "Schema Definitions Added by the NCC Adapter for Oracle Communications Data Model".

  2. From the GGSCI prompt, issue info all commands to verify that the Oracle GoldenGate processes needed by the NCC Adapter for Oracle Communications Data Model (listed below) are running.

    Source System Processes Staging System Processes
    Manager process

    Extract process (EXTNCC)

    Extract Pump process (EXTPNCC)

    Manager process

    Replicate process (REPNCC)


    The following code shows the issuing of these commands with successful results.

    GGSCI>  (mypc1)  5> info all
    
    Program    Status   Group    Lag        Time Since Chkpt
    
    MANAGER    RUNNING
    EXTRACT    RUNNING  EXTNCC   00:00:00   00:00:02
    EXTRACT    RUNNING  EXTPNCC  00:00:00   00:00:06
    
    GGSCI>  (ocdm01)  2> info all
    
    Program    Status   Group    Lag        Time Since Chkpt
    
    MANAGER    RUNNING
    REPLICAT   RUNNING  REPNCC   00:00:00   00:03:09
    

    Tips:

    If you have two source systems, check process status on both source systems.

    For commands to manage Oracle GoldenGate processes, see Oracle Communications Data Model Installation Guide.

  3. From ODI Studio Designer, go to the NCC_OCDM project, then take the following steps:

    1. Select SRC_STG_NONOGG, then select Procedures, and then select and execute the EXEC_ NORMAL_TABLES_PKG.

    2. Select STG_OCDM, then select Packages, and then, select and execute the STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG.

    See:

    "NCC Adapter ODI NCC_OCDM Project" for more information on the packages; and "Execution Flow When Using the Adapter Oracle GoldenGate and ODI" for an explanation of the execution flow.