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

[Former Member]

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!

Angelica

[denis_konovalov]

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.

[Former Member]

Thanks Denis, but in IDT/UDT I insert schema, password and service name when I create a connection. Is there a way to extract also these information from BOE repository?

[denis_konovalov]

Service name/schema maybe, doubt on user/password.
If you run select * for the connection in query builder - what do you see ?

[Joe_Peters]

You will need to use the SL SDK to get the connection details. The information is in the repository, but in an encoded property.

[Former Member]

Hi Denis&Joe, from QB I obtained all properties in attached printed images. In my opinion, as suggested from Joe, the informations are available in the repository, but in encoded mode (ex: "SI_CONNECTION_CONNECTSTRING" and
"SI_CONNECTION_PARAMSTRING"). I can't use SDK because I have no skills in its usage. I will try to ask if the new universe in 4.2 can extract this encoded informations:

https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+B...

Thank you both!

Angelica

[denis_konovalov]

the port info and service IP's will not be in there anyway. Only what you see in connection properties in IDT/UDT.
All the stuff you see in tnsnames.ora or DSN definitions is not stored in BOE repo.

[Former Member]

Yes, I agree.