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.