Kumar Kambam’s OBIEE Blog

Intelligence on Oracle Business Intelligence

Simplifying Migration Process – Changing Environment Specific Variables in RPD


When it comes to migrating repository file between environments (Dev – TEST-Prod), one of the common questions from OBIEE environment administrators is if there is a way to change the connection information without having to change them manually in all the places.

Creating repository variables for DSN and DSN Username solves the issue to an extent. However, imagine having to deal with changing multiple DSNs and their respective usernames. Moreover, there is the setting password to the DSN username. One way to automate the setting of the variables is to store the values in a file and set them via admin tool command line mode.

First, define repository variables that can be used in the connection pool.



Reference the DSN information in the connection pool.


Now create a control file SetVariables.txt with the environment specific values.


‘To Open rpd – Open <rpdname> <Administrator User> <administrator password>

Open YourRpd.rpd    Administrator     SADMIN

‘Setting OLAP DSN variable

SetProperty    “Variable”    “OLAP_DSN”    Initializer    ” ‘QA_DSN’ ”

‘ Setting OLAP DSN Username variable

SetProperty    “Variable”    “OLAP_DSN_USER”    Initializer    ” ‘QA_User’ ”

‘Setting OLAP DSN User QA database password

SetProperty “Connection Pool” “AppDW”.”Connection Pool” “Password” “QAPassword”







Create one per environment.

In the command line run the following command:

AdminTool.exe /command SetVariables_QA.txt


And the repository is now prepped for the other environment (QA in this case).






August 4, 2009 - Posted by | Uncategorized | , ,


  1. Hi Kumar,

    very concise overview about the utilities available to speed up the migration process. Thank You


    Comment by @lex | August 5, 2009

  2. Nice one!


    Comment by Gareth Roberts | August 10, 2009

  3. Good One Kumar.

    How will this work in a Unix enviornment?

    Dinesh V

    Comment by Dinesh Veera | February 8, 2010

  4. Good One Kumar…

    How will this work in a Unix enviornment?

    Dinesh V

    Comment by Dinesh Veera | February 8, 2010

  5. Hi Kumar,
    great work, i really impressed with concise and useful information.


    Comment by Dhirendra | March 1, 2010

  6. Dinesh, the Admin tool cannot be opened on Unix. You need to do this in Windows.

    Comment by Kumar Kambam | March 4, 2010

  7. Kumar,I followed the steps you mentioned but it is not changing the variable value.It is opening the rpd and closing but variables are not getting changed.Please help.

    Comment by sreekanth | March 4, 2010

  8. Yes it should open, change, and close. All these actions happen very quickly. Make sure that the variable names, etc in the file match the names in the rpd

    Comment by Kumar Kambam | March 5, 2010

  9. Very useful info Kumar. Thx for sharing this.

    Sarat Nallapati

    Comment by Sarat Nallapati | August 27, 2010

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 )

Connecting to %s

%d bloggers like this: