REST API for Oracle Analytics Cloud

prakashj

Description

OAC should have documented REST api interface that allows to do the following:

• System Management: Take snapshots (complete/RPD only), store snapshots to object store or within OAC, Create Groups
• DV apis: Monitor data flows, replication jobs and result sets
• Agent monitoring

Thanks

Prakash

Use Case and Business Need

Ability to take snapshot and backup is essential for any enterprise platform. If we want to use the replication, need ability to get the status and setup alerting if any jobs fail

More details

There is no documented API for Oracle Analytics Cloud in the documentation. There used to be Web Services in OBIEE versions (12c, 11g) but those are missing in OAC documentation.

Original Idea Number: 4fc31f00db

Michal Zima

Definitelly "must have" feature. I have already raised SR by Oracle support on this (for OAS version). API should deal also with ability to upload newer version of external data set (CVS/Excel), perform data refresh on data set etc....
There is quite rich API (Web Services) for "traditional" OBIEE world (/analytics), but for DV simply nothing. Very, very limiting factor of DV usage.
Kind regards
Michal Zima

M_Kumaran

Must have .

Marcelo Finkielsztein

agreed. Must have it.

Enh 31248426 - OAC-OM NEEDS JOB MANAGER SIMILAR TOOL TO MANAGE AGENTS IN OAC SOURCING ONPREM ORACLE DATABASE

Jeff Jordan

data flow monitoring and qa

vkm

Very helpful feature to enable connection to modern data stores.

Dor Sela-243295

This is a must have for org schedule!
cannot be used otherwise

Grayson Stebbins

We are currently blocked on our OAC integration for our BI Portal (Metric Insights), our wishlist for API's are as follows:

(All requests apply to the "new" Data Visualization catalog.)

• P1: Structured list of objects as ID and name; object IDs should exactly match what would appear in the URL for embedding
• P2: Additional metadata about objects:
  • Description
  • Last refresh time
  • Etc -- put simply: return a big JSON blob with all the available metadata for that DV

• P2: List of Filters and their individual values
• P3: Filtered images of dashboards (pass in an object ID and set of filter/value pairs, return a PNG image)

  Update: There are quite a few varied requests in this thread, so I've separated out our specific asks into a new one that can be voted/commented on separately: https://community.oracle.com/customerconnect/discussion/617638/oac-catalog-apis-for-data-visualizations/

SiddharthDang-Oracle

Indeed a must-have feature. We have multiple OAC instances. Managing OAC resources like backup and migration is a challenge for us. Having rest calls would be a great enhancement to OAC management.

Regards,

Siddharth Dang

Marcelo Finkielsztein

Maybe this was part of what @Grayson Stebbins mentioned:

"XREF dependencies": Ability to query what workbooks or analyses or data-flows use a given dataset, or somehow export a full list of dependencies: including all objects, including workbooks, analyses, data-flows, datasets, connections, etc.

Marcelo Finkielsztein

Grayson Stebbins

This has been marked as delivered. Any specific details on exactly what was implemented? Is everything listed here? https://docs.oracle.com/en/cloud/paas/api-platform-cloud/apfra/rest-endpoints.html

We are specifically interested in https://community.oracle.com/customerconnect/discussion/617638/oac-catalog-apis-for-data-visualizations/p1?new=1 which doesn't look like it's been covered at all.