13 Replies Latest reply: Jul 28, 2014 2:05 AM by Johan (South Africa) RSS

    Runcat.cmd command-line script to extract OBIEE 11g catalog to text file

    Johan (South Africa)

      Hi All

       

      I am struggling with a script to extract the OBIEE web catalog to a file and hope someone can help.

       

      The script looks like this:

       

      runcat.cmd/runcat.sh -cmd report -online http://10.101.3.113:7001/analytics/saw.dll –credentials C:\Tmp\catmancredentials.properties -outputFile C:\Tmp\Analysis_Output.txt -type "Analysis" -fields "Column" "Table"

       

      The error that I am getting is: "Unable to login to http://10.101.6.114:7001/analytics/saw.dll"

       

      In the C:\Tmp\catmancredentials.properties file specified in the above script I have specified the username and password:

       

      C:\Johan\catmancredentials.properties file contents:

      Login=admin

      Pwd=admin1428

       

      I can login with the above username and password using the http://10.101.3.113:7001/analytics/saw.dll URL in the Catalog Manager and run a report manually without any issues.

       

      Any suggestions?

       

       

      Thanks

       

      Johan