Is there a way using WEB API to archive catalog?

DongxiYU

Hi,

     There is a way using bi-lcm(web-app) API to download RPD and do some other operations.

     Then, I'm curious to know if there is a way using web-app API to archive catalog.

Any reply is appreciated.

Joel

Not sure of a web API but you can use the runcat.cmd/runcat.sh catalog manager command line utility to do this.

Check section 16.4.1:

https://docs.oracle.com/middleware/1221/biee/BIESG/prescatadmin.htm#BIESG2905

DongxiYU

Thanks for you reply. The runcat.cmd is used to start the user interface for Catalog Manager. Actually, I want to write a script that can automatically archive catalog daily.

Joel

the runcat.cmd/sh does open the catalog manager but it can also be opened on the command line

try:

./runcat.sh -help

runcat.cmd -help

Gianni Ceresa

Do not stop at the basic usage of that command (and Joel is 100% right)

Of course no "double click" execution, you need to run the command by command line to not get it opening the GUI and start having fun in your script (runcat.cmd/.sh is quite powerful ! )

Venkata Rachuri

why not create a simple shell script and run it using cron job whenever you want

#!/bin/bash

# Author :Venkata Rachuri

#DATE  05/24/2017

# This will backup the catalog with date and time stamp

DATE=$(date +"%Y%m%d%H%M")

tar -zcf "/OracleBackup/QA/$(date '+%d_%m_%y_%H_%M')_QACAT.tar.gz"  "/Mycatalogpath/obiee/bidata/service_instances/ssi/metadata/content/catalog"

# END

Thanks

Venkat

DongxiYU

Yes, runcat.cmd can used in CMD. But it does not has an option to open a specified catalog.

With UI, I can open catalog such as "HOST:PORT/analytics/saw.dll". Is there any other offical doc?

Thank you very much.

Gianni Ceresa

DongxiYU wrote:Yes, runcat.cmd can used in CMD. But it does not has an option to open a specified catalog.With UI, I can open catalog such as "HOST:PORT/analytics/saw.dll". Is there any other offical doc?

You didn't really run the command, did you?

C:\Oracle\Middleware_OBI12c\Oracle_Home_12.2.1.3.0\bi\bitools\bin>runcat.cmd -cmd archive -help...# Command : -cmd archive -helparchive                 Creates an archive of a subset of the catalogDescriptionCreates an archive of a subset (folders and/or individual objects) of the web catalogFor more information, please see the Oracle Business Intelligence SuiteEnterprise Edition's Presentation Services Administration Guide.Syntaxruncat.cmd/runcat.sh -cmd archive -folder <path{:path}> -folderFromFile <path of inclusion list file> -skipFolder <path{:path}> -skipFolderFromFile <path of exclusion list file> [-noTimestamps] [-noPermissions] [-dontRecurse]        -[force]outputFile <output file>        ( (-offline <path of catalog>) | (-online <OBIPS url> -credentials <credentials properties file>) )Basic Arguments-[force]outputFile <output file>        Path of the report fileOptional Arguments-noTimestamps                   Don't include timestamp information in archive-noPermissions                  Don't include permission information in archive-dontRecurse                    Just archive the immediate contents of the given folders, not the entire subtrees-folder <path{:path}>           Which folders in the catalog to archive-folderFromFile <path of inclusionlist file>            File containing the folders in the catalog to archive-skipFolder <path{:path}>       Which folders in the catalog to skip archive-skipFolderFromFile <path of exclusionlist file>        File containing the folders in the catalog to skip archiveCommon Arguments-offline <path of catalog>-online <OBIPS url>-credentials <credentials properties file>      ----- Sample Credential File ------                                                @ login=weblogic                                                @ pwd=weblogic1                                                -------------------------------------folderFromFile <folder from file>              ----- Sample Folder From File ------                                                /shared/groups/misc                                                /shared/groups/_filters                                                ------------------------------------Exampleruncat.cmd/runcat.sh -cmd archive -offline c:\oraclebi\data\web\catalog\paint -outputFile c:\temp\shared.catalog -folder /shared -skipFolder /shared/Groups:/shared/Misc"Return status from Catalogmanager command : 0"

What do you think the "-online" parameter is for?

Everything is written there, the "help" of runcat.cmd command.

In the syntax you have the sample for both offline or online usage, when online an example of the file with the credentials is provided. Everything is written there ...

DongxiYU

I misunderstood its usage. Thanks you!