nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

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?

Find more posts tagged with

API

REST API

Accepted answers

Steve F-2

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.

All comments

Steve F-2

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.

Steve F-2

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?

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
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…

Top Leaders

Mallikarjuna Kuppauru-Oracle 80