Oracle Communities

Oracle Analytics and AI

Child Item

API to Manage Catalogs

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.

Find more posts tagged with

Developers

Administration

Needs Votes

Status: Needs Votes

Comments

Michal Zima

@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

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

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-Oracle

Catalog granularity in Snapshot API is also planned.

Michal Zima

@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-Oracle

@Michal Zima Granularity within a catalog is planned.

Gaurav Ghatole

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