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

Generate a password file from a repository

java -jar BIServerT2PProvisioner.jar -generate <repository file> -output <password file>

where:

• generate - The repository to look at to get all the connection pool names
• output - The output template input password file containing the connection pool names from the repository

Example:

# Set the server bin into the PATH environment variable to be able to call it directly
export OBIS_PROVISIONER_PATH=$FMW_HOME/Oracle_BI1/bifoundation/server/bin/BIServerT2PProvisioner.jar
java -jar $OBIS_PROVISIONER_PATH -generate prod.rpd -output output_pwd_file.txt

Enter the repository password: admin
INFO: Step 1: Running nqudmlgen to generate UDML for prod.rpd. This may take a while.
INFO: Step 2: Extracting connection pools from extracted UDML file and creating output_pwd_file.txt...
INFO: Step 3: Clean up temporary files...

• The generated password file has the form of list of key pair value (ini file) where the left side is the qualified name of a connection pool and the right side the password

; comments
"Database"."ConnectionPool" = <Change Password>
"Database1"."ConnectionPool1" = <Change Password>
"SQLDB_UsageTracking"."Connection Pool" = Admin123
"SQLDB_Northwind"."Db Authentication Pool" = Oracle Administrator

Update a repository with the password file

echo repo_password | java -jar BIServerT2PProvisioner.jar \
                -passwords <passwords file> \
                -input <repository file> \
                -output <repository file>

where:

• repo_password is the password of the repository
• passwords - An property file specifying the connection pools and the desired password for each password.
• input - The repository to be modified.
• output - The output repository containing the updated passwords.

Example:

 echo repo_pwd | java -jar BIServerT2PProvisioner.jar -passwords password_file.ini -input source.rpd -output source_with_pwd.rpd

Enter the repository password: 
INFO: Step 1: Loading all passwords from password_file.ini...
INFO: Step 2: Running nqudmlgen to generate UDML for source.rpd. This may take a while.
INFO: Step 3: Extracting connection pools from extracted UDML file...
INFO: Step 4: Encrypting passwords in connection pools...
INFO: Step 5: Executing new UDML to generate modified repository...
INFO: Successfully replaced 13 password(s) in source.rpd and output to source_with_pwd.rpd.
INFO: Step 6: Clean up temporary files...

IMPORTANT NOTE: Make sure to remember to delete or encrypt the file password_file.txt because it contains clear-text passwords