Calling BI Services From External Applications

Did you know that you can get your Fusion Applications reports and analytics data delivered direct to your external applications? It's done using the built-in Oracle OBIEE web services. So to expand on the section in the Getting Started with BI post, let's take a brief look at the features, both of which are available to both on-premises and Oracle Cloud deployments.

BI Analytics

Fusion Applications contains thousands of embedded analytics that give end users the information they need to take effective action, often known as managing-by-exception. As such this important data can be useful in other systems, such as corporate dashboards, intranet portals, or related integrated systems. Analytics are also often visual and as such there is support for return types of XML and HTML. As well as running existing reports, the API also supports scheduling, manipulating the BI Catalog, and even running ad-hoc SQL as a report. You will find the WSDL that describes the services available at the following URL: http://[YourBIserver]/analytics-ws/saw.dll/wsdl/v7 and take a look at the following embedded overview video (here).



BI Publisher

BI Publisher reports are often required for official documentation and as such making them available to other processes and systems may be a very appealing option to many organizations. The separate PI Publisher API supports a similarly broad selection of features through its services, including executing and scheduling existing reports and options for managing the complete catalog. You will find the WSDL that describes the BI Publisher services available at the following URL: https://[yourBIserver]/xmlpserver/services/PublicReportService?WSDL and take a look at the following embedded overview video here.


Resources

Comments:

HI Richard,

Nice Article!!

i have one question in relation to this, so can we embedd BI analysis in our External Application? is this possible?

Posted by apoorv Jain on July 01, 2014 at 05:18 AM PDT #

Hi Apoorv
Yes, you should be able to get the XML or HTML equivalent which you can manipulate into your external application. Take a look at the API's in the integrators guide (linked above) for more details on the options.
Hope this helps,
Richard

Posted by Richard Bingham on July 01, 2014 at 06:06 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow us on twitter Fusion Applications Extensibility, Customizations and Integration forum Fusion Applications Dev Relations YouTube Channel
This blog offers news, tips and information for developers building extensions, customizations and integrations for Oracle Fusion Applications.

Search

Categories
Archives
« April 2015
SunMonTueWedThuFriSat
   
1
3
4
5
6
8
10
11
12
15
16
17
18
19
22
24
25
26
28
29
30
  
       
Today