| Oracle® Communications Data Model Reference Release 11.3.1 Part Number E28440-03 |
|
|
PDF · Mobi · ePub |
| Oracle® Communications Data Model Reference Release 11.3.1 Part Number E28440-03 |
|
|
PDF · Mobi · ePub |
This chapter describes the Oracle Communications Billing and Revenue Management Adapter for Oracle Communications Data Model (BRM Adapter).
This chapter includes the following sections:
For more information on the BRM Adapter for Oracle Communications Data Model, see Oracle Communications Data Model Implementation and Operations Guide.
The BRM Adapter loads data from an Oracle Communications Billing and Revenue Management source system into Oracle Communications Data Model. You can load data in both an initial and an incremental manner. The data from Oracle Communications Billing and Revenue Management populates the Oracle Communications Data Model derived and aggregate tables, reports, and mining models.
BRM Adapter for Oracle Communications Data Model is designed to use the Extract Load and Transform (EL-T) principle. The adapter uses both Oracle GoldenGate and Oracle Data Integrator (ODI). Oracle GoldenGate is used when the user want to provide real-time feed to the staging area, and ODI is used for batch loading (to the staging area) and for transformation in the staging to the Oracle Communications Data Model foundation layer. The BRM Adapter for Oracle Communications Data Model enables the staging layer to be used as an operational data store for near real-time reporting.
Oracle GoldenGate is an option, if you do not require or do not want true real-time feeds, they can you can use the standard bulk load with ODI-only (default). Using ODI Knowledge Module (KM) for Oracle GoldenGate enables a single User Interface (UI) to be used to configure Oracle GoldenGate and ODI on its own.
Oracle Data Integrator is combined with Oracle GoldenGate. This provides a cross-platform data replication and changed data capture for Oracle Communications Billing and Revenue Management with Oracle Communications Data Model.
Figure 14-1 shows the BRM Adapter for Oracle Communications Data Model architecture.
Table 14-1 lists the mapping overview for BRM Adapter source tables to Oracle Communications Data Model target tables.
Table 14-1 BRM Adapter Source to Target Table Mapping
| ID | Source Table | Target Table |
|---|---|---|
|
1 & 2 |
CONFIG_T, CONFIG_BUSINESS_TYPE_T |
DWL_CUST_TYP |
|
1 & 3 |
CONFIG_T,CONFIG_BEID_BALANCES_T |
DWL_ACCT_BAL_TYP |
|
1 & 4 |
CONFIG_T, CONFIG_CUR_CONV_RATES_T |
DWB_CRNCY_EXCHNG_RATE |
|
5 |
IFW_USAGETYPE |
Not yet used but needed to distinguish various usage types |
|
6 |
IFW_TIMEZONE |
DWL_PK_OFPK_TIME |
|
7 |
IFW_CURRENCY |
DWL_CRNCY |
|
8 |
DD_OBJECTS_T |
DWR_SRVC_SPEC |
|
9 |
PRODUCT_T |
DWR_PROD, DWR_SRVC_SPEC_PROD_RLTN |
|
10 |
DISCOUNT_T |
DWR_PROD, DWR_SRVC_SPEC_PROD_RLTN |
|
11 |
RATE_PLAN_T |
DWR_PROD_RTNG_PLN |
|
12 |
DEAL_T |
DWR_PROD |
|
13 |
DEAL_PRODUCTS_T |
DWR_PROD_PKG_ASGN |
|
14 |
PLAN_T |
DWR_PROD_MKT_PLN |
|
15 |
PLAN_SERVICES_T |
DWR_PROD_MKT_PLN_ASGN |
|
16 |
SERVICE_T |
DWR_SRVC, DWR_CUST_FCNG_SRVC, DWB_SRVC_STAT_HIST |
|
16 & 17 |
SERVICE_T, SERVICE_TELCO_GSM_T |
DWR_CUST_FCNG_SRVC |
|
16 & 18 |
SERVICE_T, SERVICE_TELCO_GPRS_T |
DWR_CUST_FCNG_SRVC |
|
16 & 19 |
SERVICE_T, SERVICE_EMAIL_T |
DWR_CUST_FCNG_SRVC |
|
20 |
SERVICE_TELCO_FEATURES_T |
DWR_SRVC_CHTRSTC |
|
21 & 22 |
ACCOUNT_T & ACCOUNT_NAMEINFO_T |
DWR_GEO_CNTRY, DWR_GEO_STATE, DWR_GEO_CITY, DWR_POSTCD, DWR_ADDR_LOC DWR_PRTY, DWR_PRTY_CNCT_INFO, DWR_CUST, DWR_ACCT, DWR_ACCT_PREF_INVC_DLVRY |
|
23 |
BILLINFO_T |
DWR_PRTY, DWR_CUST, DWR_ACCT, DWL_PYMT_MTHD_TYP |
|
24 |
BAL_GRP_T |
DWR_ACCT_BAL_GRP |
|
25 |
PURCHASED_PRODUCT_T |
DWR_SBRP, DWR_SBRP_PRICE_CHRG |
|
26 |
PURCHASED_DISCOUNT_T |
DWR_SBRP, DWR_SBRP_PRICE_CHRG |
|
27 |
BILL_T |
DWB_INVC |
|
28 |
INVOICE_T |
DWB_EVT_INVC_DLVRY |
|
29 |
ITEM_T |
DWB_INVC_ITEM |
|
30 & 31 |
PAYINFO_T, PAYINFO_INV_T |
DWR_GEO_CNTRY, DWR_GEO_STATE, DWR_GEO_CITY, DWR_POSTCD, DWR_ADDR_LOC, DWR_PRTY, DWR_ACCT_PREF_PYMT_MTHD |
|
30 & 32 |
PAYINFO_T, PAYINFO_DD_T |
DWR_PRTY, DWR_ACCT_PREF_PYMT_MTHD |
|
30 & 33 |
PAYINFO_T,PAYINFO_CC_T |
DWR_PRTY, DWR_ACCT_PREF_PYMT_MTHD |
|
34 |
EVENT_T |
used in all "NETWORK Event" type of mapping |
|
35 |
EVENT_BAL_IMPACTS_T |
used in all "NETWORK Event" type of mapping + DWB_NTWK_EVT_ACCT_BAL_IMPC (any events) |
|
36 |
EVENT_SESSION_TLCS_T |
used in all Prepaid/session "NETWORK Event" type of mapping |
|
37 |
EVENT_SESS_TLCS_SVC_CODES_T |
used in all Prepaid/session "NETWORK Event" type of mapping |
|
38 |
EVENT_SESSION_TLCO_GSM_T |
DWB_WRLS_CALL_EVT (Prepaid) |
|
39 |
EVENT_SESSION_TELCO_GPRS_T |
DWB_GPRS_USG_EVT (Prepaid) |
|
40 |
EVENT_BROADBAND_USAGE_T |
DWB_BRDBND_USG_EVT |
|
41 |
EVENT_SESSION_DIALUP_T |
DWB_DATA_SRVC_EVT |
|
42 |
EVENT_DLAY_SESS_TLCS_T |
used in all Postpaid/session "NETWORK Event" type of mapping |
|
43 |
EVENT_DLAY_SESS_TLCS_SVC_CDS_T |
used in all Postpaid/session "NETWORK Event" type of mapping |
|
44 |
EVENT_DLYD_SESSION_TLCO_GPRS_T |
DWB_GPRS_USG_EVT (Postpaid) |
|
45 |
EVENT_DLYD_SESSION_TLCO_GSM_T |
DWB_WRLS_CALL_EVT (Postpaid) |
|
46 |
EVENT_ACTIVITY_TLCS_T |
used in all Prepaid Activity "NETWORK Event" type of mapping |
|
47 |
EVENT_ACTV_TLCS_SVC_CODES_T |
used in all Prepaid Activity "NETWORK Event" type of mapping |
|
48 |
EVENT_DLAY_ACTV_TLCS_SVC_CDS_T |
|
|
49 |
EVENT_DLAY_ACTV_TLCS_T |
|
|
50 |
EVENT_TAX_JURISDICTIONS_T |
|
|
51 |
EVENT_RUM_MAP_T |
|
|
52 |
EVENT_BILLING_PAYMENT_T |
DWB_ACCT_RCHRG |
|
53 |
EVENT_BILLING_PAYMENT_DD_T |
DWB_ACCT_RCHRG |
|
54 |
EVENT_BILLING_PAYMENT_CASH_T |
DWB_ACCT_RCHRG |
|
55 |
EVENT_BILLING_PAYMENT_CC_T |
DWB_ACCT_RCHRG |
|
56 |
EVENT_BILLING_PAYMENT_CHECK_T |
DWB_ACCT_RCHRG |
|
57 |
EVENT_BILLING_PAYMENT_FAILED_T |
DWB_ACCT_RCHRG |
|
58 |
EVENT_BILLING_PAYMENT_PAYORD_T |
DWB_ACCT_RCHRG |
|
59 |
EVENT_BILLING_PAYMENT_POST_T |
DWB_ACCT_RCHRG |
|
60 |
EVENT_BILLING_PAYMENT_WTRAN_T |
DWB_ACCT_RCHRG |
|
61 |
NOTE_T |
DWB_EVT_PRTY_INTRACN |
|
 Copyright © 2010, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
