Which REST APIs to use for OAC

user13092632

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?

SteveF-Oracle

Hi Jaber,

Welcome to the Oracle Analytics Community!

The following document lists data source supported for the semantic models

Data Sources Supported for Semantic Models

Rest API is not supported for data models, but it is supported for connections with datasets
List 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.

user13092632

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?

Gianni Ceresa

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.

user13092632

Promising thanks a ton.

Gianni Ceresa

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.

Gianni Ceresa

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.

SteveF-Oracle

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

user13092632

It's making sense now. :)

Mike Durran-Oracle

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?