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

Process of Integrating Oracle BRM With Oracle Billing Insight

The process of initial integration of Oracle Billing Insight with Oracle Communications Billing and Revenue Management (BRM) requires that you install and configure required software and load data in bulk.

To integrate Oracle BRM with Oracle Billing Insight, perform the following tasks:

1. Identify the integration solution you need to integrate Oracle BRM data with Oracle Billing Insight for your deployment:
   • Loading Oracle BRM data directly to Oracle Billing Insight database tables. Use this option if your Oracle Billing Insight database can access the Oracle BRM database directly. This method uses BRM Provider, which you configure to output Oracle BRM billing data to a pre-staging schema installed on the Oracle Billing Insight database, and load the data directly to the Oracle Billing Insight database production tables. BRM Provider makes use of specialized ODI processes described in this chapter.
   • Extracting Oracle BRM data to flat text files. Use this option if your Oracle Billing Insight database does not have direct access to the Oracle BRM staging database, such as if you have an On-Demand (cloud service) deployment of Oracle Billing Insight and Oracle BRM is On-Premise. This integration solution uses BRM Provider, which you configure to extract Oracle BRM billing data into billing text files. BRM Provider makes use of specialized ODI processes described in this chapter.

     You must then FTP the files to Oracle where the hosting team will use the standard Oracle Billing Insight ODI processes to load the billing text file into the Oracle Billing Insight database production tables. The standard Oracle Billing Insight ODI processes are described in Administration Guide for Oracle Billing Insight.

2. Verify that your Oracle BRM data conforms to the requirements of Oracle Billing Insight described in Assumptions About Oracle BRM Data. 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.
3. Follow the steps in Process of Installing and Configuring Oracle BRM Integration Components. (It is in the configuration of BRM Provider that you specify Oracle BRM data loading output to either files or tables.)

   For more information about BRM Provider and BRM AQAdapter, see About BRM Provider and About BRM AQAdapter.

4. Configuring Mapping Tables.
5. Loading Oracle BRM Master Data to Oracle Billing Insight

   If you output Oracle BRM master data to a flat file (you set the OUTPUT_TYPE property in the BRMProvider.properties file to FILE when configuring BRM Provider), then also copy the generated master text files to the appropriate load input directory on your Oracle Billing Insight installation, and load the master data files using the standard ODI load processes described in Administration Guide for Oracle Billing Insight.

6. Provisioning Oracle BRM Account Data in Batch to Oracle Billing Insight
7. Loading Oracle BRM Data (Postpay, Unbilled, and Prepay) to Oracle Billing Insight

   If you output Oracle BRM billing data to a flat file (you set the OUTPUT_TYPE property in the BRMProvider.properties file to FILE when configuring BRM Provider), then FTP the generated billing files to the appropriate load input directory on your Oracle Billing Insight installation. The Oracle Service Cloud hosting team will load the billing data files using the standard ODI load processes described in Administration Guide for Oracle Billing Insight.