Photo by Myriam Jessier on Unsplash

Execute OTBI Analysis using Web Services

Oracle provides web services to invoke and retrieve data from OTBI (Oracle Transactional Business Intelligence) Analysis. Let’s see how in this post.

Web Services

For a complete list of available web services check out Oracle documentation. We will be focusing on two services and 3 methods.

Login and Create Session

Let’s first login and create a session. Use the below code snippet and provide the correct user name and password.

Web Services URL to be used — https://hostname/analytics-ws/saw.dll?SoapImpl=nQSessionService

The return message will have session id field. The session Id will be passed in the executeXMLQuery method call.

Execute Query

You should have the path to the OTBI Analysis. The path should include the analysis name. Make sure to provide the correct host name.

Web Services URL to be used — https://hostname/analytics-ws/saw.dll?SoapImpl=xmlViewService

The return message will have the rows and a query ID that will be needed if you are using the fetchNext method.

Fetch Additional Records

Use the fetchNext method to fetch additional records from the query. Make sure to pass the queryID value from the executeXMLQuery method response. You need to pass the session ID value as well.

Web Services URL to be used — https://hostname/analytics-ws/saw.dll?SoapImpl=xmlViewService

Hopefully this helps you to execute OTBI Analysis using Web Services. If you have questions let me know. You may also check out my post on invoking BI Publisher report using Web Services here.

Happy Learning and experimenting.

--

--

--

Manager Strategic Cloud Services (Oracle Cloud ERP, EPM), Integration Specialist, Big Data, Data Science & Python Enthusiast)

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

CS371p Spring 2021 Blog: Week of April 5 — April 11

Dart For PHP Developers

Open Source UI libraries from our iOS Mobile team

Running Jupyter Notebook on Visual Studio Code

Easily Coordinate External Deployments with Cloud Manager and Adobe I/O Events: A Step-by-Step…

Performance Testing: Self-built Databases vs. ApsaraDB for RDS

First Steps to the OpenCV-Python

Serving up data from Cloud Storage

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Arun Raj

Arun Raj

Manager Strategic Cloud Services (Oracle Cloud ERP, EPM), Integration Specialist, Big Data, Data Science & Python Enthusiast)

More from Medium

What is OpenLane? How to run RTL2GDS2 flow in OpenLane

OpenLane Architecture

Creating a Bar Chart Race in Python using Spotify Streaming History

Simplest Way To Sending Dashboard Image Integrated Tableau Server Client & LINE MessagingAPI

Data Model Comparisons between Time-Series Databases