Integrate with Oracle Business Intelligence Publisher

Why Integrate with Oracle Business Intelligence Publisher?

Oracle Business Intelligence Publisher belongs to Oracle Fusion Middleware, a comprehensive family of software products that includes a range of application development tools and services.

The integration of Oracle Content Management with Business Intelligence Publisher offers managed folders as a destination for generated reports. For example, payroll reports can be sent to individual employee folders. Manage the folders and folder contents with the easy-to-use interface from mobile, web, or desktop devices. All of the familiar security, sharing, viewing, and collaboration features of Oracle Content Management are available to view and manage your reports.

The screenshot below shows you how reports can be generated in multiple output formats and sent to different destinations. A repository is one of the destinations.

Business Intelligence Publisher Output and Destinations

Prerequisites

There are prerequisites to integrating Oracle Content Management with Oracle Business Intelligence Publisher. Integrations generally require configurations in both applications that are being integrated. So check the documentation on both sides. In addition to the requirements on the OCM side, you need a subscription for the product that you intend to integrate with OCM. See the Oracle Business Intelligence Publisher documentation for any specific requirement. On the Oracle Content Management side, do the following:

Create and activate an Oracle Cloud Account before you begin.
Review Overview of Oracle Content Management, which provides information on interacting with OCM and concepts on access roles for performing certain tasks.
Compare the starter vs. the premium edition of Oracle Content Management. Only the premium edition has all the features.
Create an Oracle Content Management instance.
Take a guided tour of repositories in Oracle Content Management.
Create an asset repository. To set this up, you need to have the repository administrator (CECRepositoryAdministrator) role in Oracle Content Management.

Integration Process

See Set Output Options in Fusion Middleware User's Guide for Oracle Business Intelligence Publisher on how to configure the application for integration.

The screenshot below shows you how Oracle Content Management in Business Intelligence Publisher is set as an output destination.