Connection info + universes

system · December 4, 2009, 6:19pm

Author: Joe Peters (with thanks to Dwayne)
Platform: Windows
Version: 1.0
Notes:

joepeters (BOB member since 2002-08-29)

system · February 27, 2010, 3:01pm

To get this to work with XI3, I had to switch not just the 3 classes you mentioned to the “12” equivalents, but also add in the BusinessObjects Designer 12 reference.

But it works great!

dnewton (BOB member since 2004-01-30)

system · March 1, 2010, 1:20pm

Thanks, dnewton. I had tested it with the 11.5 libraries connecting to XI3, which did work successfully. But I found out recently that that will cause Fail messages for Connections that were created or modified in XI3. So, although it’ll work with the XIr2 libraries, it’s better to use the XI3 libraries if you’re connecting to XI3. (yeah, I know, “duh”).

Joe

joepeters (BOB member since 2002-08-29)

system · July 26, 2010, 9:50pm

Hello

When I click on ‘Document Connection’ button in excel I get a compile error saying ‘Cant find project or library’

Do you know if the file is broken?

Thanks
Namit

namitrs (BOB member since 2006-11-28)

system · July 27, 2010, 11:38am

Most likely, you don’t have the XIr2 client software installed.

joepeters (BOB member since 2002-08-29)

system · August 31, 2010, 2:15pm

I could really use this download. Anyone know if there is code available for changing the Universe Password? I could use this download to verify a mass update to all my universe passwords.

efrenacevedo (BOB member since 2010-08-31)

system · August 31, 2010, 2:22pm

I assume you mean Connection Password? There is a Password property of the Connection object, but I’ve never attempted to set a password with it.

Joe

joepeters (BOB member since 2002-08-29)

system · August 31, 2010, 2:49pm

Yes I meant the Connection Password? I need to change it for 50 universes and was hoping not to have to do it manually through designer…

efrenacevedo (BOB member since 2010-08-31)

system · August 31, 2010, 2:51pm

Do you have a separate connection for each universe? If so, you should be able to use my code to iterate through the connections, then add the code to change the password. But you’ll have to test it – you might have to change it in one connection first, then get the encrypted value of “Password”, which would then be used for the remaining connections.

joepeters (BOB member since 2002-08-29)

system · August 31, 2010, 3:04pm

So I have 50 different connection names but the same username and password…

Is the password always encrypted?

efrenacevedo (BOB member since 2010-08-31)

system · August 31, 2010, 4:57pm

I believe so. I’ve never used that property.

joepeters (BOB member since 2002-08-29)

system · August 31, 2010, 7:52pm

Hi,

Isn’t the password property read-only? I may be wrong though, can’t check it now.

Marek Chladny (BOB member since 2003-11-27)

system · August 31, 2010, 7:59pm

Hi all -

The password is writable – we have code that reads an application’s configuration file (db settings, credentials, server, etc)file and auto-deploys Universes by creating a connection, setting its parameters and finally exporting to the CMS…

Hope this helps

Atul Chowdhury (BOB member since 2003-07-07)

system · October 12, 2010, 11:58am

This is a very usefull sheet, thanks.

But when changing from one repository to an other some rows from the previous repositorie are still there.

So, before a you want to refresh this document a cleanup should be made.

hvandervegt (BOB member since 2003-11-17)