on 07-21-2014 7:28 AM
Dear Experts,
1. What is the best way to swap connections with in an environment?
For example, in DEV environment I want to use another environment like integrated environment's DB?
I have to change all the table owners manually and if I have derived tables and custom LOVs, it's a significant maintenance and error prone.
2. If I migrate the universe to a UAT or PROD environment often I encounter, the connection can not be registered error
Please advise
We ran into this limitation and it made us abandon any plans of using multisource universes in the short term. As far as we were able to determine, the only way to change the owner on objects in a multisource universe is manually, table by table, even when the owner is set by default on the database connection.
I added an Idea on Idea Place and hope that some day this will be changed and made easier: Multisource Universes: Reference tables without explicit database qualifier : View Idea
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
If you have three DB servers (Dev,Test,Prod ) and three bo servers (Dev,Test,Prod ) you need to create three different connections in Dev.
IN THE DEV SERVER
Then while promoting to Test environment, you need to send universe along with connection, but in the connection you need to change the Dev DB connection to Test DB connection ((Test Connection) (Select the connection -> Click on change connection)
Then while promoting to Prod environment, you need to send universe along with connection, but in the connection you need to change to Prod DB connection (Prod Connection)
And once the universe and connection are promoted successfully come back to Dev and change the connection to Dev DB (Dev Connection)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Sreenivasulu.
This is about multi-source only..right? Single Source IDT and UDT Universes never have this kind of problems.
Also in DEV evironment, the policy is set such that UAT and PROD connections are not accessible to BO Server. Either ways, i.e, when using Oracle Client or ODBC connections, the DB server can not communicate with BO Server, with lower environments, but the opposite is true.
But I can try for DEV and Test Environments and let you know how it goes.
Error
Resolution Status=Copied, Dependency Status=All the required dependencies are
included., Commit Status=Commit attempted and failed., Promotion Status=Failure
: Object Promoted. Update Failed. Error :
com.businessobjects.mds.publishing.exception.PublishingException: Multi source
connection can not be registered: Connection name
Thanks
-Peter
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.