Oracle Analytics Cloud and Server

Automate OAC catalog mgr script

Received Response
36
Views
2
Comments

Trying to come up with an automated way to move catalog artifacts from a catalog on server 1 to a catalog on server2.

  • Would need a list of the items in the shared folders from server 1 where you could pick what items you want to move
  • Then a way to copy each item from one server to the other.

Has anyone kicked this around at all? Is there something already out there that wraps around the catalog mgr or web services to do this?

Answers

  • Gianni Ceresa
    edited August 6

    You could just use the catalog manager for this, by archiving on one side, and unarchiving on the other side.

    Or you can use the webservice (which is what the catalog manager does anyway).

    Catalog manager has a fully CLI, therefore you can automate it quite easily.

    Both options require that you use an account having permissions on all the paths of the catalog you want to touch (because online work enforce security).

  • To add, the CLI can be invoked with:

    [DOMAIN_HOME]/bitools/bin/runcat.sh | .cmd -help

    Help for the actual commands in question:

    [DOMAIN_HOME]/bitools/bin/runcat.sh | .cmd -cmd archive -help

    [DOMAIN_HOME]/bitools/bin/runcat.sh | .cmd -cmd unarchive -help

    Archive/Unarchive should be used judiciously for single elements or folders, it is not intended for moving entire catalog.