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 to Manage Catalogs

Needs Votes
171
Views
7
Comments
Nayan Mukherjee
Nayan Mukherjee Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

Description (Required):

OAC should expose a REST API to import and export catalogs.

Use Case and Business Need (Required):

Right now, there is no automated cloud-native way to perform deployments of catalogs to an instance of OAC. With a large number of environments, it becomes impossible to promote the catalog from development to staging to production in an automated, consistent manner.

Tagged:
6
Up
6 votes

Needs Votes · Last Updated

Comments

  • Michal Zima
    Michal Zima Rank 6 - Analytics Lead

    @Nayan Mukherjee Since BI catalog is "concept" used for pretty long time, coming from OAC/OAS predecessor (OBIEE), you have the possibility to use WebService API for "analytics" UI (now called "traditional" part of OAC/OAS) - see this document: https://docs.oracle.com/middleware/12213/biee/BIEIT/index.html , chapter "3.15 WebCatalogService Service" describes method for this particular service within this API. We are using it (for OAS) for automated deployment of BI catalog (folders, particular objects) between our OAS environments (Dev to Prod). This WebService API should work for OAC environment as well I guess.

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    Hello @Michal Zima ,

    Hope you are doing well.

    This is only to confirm (at least one of) the methods you mention do seem to work in OAC.

    I am using the "iBot" service/executeIBotNow method (3.4.3 on that documentation) to launch Agents when our nightly ETL process has finished refreshing our data warehouse.

    Kind regards,

    @Marcelo Finkielsztein

  • Michal Zima
    Michal Zima Rank 6 - Analytics Lead

    Hello @Marcelo Finkielsztein , good to hear from you. And thanks for confirming, that WebService API is available in OAC as well.

    Rgds

    Michal

  • Alan Lee - Oracle
    Alan Lee - Oracle Mod

    Catalog granularity in Snapshot API is also planned.

  • Michal Zima
    Michal Zima Rank 6 - Analytics Lead

    @Alan Lee - Oracle-Oracle That's fine, but usually you need to deploy just particular folder/object (Dev2Prod deployment scenario). So if "granularity" in Snapshot API will be whole catalog, it will not help that much. And the only way for automation of catalog deployment will be still pretty old WebService API (as I already pointed).

  • Alan Lee - Oracle
    Alan Lee - Oracle Mod

    @Michal Zima Granularity within a catalog is planned.

  • Gaurav Ghatole
    Gaurav Ghatole Rank 1 - Community Starter

    Hi, I am working on implementing DevOps automation for OAC catalog and snapshots.

    I can see Rest APIs available for catalog with copy catalog operation but there is no operation available with import or paste.

    Could you please help me on this?

    @Michal Zima , @Alan Lee - Oracle-Oracle any comments

    Thanks and Regards

    Gaurav