Thursday, March 18, 2021

Oracle Analytics Server (OAS) 5.9 is available

Oracle Analytics Server (OAS) 5.9 is available here for both Windows and Linux. DON'T download the Oracle WebLogic Server 14c (14.1.1.0)  that is the default for Weblogic. this is better link for Weblogic that includes the desired 12.2.1.4 here.

If not sure about Weblogic server, it might be easier to download from edelivery here and search "Oracle Analytics Server 5.9". Edelivery on the other hand does not include links to required patches, JDK and Client.

See the list of new features here and post here.

See the documentation here.

The installation guide is here.

The migration/upgrade guide is here.

And thanks to Christian Berg for being always alert.


Sunday, March 14, 2021

OAC and Catalog Manager Tool in Online mode with and without GUI

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