API for programmatically manipulating DV objects Data Visualization and automate DV tasks in OAS
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.
Comments
-
This is a good enumeration of the key capabilities needed and that they are required for OAS.
0 -
This is a very much-needed feature. Appreciated, traction on this @Bret Grinslade - Oracle Analytics-Oracle
0 -
It is a very needed for lineage evaluation of the tool of the Data Visualization
0 -
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.
0 -
REST API's in OAS , we needed . It should be there with next update, as long time no provided.
0 -
This is a much needed feature to utilize the tool to its potential.
0 -
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.
0
