Tuesday, February 5, 2013

Creating a UDML file for OBIEE 11g RPD

The ability to use UDML for scripted OBIEE RPD changes has been around since OBIEE 10g. UDML files are very useful in order to do migrations, as they can contain the connection pool information and any variables which are environment specific. I am currently using UDML within our enivonrments to allow for migration of an RPD from Development through to Produciton.

Take a jump to view the steps to create UDML files for your environments, along with a sample UDML file.


If you are on Linux/Solaris then source the bi-init which sets up the environment variables for OBIEE commands

. {OBIEE11GInstance}/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.sh

Run the nqUDMLgen command located in the Oracle_BI1 folder:

{OBIEE11GFMHome}/Oracle_BI1/bifoundation/server/bin/

The command to run, with parameters:

nqudmlgen –P <rpd Admin Password> -R <Path to RPD File>  -O <Path to Output UDML file>

This will create a large UDML file of your entire repository. You then need to fish out just the Connection Pools and Variables you care about which will change form environment to environment. Paste those components into a new file, and call it <ENVIRONMENT>.udml

Note: You can change most things from the UDML directly, like database schemas/sids, or variable values. The one thing you can is the connection pool passwords. Those you will need to first change in the RPD, generate the UDML, and then paste in. Once you have the UDML files, migrations are a snap, as you just apply the UDML file of the environment you are going to.

Here is a sample UDML file I created for a development environment which is using OBIA. Notice I only captured the Connection Pools and Variables I care about changing from environment to environment.

Click me to view DEV.UDML

1 comment:

  1. 888Casino review - Deposit Bonus, Jackpot, Banking
    888casino Review – 제주 출장마사지 Sign up at 888Casino and play 영천 출장마사지 more than 400 진주 출장마사지 games, 문경 출장안마 a superb welcome bonus, casino promotions and the best mobile 여수 출장샵 casino.

    ReplyDelete