Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – 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"
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.

About these ads

9 Responses to “Oracle BI EE 10.1.3.3/2 – Automating Password Updates of Connection Pools and Users – Command Line Options”

  1. Ilya said

    Venkatakrishnan,
    This is very helpful if you have BI installed on a windows machine and thus can run admintool.exe . How would I accomplish changing the .rpd password in a similar fashion if the tool is installed on a unix server?

    • tom said

      Hi Ilya/Venkat,

      I have the same req of automating changes in rpd in linux. kindly let me know how did you achieve this.

      thanks
      tom

  2. Yogi said

    Venkatakrishnan,

    This is very interesting stuff. Do you have a cheat sheet or something that explains the various commands that are supported for this scripting language ?

    Thanks,
    Yogi

  3. vyke said

    Is there a document out there that lists all the properties that can be set through Admin command line tool?

  4. GookSoype said

    mm.. thank you )

  5. Mr said

    Hi,
    I’ve tried your solution but nothing is getting changes ? (I try only user or pwd or both)

    Any idea ?
    By the way how admintool identify the relevant connection pool with the physical connection name ?
    Does it replace as well for VALUOF(OLAP_USER)

    Thanks in advance,

    Mr.

  6. [...] Automating Password Updates of Connection Pools and Users – Command Line Options page_revision: 5, last_edited: 1245787434|%e %b %Y, %H:%M %Z (%O ago) edittags history files print site tools+ options edit sections append who watches backlinks view source parent block rename delete help | terms of service | privacy | report a bug | flag as objectionable Hosted by Wikidot.com — get your free wiki now! Unless stated otherwise Content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License Click here to edit contents of this page. Click here to toggle editing of individual sections of the page (if possible). Watch headings for an "edit" link when available. Append content without editing the whole page source. Check out how this page has evolved in the past. If you want to discuss contents of this page – this is the easiest way to do it. View and manage file attachments for this page. A few useful tools to manage this Site. See pages that link to and include this page. Change the name (also URL address, possibly the category) of the page. View wiki source for this page without editing. View/set parent page (used for creating breadcrumbs and structured layout). Notify administrators if there is objectionable content in this page. Something does not work as expected? Find out what you can do. General Wikidot.com documentation and help section. Wikidot.com Terms of Service – what you can, what you should not etc. Wikidot.com Privacy Policy. _uff = false; _uacct = "UA-68540-5"; _udn="wikidot.com"; urchinTracker(); _qoptions={ qacct:"p-edL3gsnUjJzw-" }; [...]

  7. [...] Venkat [...]

  8. [...] Venkat [...]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 158 other followers

%d bloggers like this: