OBIEE - Connection Pool Change (Username, password)

12G - List / Update Connection Pool Command

Example:

• list

datamodel.sh listConnectionpool -SI bi -U weblogic -P password -S server1.example.com -N 7777 -SSL -V true -O output.json

{
    "Title":"List Connection Pools",
    "Conn-Pool-Info":[
        {
            "uid":"80000001-c093-16b9-af0b-0a0a02100000",
            "connPool":"CP_Datamart",
            "parentName":"\"DB_Datamart\"",
            "user":"OBIEE",
            "password":"72567C146599BE511A0A45D8BB09981B062C0A8FE07287A12E59B9DF9BB86B02E2677169DB8500B4889C3B0D1AB1591F0351B8DE1113B6F64DD2105C0544005443CDD706F59B65D3C74D0037087C7BB4 42D761FF4996501A86AEC8C0024F093A9A265DA5F2DEF42F4882A043E6EA734D",
            "dataSource":"Datamart",
            "appServerName":"''"
        },
        {
            "uid":"c0000001-a4fa-16df-806e-0a0a020d0000",
            "connPool":"CP_Datamart_InitBlock",
            "parentName":"\"DB_Datamart\"",
            "user":"OBIEE",
            "password":"72567C146599BE511A0A45D8BB09981B062C0A8FE07287A12E59B9DF9BB86B02E2677169DB8500B4889C3B0D1AB1591F0351B8DE1113B6F64DD2105C0544005443CDD706F59B65D3C74D0037087C7BB4 42D761FF4996501A86AEC8C0024F093A9A265DA5F2DEF42F4882A043E6EA734D",
            "dataSource":"Datamart",
            "appServerName":"''"
        }
    ],
    "Variables-In-Conn-Pool":[
    ]
}

• Update Connection Pool

datamodel.sh updateConnectionpool -C connpool.json -SI bi -U weblogic -P password -S server1.example.com -N 7777 -SSL

11g - BIServerT2PProvisioner.jar

• OBIEE 11G - BIServerT2PProvisioner.jar to change connection pool password

10g

The syntax for using the nqschangepassword utility is

nqschangepassword.exe -d <data source name> -u <user name> -p <password> -n <new password> [-w <ssl passphrase> | -y]

For example,

nqschangepassword.exe -d AnalyticsWeb -u Administrator -p Administrator -n NewPassword

Admintool command

With the admintool Credits

admintool /command SetConnectionPoolProperty.txt

Open Repository.rpd Administrator Administrator
SetProperty "Connection Pool" "orcl"."Connection Pool" "User" "sh"
SetProperty "Connection Pool" "orcl"."Connection Pool" "Password" "welcome1"
Save
Exit