OBIEE - Web Services API (SOAP,WSDL)

Saw Object


OBIEE web services is an application programming interface (API) that implements SOAP from the presentation service layer.

Web Services


This API can be used to:

  • start and manage web sessions
  • retrieve results from Oracle BI Presentation Service in XML format
  • embed Oracle BI Presentation Service results in third-party dynamic Web pages and Portal Frameworks including Oracle Portal and any other JSR-168/WSRP compliant Portal
  • merge report parameters and logical SQL to create analyses and return results
  • navigate and manage the Web Catalog.
  • Perform Oracle BI Presentation Catalog management functions

They are referred to as “session based” because you need to first retrieve a session ID with SAWSessionService. These web services are designed for programmatic use.

Obiee provides several webservices that can be reach with their own Url. The Url has this form :

WebService Name of the service Description
SAWSessionService nQSessionService Provide authentication methods such as logon and logoff nd impressonation
WebCatalogService webCatalogService to read and write presentation catalog objects
XMLViewService xmlViewService To retrieve result on a xml format
jobManagementService jobManagementService To manage the job
SecurityService securityService To manage the security (privileges), …
ReplicationService replicationService To manage the replication between Presentation Catalogues
ReportEditingService reportService To manage the report (Adding filter and other conditions)
IBotService ibotService Ibot, Agent
HTMLViewService htmlViewService Give Oracle BI html results. Best candidate to display the report or page from OBIEE as it is within portal
MetadataService metadataService To have information on the metadata MetadataService - Subject Areas, Tables, Columns

The Web Service Definition Language (WSDL) is located here:


The web services for SOA are introduced in 11g, they support only browsing and execution of:

Prompted filters and presentation variables included in the business intelligence objects are supported.

Oracle BI EE dynamically creates a dedicated Web Services Description Language (WSDL) document with its own name space for each agent, analysis, and condition that content designers save to the catalog. Each object has a dedicated WSDL document.


The WSIL is not available until it has been properly configured.

Reference, Documentation

Discover More
Obiee11g Credential Store
(Weblogic|Fusion Middelware) - Credential Store Framework (CSF)

A credential store is the repository of security data that certify the authority of entities used by Java 2, J2EE, and ADF applications. Applications can use the Credential Store, a single, consolidated...
Eclipse Wtp Installation Update
Eclipse - How to consume a web service (OBIEE) with WTP ?

The aim of this article is to show how with WTP, the Web Tools Platform Plugin of Eclipse, you can consume a web service. All the details the Web Service Subproject can be found on this page....
Saw Object
OBIEE - Authentication Web Service with SAWSessionService (nQSessionService)

The OBIEE Web Service SAWSessionService (nQSessionService) provide authentication methods such as logon and logoff.
Saw Object
OBIEE - BI Presentation Service (SAW/OBIPS)

AnswersInteractive DashboardsDelivers The Oracle BI Presentation Service Server: is a pure Web Environment visualize data from the Oracle BI Server through the creation of Interactive Dashboards...
Obiee Answer Cross Join
OBIEE - How to retrieve a result set with the XMLViewService WebService and the logical SQL ?

This article show you how you can easily retrieve information with the help of the XMLViewService OBIEE web services. We are going to make a simple connexion, then sending an Obiee Logical Sql to retrieve...
Obiee Ceim
OBIEE - Logical Sql

The logical SQL is the SQL that understand BI Server. It's a full Ansi 92 SQL (including subqueries and derived tables), plus special functions (SQL extensions) like AGO, TODATE, EVALUATE, and others....
Obi Edition
OBIEE - Mobile Application, Mobile Device

Mobile support in the OBI suite. See 1321539.1BIEE 11g Features: How To Get Started Using OBIEE Mobile Applications With iPhone/iPad Oracle Business Indicators is an application for Apple iPhone...
Card Puncher Data Processing
OBIEE - SOAP / Web Service Demonstration

In every master data management project, you must share your single view of truth. This demo shows the capabilities of the SOAP/WebService API of OBIEE to retrieve information. The demo is performed with...
Presentation Service Session Management Cursor Cache
OBIPS - (Query|Result|Cursor) Cache

When users access objects that run queries (Answers, Prompts, ...), Presentation Services caches the results of the queries. This kind of cache is a client result cache. Presentation Services determines...

Share this page:
Follow us:
Task Runner