variabilize DSN in connection pool

Question

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.

SonPat99 · Answer

You can define Initialization Blocks (IB), use static Variables fro Connection Pools and then use these variables directly in RPD.

Hope this helps.

Joel Acha · Answer

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.

List rpd variables

Update rpd variables