Export OBIEE RPD Documentation (Data Lineage) From The Command Line


9 Comments

Dor

7-Jul-2016 at 8:10 am

Very interesting.
where able to automate the OBI catalog export to CSV?
currently you have to manually export a report from catalog manager

thanks

    james.coyle

    7-Jul-2016 at 8:24 am

    I didn’t have a good time trying to get the webcat data exported. It was clunky, slow and you need to run it several times to export all types (Analysis, Prompt, Dashboard, etc). In the end I wrote a quick Java app that does all that in one go, parsing the XML directly.

AKshay

15-Feb-2017 at 8:31 am

Hi coyle, can you please tell us how to do the automation of catalog part data lineage?

    Dinesh

    10-Nov-2017 at 8:50 am

    Hi Akshay, Did you get a chance to automate the generation of Catalog CSV report.

Ed

8-Nov-2017 at 6:23 pm

runcat.sh -cmd report -excelFormat -delimiter “,” -distinct -offline BIDOMAIN/bidata/service_instances/ssi/metadata/content/catalog -forceOutputFile /home/user/all_analysis_11082017.csv -type “Analysis” -fields “Subject Area:Path:Folder:Name:Table:Column:Formula:Owner:Creator:Created”

Darius

19-Dec-2017 at 7:52 am

is it possible to perform the same using Shell script. if so can anyone pls help me out

    Dinesh

    20-Dec-2017 at 11:14 am

    HI Darius, did you find any shell script that does the same job.?

      Darius

      21-Dec-2017 at 8:01 am

      No Dinesh, I’m still on the hunt

        Dinesh

        21-Dec-2017 at 2:40 pm

        Hi Darius,

        I am in the middle of converting the above batch file into shell script. You can call me on whatsapp to discuss more: +919642801775.

        Thanks,
        Dinesh

Leave a Reply

Visit our advertisers

Search

Quick Poll

How often do you change the password for the computer(s) you use?

Visit our advertisers