Tuesday, May 29, 2012

OBIEE reports to Webcenter Content (UCM)

I was asked by a customer to work on a POC to show how an end-user can run an OBIEE 11g analysis and check it in automatically into Webcenter Content (UCM), this solution doesn't involve BPEL processes. In case you’re not familiar, Webcenter content (WCC) is an enterprise grade content management solution from Oracle. It is also extensible by using the many Java APIs that are available out of the box.
With the introduction of the action framework in OBIEE 11g there are endless possibilities to integrate OBIEE with other applications. For this POC we leveraged the action framework to call a WCC API called CHECKIN_UNIVERSAL via the RDIC (Remote IntraDoc Client) a light weight communication protocol for the Content server. I took the opportunity of the long Memorial Day week end to put something together. 
A report can be checked into the content management solution either directy by calling the action or at the completion of an iBot/agent. Following are few screenshots to illustrate the functionality. When I get a chance I will document the step by step approach for the implementation. 

  • log into OBIEE and select the action "UCM"

  • Enter the parameters: Title, Document Type, The report to be checked into UCM 

Here are the parameters for the action

Once the success message is displayed, the report is available in WCC. Log into WCC and do a search 

and voila, our report is checked in!

The action can also be invoked from an agent which is pretty cool