Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 195 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.5K Oracle Analytics Forums
- 6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 68 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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