The Catalog Manager tool is part of the few client tools available since the first OBIEE days. It has 2 possible modes, online and offline. With the tool we can do things beyond the scope of the web based Catalog Manager. When working with OAC we have no physical access to the server and can only work with the online mode.
We can use the catalog manger in both GUI mode and command line mode.
To connect in GUI mode, select Online and copy the server name + /analytics-ws, like this
if you forget the analytics-ws suffix, the tool will remind you:
Now you can do lots of action, including fun staff like opening 2 catalog manager windows and doing copy paste from one to the other.
In non GUI modem we would usually like to use it to create archives of the catalog (in a script?). To see full details please refer to Oracle Support note OAC: How To Use The Catalog Manager Command Line To Archive A Catalog Object In Online Mode In An Oracle Analytics Cloud Instance (Doc ID 2599867.1) (thank You Tovit for referring me to it).
The short version is:
runcat.cmd -cmd archive -online "https://servername.analytics.ocp.oraclecloud.com/analytics-ws/saw.dll" -credentials "C:/output/credentials_file.txt" -folder "/shared" -forceOutputFile "C:/output/archive_file"
When the credentials_file.txt is in the format:
login=<usermane>
pwd=<password>
For additional options, the documentation or online help (runcat.cmd -help) should assist.
To see additional capabilities of Catalog Manager for OAC, see the ateam blog Using Catalog Manager with Oracle Analytics Cloud
No comments:
Post a Comment