Integration Guide for Oracle Billing Insight > Integrating Oracle Billing Insight With Oracle Utilities Customer Care And Billing >

About CC&B Provider

You use CC&B Provider to output data from Oracle Utilities CC&B for integration with Oracle Billing Insight. You can configure CC&B Provider to output Oracle Utilities CC&B data in one of two ways, depending on your deployment:

• Directly to the Oracle Billing Insight database. You can configure CC&B Provider to first move Oracle Utilities CC&B data to a pre-staging area, transform and load the data into Oracle Billing Insight staging, and then move it into the Oracle Billing Insight production tables. Your deployment must be able to access the Oracle Utilities CC&B database directly from Oracle Billing Insight. This method requires that your implementation of Oracle Billing Insight be able to access the Oracle Utilities CC&B staging database directly.

  To use this method, when you configure CC&B Provider, set the OUTPUT_TYPE property in the CCBProvider.properties file to TABLE.

• To a text billing file. CC&B Provider can generate text billing files to a location that you specify. You then upload (FTP) the text billing files to the Oracle Billing Insight database, and load the billing data using the standard Oracle Billing Insight data loading processes described in Administration Guide for Oracle Billing Insight. This method provides an integration solution for deployments that cannot access the Oracle Utilities CC&B database directly from Oracle Billing Insight, such as where Oracle Billing Insight is an On-Demand (service cloud) implementation and Oracle Utilities CC&B is On-Premise.

  To use this method, when you configure CC&B Provider, set the OUTPUT_TYPE property in the CCBProvider.properties file to FILE.

For information about how Oracle Utilities CC&B data maps with Oracle Billing Insight, see Reference for Mapping of Oracle Utilities CC&B and Oracle Billing Insight Data Objects.

Depending on the data volume, use the server configuration appropriate for unloading billing data from Oracle Utilities CC&B using CC&B Provider:

• Directly from the Oracle Utilities CC&B server, recommended for a low data volume server.
• From a backup server replicated using Oracle GoldenGate, recommended for a high data volume and performance-bound Oracle Utilities CC&B server.

About the CC&B Provider Load Processes

CC&B Provider consists of a set of Oracle Data Integrator (ODI) processes and a pre-staging schema. The CC&B Provider set of packages, load plans, and scenarios can load billing data from the Oracle Utilities CC&B server into the Oracle Billing Insight database directly or unload the data into text billing files.

The pre-staging schema contains over thirty CC&B tables, a database link to connect to the Oracle Utilities CC&B database, and data loading control tables.

There are two types of billing-related data in Oracle Billing Insight, and each type of data has a dedicated extract and load process for loading Oracle Utilities CC&B data directly to Oracle Billing Insight or to text files:

• Master. For master data, an entire dataset is extracted with each load.
• Postpay. The postpay extract and load process from Oracle Utilities CC&B to Oracle Billing Insight is based on a specific start timestamp (inclusive) and end timestamp (exclusive).

Only one data load process is allowed at a time.