Calling BI Services From External Applications
By Richard Bingham-Oracle on Feb 17, 2014
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.
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 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.