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.
