Integration Guide for Oracle Billing Insight > Integrating Oracle Billing Insight With Oracle BRM >

About BRM Provider

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

• Directly to the Oracle Billing Insight database. You can configure BRM Provider to first move Oracle BRM 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 BRM staging database directly from Oracle Billing Insight. This method requires that your implementation of Oracle Billing Insight be able to access the Oracle BRM staging database directly.

  (To use this method, when you configure BRM Provider, set the OUTPUT_TYPE property in the BRMProvider.properties file to TABLE.)

• To a text billing file. BRM 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 can not access the Oracle BRM staging database directly from Oracle Billing Insight, such as where Oracle Billing Insight is an On-Demand (service cloud) implementation and Oracle BRM is On-Premise.

  (To use this method, when you configure BRM Provider, set the OUTPUT_TYPE property in the BRMProvider.properties file to FILE.)

For information about how Oracle BRM data maps and synchronizes with Oracle Billing Insight, see Reference for Mapping of Oracle BRM and Oracle Billing Insight Data Objects.

Depending on the data volume, use the server configuration appropriate for unloading billing data from Oracle BRM using BRM Provider:

• Directly from the Oracle BRM 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 BRM server.

About the BRM Provider Load Processes

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

The pre-staging schema contains over thirty BRM tables, a database link to connect to the Oracle BRM database, and data loading control tables. For details, see Integration Extension Points.

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

• Master
• Postpay
• Unbilled
• Prepay

Each extract and load process from Oracle BRM 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.