Oracle Analytics Cloud and Server Idea Lab

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

REST API for Oracle Analytics Cloud

Delivered
403
Views
12
Comments

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

16
16 votes

Delivered · Last Updated

«1

Comments

  • Michal Zima
    Michal Zima Rank 7 - Analytics Coach

    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
    M_Kumaran Rank 5 - Community Champion

    Must have .

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    agreed. Must have it.

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

  • Jeff Jordan
    Jeff Jordan Rank 3 - Community Apprentice

    data flow monitoring and qa

  • vkm
    vkm Rank 5 - Community Champion

    Very helpful feature to enable connection to modern data stores.

  • Dor Sela-243295
    Dor Sela-243295 Rank 1 - Community Starter

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

  • Grayson Stebbins
    Grayson Stebbins Rank 2 - Community Beginner

    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
  • SiddharthDang-Oracle
    SiddharthDang-Oracle Rank 5 - Community Champion

    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
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    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
    Grayson Stebbins Rank 2 - Community Beginner

    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.