Oracle Analytics Cloud and Server Idea Lab

Products Banner

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

Current Capability

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:

OAC Should allow queries through REST APIs

1 votes

Current Capability · Last Updated

Marked as an existing capability due to the availability of SOAP APIs that can address the requested use case.