Business Intelligence Presentation

About Integration

The information in this chapter is for reference to highlight the integration points between BI Publisher and the Oracle BI Enterprise Edition.

You may need to reference this information in the following scenarios:

• You are upgrading from a 10 release to the 11 release
• You are running a separate installation of BI Publisher and wish to integrate it
• You need to modify the installed configuration

The points of integration discussed in this chapter are:

• Connecting to Oracle BI Server as a data source
• Configuring BI Publisher to use the Oracle BI Presentation Catalog
• Configuring integration with Oracle BI Presentation Services

Prerequisites

Oracle BI Publisher must be installed on the same server with the other components of Oracle BI Enterprise Edition.

The security configuration must be either Oracle Fusion Middleware security or Oracle BI Server security.

Configuring BI Publisher to Use the Oracle BI Presentation Catalog

To manually configure BI Publisher to use the Oracle BI Presentation Catalog, perform the following:

1. On the Server Configuration page in the Catalog region, select Catalog Type: Oracle BI Presentation Catalog
2. Enter the following:

   • Server Version - v6

   • System Username

     Enter BISystemUser

     BISystemUser is a fixed user created during installation for trusted communication between components.

   • System Password

     Enter the password for BISystemUser.

   • Connection Protocol - TCP
3. Click Test Connection to ensure BI Publisher can connect to Oracle BI Presentation Services.
4. Enter the path of the current BI Publisher repository.
5. Click Upload to BI Presentation Catalog. This will upload the contents of your BI Publisher catalog to the BI Presentation catalog.
6. Restart the BI Publisher application.