variabilize DSN in connection pool

user12863665

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.

Joel

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

SonPat99

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

Hope this helps.