API for programmatically manipulating DV objects Data Visualization and automate DV tasks in OAS

Michal Zima

We are striving for more than 3 years (and unfortunately there is no change in newest release of OAS 2023 - this OAS release does not even have first features of REST API introduced during 2022 in OAC - we just learned that this REST API is "bounded" to cloud deployment, thus will not be available in OAS) with inability to programmatically "manipulate" DV objects  and automate repetitive DV task (connected with DevOps operations and governance).

Particularly we are missing in OAS following API :

1) Manipulation of data sets

• Modification/Creation of data set
• Change connection objects for tables in data set
• Change data set ownership
• Upload/Refresh file based data sets
• Refresh cached data sets (based on DB connection)
• Possibility to purge BI Server cache, connected with particular data set
• Getting data set definitions (get different properties of data sets)
• Setting/Getting ACL for data set

2)Manipulation of DV workbooks

• Listing DV projects and their key properties (for example data sets used by DV workbook)
• Ability to change key properties

3) Data Flows

• Ability to run/monitor data flows
• Ability to monitor/change jobs for data flows

4) System Settings 

• programmatically change system setting (showing up in System Settings in DV console )

It can seem, that this Idea is duplicate to existing ones (for example this one: https://community.oracle.com/products/oracleanalytics/discussion/9976/api-for-data-visualization-in-oracle-analytics-server-oac), but it is not - I again stress, that this functionality is required for Oracle Analytics Server (on-premise version of Oracle Analytics platform).

I hope, that this Idea will get Product Management attention.

Bret Grinslade - Oracle Analytics-Oracle

This is a good enumeration of the key capabilities needed and that they are required for OAS.

BalaGuddeti-Oracle

This is a very much-needed feature. Appreciated, traction on this @Bret Grinslade - Oracle Analytics-Oracle

User_5UKHM

It is a very needed for lineage evaluation of the tool of the Data Visualization

User_EG9E1

We definitely need the API's to query the catalog objects from OAS DV for showing the metadata for DV objects alongside the classic OBIEE objects in our combined metadata catalog platforms.

BrijeshAnalytics

REST API's in OAS , we needed . It should be there with next update, as long time no provided.

User_120W9

This is a much needed feature to utilize the tool to its potential.

Greg Faris

Agree this would be helpful.

Also, it would be good to add the ability to launch DV emails (with the new email features that are being released to allow DV to send email reports) via an API similar to how we can launch Classic Delivers Agents. This is important to be able to send automated reports when daily processing completes versus doing it on a schedule when completion times can vary from day to day.

Mike Durran-Oracle

I've modified the status to planned as the majority of the endpoints listed here are planned, with the exception of the data set management requests (at the time of updating).

Bhaskar Konar

It'll be a very helpful feature to have. Upvoted.

Thank you very much @Mike Durran-Oracle for the update & the consideration.