Thanks for your update! I tried but it seems that Catalog Manager Client is not available in OTBI (Oracle Fusion SaaS). I found a note confirming this analysis: Is There A Way To Export The Catalog Contents Of OTBI such as Catalog Manager? (Doc ID 2261453.1)

Hi Sreekanth! Thanks for this update! We managed to use it in BI Publisher to achieve our goal. Do you know if there is a similar way to do it in an OTBI analysis where we cannot use direct SQL request to get the hostname? Thanks Vincent