Skip to Content

Extraction of all connections with related info (data source, host, port, service, alias)

Hi all! We need to extract all connections defined in an environment and also their connection info as: connection name, used data source, schema, db host, db port. From repository (with query builder or webi report in Sap 4.2 with new cms unlock driver) I can obtain only a list of connection name and their folder path, but nothing other. I have to explore IDT/UDT for schema and data source and tnsname.ora local file on BI server for db host, db port, db service. And then I have to match connection name, connection folder path and all other info manually.

Thanks in advance!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 30, 2017 at 03:05 PM

    Well, the chema, db host, db port info is not in BOE repository, so it can't be extracted from it.
    BOE only has what you see in create connection dialog in IDT/UDT. that's it.

    Add comment
    10|10000 characters needed characters exceeded