get with Query Builder the BOBJ connection details : database type, database hostname or IP

[former_member332039]

Hi,

I need to list all connections (OLAP, relational) in our Business Objects 4.2, including the connection definition like database type, database host or IP, driver, etc. I need to detect the connections which actually is using IP for the database connection in order to modify by its respective hostname. There is a lot connections....!

If you have a sentence to be executed by the Query Builder o if you have a code in java that use de java SDK will be useful for me. 🙂

best regards,

Eusebio Martinez Galvis.

[former_member217070]

UnivInfo.bat.txt

make.bat.txt

UniverseInfo.java.txt

Hi, Eusebio,

The BI Semantic Layer (SL) SDK, along with the BI Enterprise SDK, should be able to do what you're looking for.

The Enterprise SDK will allow you to query the CMS for the lists of Connections and OLAP connections. Once you have those names, you can use the SL SDK to make the changes. (Both SDK's can be used in the same program, of course.)

There's a Connection class in the SLK SDK that has DatabaseConnection, OlapConnection, RelationalConnection, and DataFederatorConnection as subclasses. You use the CmsResourceService to load the Connection. The properties are stored as parameters, which you can change. Once you've set things the way you want, CmsResourceService.changeUniverseConnection() will save your changes to the CMS.

I've attached a sample program that opens a universe, but the system won't allow me to attach zip files. I've the code and batch files as .txt, so you'll need to rename them and compile it yourself. It tells you a lot of things about the universe including information about its connections. It only displays info about the universe's connections, not all of the connections in the CMS, but the means to access them is demonstrated. It contains the Java code and includes batch files for compiling it and running it. It needs to be run on a machine that has the BI 4.2 Client Tools installed on it (IDT, WebI Rich Client, etc.). Note that although this program requires unx universes, you're only interested in the connections, so you should be able to write your code so that it doesn't access universes at all.

You can find information about the BI Enterprise and SL SDK's here: SAP BusinessObjects BI 4.x - Developer SDK Library

It includes Developer Guides and API References. Here are Samples for the Enterprise SDK along with another sample using the SL SDK.

I can cetainly understanding wanting a programmatic way to change a large number connections. Hopefully, this sample code will help you write your own script to meet your needs.

Regards,

Bryan

[former_member332039]

Hi Bryan

very good, I will try ...!

Eusebio.