Monday, May 30, 2011

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”

Save
Close
Exit
______________

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).




3 comments:

  1. It looked fascinating and I chose to investigate each substance and I read yours. My compliment about this blog is exceptionally positive I visit this blog first time and inspire by this good stuff work.

    ReplyDelete
  2. we have almost all country students as our subscribers for online course.We have 10+ years of experience we can serve various ascent people. oracle fusion Cloud HCM online training at erptree.com is worlds best online training center. we have excelent knowledge sharing Platform we have user friendly website where you
    will be provided with all the required details and Self-paced DEMO videos. we have our branches in pune, gurgaon, noida, india, usa, uk, uae, oracle fusion hcm training, fusion Procurement training, fusion hcm, scm training

    from

    Oracle Fusion HCM Online Training

    ReplyDelete