1 About the BRM Adapter for Oracle Communications Data Model

This chapter describes the Oracle Communication Billing and Revenue Management Adapter for Oracle Communications Data Model (BRM Adapter).

For information about the Oracle Communications Data Model, see Oracle Communications Data Model Implementation and Operations Guide.

About the BRM Adapter

The BRM Adapter is an option for Oracle Communications Data Model. You use the BRM Adapter to populate the foundation layer (that is, the base, reference, and lookup tables) of an Oracle Communications Data Model warehouse with the data from a BRM source system.

Figure 1-1 shows the BRM Adapter architecture.

The BRM adapter supports both Oracle Data Integrator and Oracle GoldenGate.

Oracle Data Integrator is used for batch loading (to the staging layer) and for transforming the data in the staging layer and loading it to the foundation layer of the Oracle Communications Data Model.

Oracle GoldenGate is used for real-time data feeds to the staging layer.

Figure 1-1 BRM Adapter Architecture

Description of Figure 1-1 follows
Description of ''Figure 1-1 BRM Adapter Architecture''

Components of the BRM Adapter

The BRM Adapter uses the following components:

  • Database schemas used by the BRM Adapter

  • Oracle Data Integrator

  • Oracle GoldenGate

  • Oracle Communications Data Model

  • Billing and Revenue Management source system

Database Schemas Used by the BRM Adapter

The BRM Adapter uses the following database schemas:

  • Source schemas: The Oracle Communications Billing and Revenue Management (BRM) database schema, defined as BRM_SRC schema.

    See "BRM Source and Oracle Communications Data Model Target Tables" for information on the specific source objects.

  • Staging layer schema. The BRM Adapter uses a staging layer when loading data from the BRM source system to the Oracle Communications Data Model warehouse. The staging layer schema stores changed data and historical data and is used as the source schema when loading the foundation layer objects of the Oracle Communications Data Model.

    The staging layer database schema is defined as BRM_STG schema.

  • Target schema. The target of the BRM Adapter is an Oracle Communications Data Model warehouse. The specific target objects are the foundation layer objects. These objects are defined in the Oracle Communications Data Model OCDM_SYS schema. For information about the OCDM_SYS schema, see Oracle Communications Data Model Reference.

    The BRM Adapter defines additional procedures in the OCDM_SYS schema (see "OCDM_SYS Objects for the BRM Adapter").

Oracle Data Integrator

The BRM Adapter uses extract, transform, and load (ETL) procedures created in Oracle Data Integrator for the initial load of the foundation layer of the Oracle Communications Data Model warehouse (that is, the base, reference, and lookup tables in the OCDM_SYS schema). You can also use the Oracle Data Integrator ETL procedures to perform a scheduled refresh of the data in the warehouse.

For more information on the use of Oracle Data Integrator ETL procedures with the BRM Adapter, see:

Oracle GoldenGate

After the initial load of the foundation layer of the Oracle Communications Data Model, you can use Oracle GoldenGate to perform real-time feeds of the BRM source data to the staging layer.

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

BRM Adapter Execution Flows

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

Execution Flow Using the BRM Adapter with Only Oracle Data Integrator

When you use the BRM Adapter with only Oracle Data Integrator, this method of using the BRM Adapter is the Oracle Data Integrator-pull version.

You always use the Oracle Data Integrator-pull version for the initial load of the data warehouse. The Oracle Data Integrator-pull version also provides the option to refresh the data in the warehouse at regular periods.

Figure 1-2 illustrates the BRM Adapter execution flow when using the adapter with only Oracle Data Integrator.

Figure 1-2 Execution Flow When Using the BRM Adapter with Only Oracle Data Integrator

Description of Figure 1-2 follows
Description of ''Figure 1-2 Execution Flow When Using the BRM Adapter with Only Oracle Data Integrator''

When using Oracle Data Integrator-pull version, the execution flow is as follows (as shown in Figure 1-2):

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

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

  3. (Step 4) The BRM Adapter loads the delta tables with the changed data between staging table and last day table (staging table 'MINUS' last day table).

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

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

When you use the BRM Adapter with Oracle Data Integrator and Oracle GoldenGate to refresh the foundation layer of the Oracle Communications Data Model warehouse, this method allows the data in the foundation layer to be synchronized with the BRM source data.

Note:

You always use Oracle Data Integrator pull-version for the initial load of the foundation layer of the Oracle Communications Data Model warehouse.

Figure 1-3 illustrates the BRM Adapter execution flow when using the BRM Adapter with Oracle Data Integrator and Oracle GoldenGate.

Figure 1-3 Execution Flow When Using the BRM Adapter with Oracle Data Integrator and Oracle GoldenGate

Description of Figure 1-3 follows
Description of ''Figure 1-3 Execution Flow When Using the BRM Adapter with Oracle Data Integrator and Oracle GoldenGate''

When using Oracle Data Integrator and Oracle GoldenGate with the BRM Adapter, the execution flow is as follows (as shown in Figure 1-3):

  1. (Step 1) When new data is updated in the BRM source database, Oracle GoldenGate extracts the new data and uses it to populate the staging layer database tables.

  2. (Steps 2 and 3) After the staging tables are updated by the Oracle GoldenGate extract process, the STG_OCDM_OGG_CDC_LOAD_SCENERIO_PKG procedure loads the delta tables in the staging layer with data from the staging tables and the delta history tables in the staging layer 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) BRM Adapter, using Oracle Data Integrator, loads the data from the delta tables into to the foundation layer of Oracle Communications Data Model warehouse.