OBIEE 11.1.1.6 catalog manager for extracting webCat_dashboard_text.txt

Question

Hello,

I am trying to extract the webCat_dashboard_text.txt from Catalog manager to create the reporting lineage which is part of the ODI Data lineage in ODI 11.1.1.9. Oracle docs says to use 11.1.1.6 to create a report of the catalog, but I just can't seem to find a place to be able to download OBIEE 11.1.1.6 at this point. Does anyone know where I can get it?

Oracle e-delivery has OBIEE 11.1.1.9 but not 11.1.1.6.

Or if there is a workaround to getting that webCat_dashboard_text.txt from 12g or 11.1.1.9 OBIEE?

Thank you.

Charles M · Answer

You're welcome. Glad it is working for you!

Earlier I had tried this using OBIEE 11.1.1.7.14500 and found that it did not have the same GUI, apparently the catalog has been updated to what it is now in the update from 11.1.1.7.0 to 11.1.1.7.1.

Interesting ... good catch on that version number!

Also, one more thing about these files. When I did this I got an error during the data lineage ETL (I'll see if I can dig up the specific error message). But, basically, it was expecting different names for these files.I was using OBIA 11.1.10.1 [OBIEE 11.1.1.9.3], so this may/may not happen to you ...

Save the file as webCat_dashboard_text.txt in a local folder

I believe this needs to be named ‘WebCat_dashboard_text.txt’ (note the capital letter ‘W’)

Save the file as webCat_text.txt in a local folder.

I believe this needs to be named ‘WebCat_text.txt’ (note the capital letter ‘W’)

Regards,

Charles

User_8OQQN · Answer

Thanks a lot Charles M. It works. Earlier I had tried this using OBIEE 11.1.1.7.14500 and found that it did not have the same GUI, apparently the catalog has been updated to what it is now in the update from 11.1.1.7.0 to 11.1.1.7.1.

I will figure out how to use the runcat.sh to automate this report generation.

Thanks.

Charles M · Answer

Hi -

You should be able to use the 11.1.1.7 catalog manager. https://docs.oracle.com/cd/E63231_01/doc/BIASA/GUID-7C5492C6-CB1A-417B-B7DA-1C9FA00B38F1.htm#BIASA24677

Try this: https://edelivery.oracle.com

Then, search for 'Oracle Business Intelligence Developer Client Tool 11.1.1.7.0'

Regards,

Charles