Skip to Content
0

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

May 30, 2017 at 02:46 PM

109

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Denis Konovalov
May 30, 2017 at 03:05 PM
0

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.

Show 6 Share
10 |10000 characters needed characters left characters exceeded

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?

0

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

0

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

0

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+BI+4.2+SP3

Thank you both!

Angelica

properties1.jpg (30.4 kB)
properties2.jpg (32.4 kB)
0

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.

0

Yes, I agree.

0