OBIEE Connection Pool

Selva Pandiyan

Hi Experts,

how to automate the connection pool password when we move from lower environment to higherr environment.

Thanks

Selva

[Deleted User]

@Selva Pandiyan

1.)

2.) So obvious first question: What version?

3.) If it's 12c, then the documentation contains all you need: JSON and datamodel commands:

Setting Up Database Objects and Connection Pools

Selva Pandiyan

Hi Christian

Our current Prod version is Oracle Business Intelligence 11.1.1.9.0.

We have around 20 country implmentation.

we have a separate data warehouse for each country and however we have only one OBIEE Instances.

Moving the RPD from Lower environment to higher environment is tedious task as we have manually change the connection descriptions and its password.

Kindly help on how to automate the process of changing connection descriptions and its password.

Is there any possibility of Parameterization?

Thanks in Advance

Selva

[Deleted User]

MOS Doc ID 1574480.1

Or much better explained: https://rnm1978.wordpress.com/2009/09/09/syntax-for-admintool-exe-command-line-script/