What are my options for connecting to OAC that has been setup with RPD models, and hit a REST endpoint to run queries against the subject areas?
Hi Jaber, Welcome to the Oracle Analytics Community! The following document lists data source supported for the semantic modelsData Sources Supported for Semantic Models Rest API is not supported for data models, but it is supported for connections with datasetsList of Supported Data Sources in Oracle Analytics Cloud > REST API
For anything not currently supported, you would need to file an Ideas lab request (after searching for any already exists).Oracle Analytics Idea Lab
Thanks for posting your question.
Thanks, so that means whatever is published under the "semantic data model" approach would need to be published or made available as a "dataset"? How would that normally happen?
Hi @user13092632 ,
I maybe understand your question wrongly, but if you are asking how you can query your own subject areas built in your RPD and deployed in your OAC, then you can look at the good old SOAP web services that are available for more than 15 years.
https://docs.oracle.com/middleware/1221/biee/BIEIT/methods.htm#i1012352
Right now they aren't part of the OAC documentation, it's a work in progress, but you can see the available services in the above link (OAC has the same services as OBIEE 12c, the only difference is that you can now call the services with a token instead of having to do a login via the dedicated web service).
If you call executeSQLQuery (which take a LSQL query as parameter, not physical SQL), you can execute any query you want against your subject areas.
executeSQLQuery
Promising thanks a ton.
There is also a REST API in DV that let you execute queries (I believe it mostly takes a XML/JSON query instead of directly a LSQL query), but as far as I know, it isn't publicly documented so far. Here again it's something that should come at some point.
The whole DV is fully based on REST APIs, but most of them were considered "internal" and not documented. If you look at your browser developer extension and the various async request executed when you open a workbook, you will easily see that the data on screen is retrieved by an async request, it just isn't as "simple" as the SOAP service described above, because of the missing documentation right now.
And to answer your question:
so that means whatever is published under the "semantic data model" approach would need to be published or made available as a "dataset"?
No, just call the linked SOAP service and you can query directly your subject areas without needing to turn them into a DV dataset.Historically it was also possible to create an ODBC connection to the BI Server directly to query the subject areas via ODBC. I just didn't try that in OAC (last time I did it, I used OBIEE 12c), it maybe isn't going to work because OAC only expose a limited number of services and ports.
Forget ODBC, Steve posted below the link to the doc for a JDBC connection that definitely works in OAC.
I think I probably misunderstood the question as well, and may have answered too quickly.
(ps: I didn't mark it answered) Another alternative. You can use the BIJDBC connector.
Overview to Querying Oracle Analytics Cloud Semantic Models Remotely
It's making sense now. :)
If you want to see a PDF / PNG of a DV canvas then we have a REST endpoint in early adopter that will provide that?
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
So when I click the apply button, it uses the value . Also. How do I stop the auto populate table when the report opens???? I am in OAC
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
