Skip to Content
Feb 27, 2009 at 07:49 AM

Multiple BW instances on one BO system


Hello experts,

The infrastructure setup of my project is to have 2 separate BW instances (testing and training) to be connected to the same BO system.

When setting up a BOJ connection (from Universe Designer), we need to specify the Application Server (ie. IP address of the BW instance). So it seems BOJ connection is BW instance-specific. However, we don't want to create separate sets of Connections (and hence, Universes & Queries) for each BW instance.

Is there any way for one Connection (and hence, Universe & Query) to be shared across 2 BW instances?

If this is not possible, is it possible to copy the Connection (plus Universe & Query) for BW instance #1 to a another Connection for BW instance #2? This is to simplify the effort of setting up BO for the second BW instance.

Thanks in advance for any suggestions.