Automatic connection pool parameters update

Question

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.

rmoff · Answer

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.

cesar.advincula.o · Answer

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