Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Automatic connection pool parameters update
Hi,
I need to find best approach to apply changes of Oracle BI repository from test server to production server.
Is there a possibility to change connection pool schema parameters automatically:
1) Datasource name
2) DB schema
3) Password
while uploading repository in EM (Test ==> Prod)?
Now I have to type it manually after another patch installation.
Another approach is to COPY and PAST single Subject Area layers and retype passwords manually only for this Subject Area.
Please, help.
Answers
-
Hello,
Yes, it exists, use a you could use a initialization block with the variables that you need, however, there is a restriction you cant use variable in the "password" field.
Check this link for more detail:
OBIEE - Connection Pool [Gerardnico]
Do the same with the username.
Kind Regards
0 -
I need to find best approach to apply changes of Oracle BI repository from test server to production server.
Create a set of RPD XML patch files, one for each of your environments. As part of your deployment process, apply the patch automatically with patchrpd, and then deploy the resulting RPD - optionally directly with WLST - no need to touch EM at all.
Another approach is to COPY and PAST single Subject Area layers and retype passwords manually only for this Subject Area.Please don't do this. It's prone to error, takes ages to do ... and is completely unnecessary.
0