Download reports xml using command line Catalog Manager and online mode

Szymon Grzęda

Hi,

Is it possible to download all XML reports from a specific folder using Catalog Manager in command-line and online mode?

Regards

Szymon

Sumanth V -Oracle

@Szymon Grzęda - Welocme to Oracle Analytics Community!

Below are the operations supported by Catalog Manager cmd line utility -

• Cutting objects.
• Copying objects.
• Pasting objects.
• Copying objects for another catalog.
• Pasting objects from another catalog.
• Creating shortcuts of objects.
• Deleting objects.
• Renaming objects without reference updates.
• Renaming objects with reference updates (you might be able to rename certain objects, depending on your permissions.)
• Creating folders.
• Setting permissions for objects.
• Working with properties of objects.
• Searching for objects.
• Searching for and replacing catalog text (you might be able to replace certain objects, depending on your permissions).
• Creating reports to display catalog data.
• Setting browser preference.
• Exporting captions for localization purposes.

Ref - https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/operations-available.html

Gianni Ceresa

Hi @Szymon Grzęda ,

For that task, catalog manager wouldn't be my first choice, mostly because it doesn't directly have something giving you the code defining an object (you could maybe get by generating a report, but not sure if the whole XML will be there, because the report will be a mess and lose its table-like structure).

For what you ask, look at the webservices available. There is a webservice for the catalog that has methods to navigate the catalog (list the objects) and get their source code (the XML of the object itself) and their metadata (the .atr file content).

It will work online just like your request for the catalog manager, therefore security will be enforced in the same way. The catalog manager does call these webservice methods, therefore you aren't that far from your original request.