Integration of Oracle Analytical tool (OBIEE) in external portals or applications

The purpose of this article is to discuss the integration (as consistently as possible) of Oracle Analytical tool (OBIEE) in externals portals or applications , in order to take it into account when choosing your best option.

As a first step, you need to understand what capabilities are offered by OBIEE, only then can the necessary comparasions be made.

So, where we need them, it’s far better to retrieve the precise numbers to analyze data (detailed below as Integrate using WebService API). Anyway in contrast to use tables in order to analyze data, visual form of analysis becomes meaningful reducing time on analysis. By these specifications, the information available at OBIEE Reports can be integrated, not just precise numbers but also graphs (detailed below as Integrate using GO URL).

Now, take a look at the comprehensive explication of the two consistent methodologies:

Integrating OBIEE into an External Portal using WebService API.

Well, note that in certain situations, the end user may need retrieve results from a query. In this case, you can integrate an external portal with the help of WebService provided by OBIEE as it's detailed below:

First of all, let me say that Oracle BI provides many Webservice, have an eye for details in:

http://Server_IP:9704/analytics/saw.dll?WSDL

So, firstly the thing to check would be the logon.

In this way, we could use WebService to invoke “logon” function within SAWSessionService. Once we send a Request, we obtain a “SessionId” as a Response. As it’s shown below:

Once Session Id is returned, in this case (based on XML representation of the analisis), we want to retrieve values included in a table provided by OBIEE, such as:

So, let’s look at XML request (Note: navigate to “Advanced” section in order to obtain xml request):

Once Session Id and xml report are retrieved, the let’s use Web Service to invoke: getResults within XmlViewService

In other words, as you see avobe, as a result (once WebService invoked) we obtain the precise values!:

Importantly, one thing to be aware is that this methodology allows having data stored on Analytical DDBB rather than OBIEE Dashboard reports.

2. Integrating OBIEE into an External Portal using GO URL.

GO URL command can be used in order to incorporate Oracle Analytical results within other applications or portals. Truth be told, Oracle Analytical tool (OBIEE) is integrated into Operational Siebel CRM using this methodology (GO URL). Well, below are detailed instructions on how structure of the GO URL is:

Syntax for accessing an OBIEE Dashboard:

http://Server_IP:9704/analytics/saw.dll?Dashboard&NQUser=X&NQPassword=X