Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Delivered
341
Views
18
Comments
2»

Comments

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    @Mike Durran-Oracle Hi Mike, thanks for delivering REST API as part of OAS 2025, we certainly appreciate that (and after performing upgrade to OAS 2025 we will start to test it and use it). I hope, that REST API is still evolving and other remaining functionality (data set manipulation for example) will come.

  • Brandon Vorbeck-Oracle
    Brandon Vorbeck-Oracle Rank 1 - Community Starter

    This is good news…I appreciate all the work that's going into this. I'm trying to understand if some of the functionality I was looking for was delivered / associated to this idea…

    Specifically which endpoint would we leverage for the below?

    2)Manipulation of DV workbooks

    • Listing DV projects and their key properties (for example data sets used by DV workbook)
  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    @Brandon Vorbeck-Oracle Manipulation of DV workbooks should be definitely next on the list for future extension- @Mike Durran-Oracle - is it on the roadmap ?

  • Mike Durran-Oracle
    Mike Durran-Oracle Mod

    This has recently been added to OAC (get the JSON for a workbook) but it's not in OAS 2025 I'm afraid.

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    And changing workbooks via API is also planned ?

  • Mike Durran-Oracle
    Mike Durran-Oracle Mod

    What would you like to do via API Michal?

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    @Mike Durran-Oracle Mike, what would be good for workbook manipulation/settings (or other functionality)via API is following:

    • Setting name and description of workbook (this should be more belonging to API for Catalog, but it is not there)
    • Setting JSON definition of workbook (after changing it programmatically - for example changing reference to data set - replacing it by another data set "Id" - this would help us in Dev2Prod migration since there are big "gaps" in this process )
    • Getting list of data sets/subject areas used by workbook (but this can be done by parsing JSON definition of workbook - but getting it as API call would be more comfortable)

    For data sets it would be good to do following via API:

    • Setting name and description of data set (aka workbook)
    • Changing Connection of table/tables of data set
    • Setting/getting ACL for data set

    Michal

  • Mike Durran-Oracle
    Mike Durran-Oracle Mod

    Thanks for clarifying Michal.

    Regards

    Mike