Oracle BI EE 10.1.3.3/2 - Automating Password Updates of Connection Pools and Users - Command Line Options

If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below.

    

This is nothing but the connection Pool property of the ORCL database. Here, we would like to change the schema names and its corresponding passwords. For example, we would like to change the schema to SH and also would like to change the password. In order to do that, open a text editor and enter the below command. Save the file in the same directory as the Admin Tool ({OracleBI}\Server\Bin). If not, then you would have to give the full path of the file.

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

Now, open up a command prompt and navigate to {OracleBI}\Server\Bin. Typein in the below command,

 admintool /command commandlineswitch.txt

    

This would automatically update the connection pool values.

    

You can use the above to update many objects within the repository. For updating passwords for users, just use the nqschangepassword.exe tool. For more details on this, check my blog entry here. So, on a high level your entire migration process would look as shown below

    

Thanks to Phil for sharing this.

---

Possibly related posts: (automatically generated)

• Oracle BI EE 10.1.3.3/2 - UDML to automate repository Updates - Migration o…
• Connection pooling
• Run As… trick to work as an admin without logging somebody off
• Update the system and the sources list