Hi Experts
I'm getting 401 authentication error while calling OAC report using soap web service basic credentials. Please help me how to pass basic credentials like username password and run report.
Hi @learning123 ,
The above link is for Publisher, but as your talk about OAC report, I assume you mean "classic" analyses/dashboards and you are calling the WSDL located at /analytics-ws/saw.dll/wsdl/v12 ?
If that's the case, you need to authenticate first, there is a method for it. The thing is that OAC does use a SSO with IDCS etc., and the webservice should preferably be called using a token instead of your credentials (username/password). Even more so if you have MFA enable: the webservice will not be able to ask you for your authenticator code or whatever form of MFA you have enabled. In that case you should use the token instead to tell the webservice you are authenticated.
Can you do a simple Browser Test:
Navigate to: https://<oac-domain>/xmlpserver/services/v2/ReportService?wsdl If a login prompt appears → enter credentials.
If login fails → credentials invalid for SOAP
If login succeeds → Basic Auth is enabled and working
@Gianni Ceresa thank you, is there a way to authenticate using fusion user name and passport. I could see my OAC instance is using fusion login as well as idcs.. both option is available
as im calling the report using SOAP web service, is it possible to pass this in the basic authentication ?
If you read the specification of the web services, you will see there is one to authenticate and receive a session ID you should then pass to all your requests. That's the historical way to use the web service, before the token was introduced recently.
You can't use just basic authentication, because that isn't something supported by the service (it will be ignored).
You should use the methods of the SAWSessionService service to login and logout when done: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/c_sawsessionservice_service.html#GUID-7FF44E3E-AA62-4411-83DE-AC6DDB1B0A88
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
There is no option for legend title in many visualization types.
