Business Intelligence – Oracle

Archive for May 2nd, 2008

Oracle BI EE – Automating Password Updates of Connection Pools and Users – Command Line Options

Posted by Venkatakrishnan J on May 2, 2008

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"

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.

Posted in All Posts, OBI EE Plus | 9 Comments »