How to integrate OBIEE dashboards in WebCenter Portal

Oracle WebCenter Portal is a web platform for creating intranets, extranets, composite applications, and self-service portals. One of its main strengths is its ability to allow administrators to decentralized much of the site built-out and maintenance, pushing it out to business users. One of the tools used to enable this business-executed administration is the Resource Catalog, a library of the portal’s reusable and configurable components. It is the Resource Catalog that serves as the main tool to effectively integrate OBIEE dashboards.

Figure 1 – Page composer with the resource catalog shown in the right column

The default catalog comes with many useful built-in components such as polls, lists, blogs, wikis, images, and HTML markup. Once the portal is set up, these components are designed for the business user to drag and drop content onto a page. By exposing OBIEE container objects as resource catalog entries, business users can access OBIEE reports the same way they would any other portal component. They simply open the OBIEE component folder in the Resource Catalog, browse through the list of available reports, and drag and drop the desired report on the page.

Parameters can be passed to the report allowing for customization. To achieve this integration the administrator must go through the one-time steps of:

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

• Creating the BIImpersonatorUser in the security realm using WebLogic console
• Granting the appropriate permissions in FMW Control Enterprise Manager
• Creating a SOAP connection to the OBIEE Server
• Adding the OBIEE Web Catalog to one or more WebCenter Portal Resource Catalogs.

Figure 2 – A portal page with an embedded OBIEE report

Oracle Tech has expertise integrating WebCenter Portal and OBIEE, exposing OBIEE catalogs objects as entries in one or more of the portal’s Resource Catalogs and is well versed in providing these solutions for our clients.

Visit us at Oracle Open World, booth number 2221, to learn more.

Follow Perficient & Oracle on Twitter for the latest posts in our Oracle blog and more.