variabilize DSN in connection pool
i am using 12_3 version of obiee. i would like to variabilize DSN info in connection pool. basically i don't want to change any connection details as part of migrations.everything should be in variables. can you please suggest me how can i variabilize DSN in connection pool.
Answers
-
You’ll need to use the datamodel.sh/cmd script located in your DOMAIN_HOME/bitools/bin directory.
First step is to use the listconnectionpools parameter to generate a json file which lists your connection pools.2nd step is to migrate your updated repository to this environment and finally to use the updateconnectiopools parameter of the data model.sh/cmd script to update the connection pools.
The same process can be used to update repository variables.
0 -
You can define Initialization Blocks (IB), use static Variables fro Connection Pools and then use these variables directly in RPD.
Hope this helps.
0