Can any body advise me how to change the universe connection.
Here is the discription: We have 3 environments to say DEV,TEST and PROD, we have 3 connections like XXX-P(prod), XXX-D(dev) and XXX-T(test) and we have couple of universes in all the environments. ctually prod uiniverses should be pointed to XXX-P connection, Development Universes should be pointing to XXX-D(Dev) and test universes should be pointing to XXX-T but, all the universes in all the three environments pointing to XXX-P only. So i need to change connections of dev environment to XXX-D and test environment to XXX-T can any one help
me out with this. we are using BO XI R 3.1.
In Universe Designer go to File -> Parameters, here you will find Connection dropdown from where you can select relevant connection.
After selecting required connection save the universe and export it.
Thanks Amit for your response but, according to this process i need to change the connection for each universe and it tedious process since there are abount 30 universes in Both the environments. Is there any other way were we can update all connections of all the universes at a time? pls reply
Oh no, not tedious. Not everything’s interesting in BO.
You’ll have it done by the time you wait for an answer on here to confirm that it’s easier to do it by hand.
We have a connection that points to the development database in our Bob development environment. When the universe is migrated to production with the wizard, the connection magically changes to point to the live database.
No idea how our techies did it, but it’s very clever…
To be honest, if your test, qa and prod databases are in line, then changing the connection is soooo easy. That obviously relies on good control standards though.
When you first create the connection in DEV pointing to the DEV server you can have it promoted up to TEST same as your Universe. Once Promoted it can be edited to point at the TEST server. Since the connection rarely needs to be changed it is then fine for all later promotions of the Universe. Thus unless you change the actual table the connection is pointing at at some point you never need change the connections or the connection name in the universe after the initial push.
How about using a DSN that has the same name on all 3 environments and pointing the DSN to dev/test/prod within each environment. We use this mechanism across all of our universes and environments without ever needing to change the connection parameter across environments.
(BOB member since 2009-02-18)
(BOB member since 2005-03-01)
(BOB member since 2007-06-25)
(BOB member since 2009-09-25)
(BOB member since 2002-06-20)