5 Using the NCC Adapter

This chapter provides information about populating an Oracle Communications Data Model warehouse using the NCC Adapter.

This chapter contains the following topics:

For information on installing and configuring the NCC Adapter, see Oracle Communications Data Model Adapters and Analytics Installation Guide.

For detailed information about the objects and extract, transform, and load (ETL) associated with the NCC Adapter, see Chapter 6, "NCC Adapter Reference".

About Populating a Warehouse Using the NCC Adapter

You use the NCC Adapter 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).

After you use the NCC Adapter to populate the foundation layer, use the Oracle Communications Data Model procedures to populate or refresh the access layer (that is, the derived tables, aggregate tables, Oracle 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

To perform an initial load of the foundation layer of an Oracle Communications Data Model warehouse using the NCC Adapter, use Oracle Data Integrator:

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

    See Also:

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

    1. Select SRC_STG_NONOGG, then Packages, and then, select and run 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 run the following packages:

      • STG_OCDM_INITIAL_LOAD_PKG

      • STG_OCDM_EDR_PKG

See Also:

"Oracle Data Integrator NCC_OCDM Project" for more information on the packages and "Execution Flow Using the NCC Adapter with Only Oracle Data Integrator" for a description of the execution flow for the initial load.

Refreshing the Data Using the NCC Adapter

After you perform an initial data load of an Oracle Communications Data Model warehouse, you must refresh the data. Use the NCC Adapter 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:

Refreshing the Foundation Layer on a Scheduled Basis

If you are not using the NCC Adapter with Oracle GoldenGate, you refresh the foundation layer on a scheduled basis using Oracle Data Integrator.

To refresh the data in the foundation layer using only Oracle Data Integrator, do the following:

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

    See Also:

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

    1. Select SRC_STG_NONOGG, then Packages, and then, select and run 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 run 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", you can refresh the data in the foundation layer of an Oracle Communications Data Model warehouse on a real-time basis.

To ensure that the data in the foundation layer of an Oracle Communications Data Model warehouse is refreshed on a real-time basis, do the following:

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

    Verify that the installation and configuration created the schema objects described in "Schema Definitions Added by the NCC Adapter".

  2. From the GGSCI prompt, run the info all command to verify that the Oracle GoldenGate processes needed by the NCC Adapter are running.

    Table 5-1 lists the Oracle GoldenGate processes on the source and staging systems.

    Table 5-1 Oracle GoldenGate Processes

    Source System Processes Staging System Processes

    Manager process

    Extract process (EXTNCC)

    Extract Pump process (EXTPNCC)

    Manager process

    Replicate process (REPNCC)


    The following code shows these commands and the 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
    

    Tip:

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

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

  3. From Oracle Data Integrator Studio Designer, go to the NCC_OCDM project, and then do the following:

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

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

    See Also:

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