Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Catalog Manager Query - OAC Report List - Login through Security Portal

Accepted answer
31
Views
3
Comments
JPorisVU
JPorisVU Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

We need a full list of Catalog contents from our OAC environment. All the documentation I've found states this needs to be done through the Catalog Manager CLI. I believe I have the query correct, however there's a hiccup with the credentials.

Our OAC login is via our company's security portal, not direct login. Therefore, attempting to query with my credentials doesn't work and locks my account.

How can I get this report with the login having to go through the extra step? If it can't be done, does anyone know a different way to pull this report (including BI Publisher items on the list)?

The query I'm working with: runcat.cmd -cmd report -online "https://OURCONNECTION/analytics-ws/saw.dll" -credentials "C:\myaccount\Desktop\mycredentials.txt" -outputFile "C:\my account\Desktop\Object.xls" -excelFormat -folder "/shared" -type "All" -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

Tagged:

Best Answer

  • Chere-Oracle
    Chere-Oracle Rank 5 - Community Champion
    Answer ✓

    Hello JPorisVU,

    Are you able to run and download snapshots? If so, I recommend following these steps:

    1. Run a Custom snapshot with all optional content deselected
    2. Download the snapshot
    3. Open the snapshot's local download in 7-Zip or other archive extractor
    4. Open the content folder
    5. Select the catalog folder and choose the Extract command
    6. Choose where to place the extracted "catalog" folder in your local directory.

    Use the resulting "catalog" directory folder in your command line with the -offline switch, instead of the -online switch. For example:

    runcat.cmd/runcat.sh -cmd report -type "Action" -offline "C:\my account\Documents\catalog" -outputFile "C:\my account\Desktop\Object.xls" -excelFormat -folder "/shared" -type "All" -fields "Path:Name:Signature:Content State:Owner:Creator:Created:ACL"

Answers