Ability to execute Logical queries through REST API from Custom Application to OAC

BalaGuddeti-Oracle

Use case:  You are planning to use Oracle Apex to execute the Logical queries to OAC programmatically and expecting a Physical Query/ Result set from it.  Custom application is less performant and unable to generate the Optimized Physical Queries. Hence, the business need is to leverage Analytics engine query optimization, dynamic query generation capabilities.

As of now Best Known Solution:

The best solution we have at the moment is JDBC.

Here is a blog post showing an example:

https://blogs.oracle.com/analytics/post/query-your-oac-semantic-model-from-oci-data-science-environment

OAC Should allow queries through REST APIs

Gabby Rubin-Oracle

OAC provides SOAP API that includes LSQL capabilities. It is probably the preferred approach for your use case.