Tuesday, November 02, 2010

How to export Security Group to create UDML


Here is a command to extract security objects from an OBIEE repository using the UDML command, mind the “-S” in the end, it handles to export Security part only;

C:\oracle\OBIEE\OracleBI\server\Bin\nQUDMLGen.exe -U Administrator -P xxx123 -R D:\ALL\repository\temps\yaz\050310_XXX_BAW_CS.rpd -O D:\ALL\repository\temps\yaz\tekin.udml -S

C:\OracleBI\server\bin\nqudmlgen -U Administrator -P Administrator -R C:\OracleBI\server\Sample\samplesales\samplesales.rpd -O C:\OracleBI\server\Sample\samplesales\samplesales.udml -S

nqudmlgen: This is the actual export command
-U: This is the user flag, in my case Administrator
-P: This is the password flag, in my case Administrator since I'm using sample sales
-R: Is the source repository. I am sourcing from samplesales.rpd on a Windows box
-O: Is the output file. I am populating a file called samplesales.udml in the same folder as the source
-S: Exports only security objects

Here is the command to import the objects

nqudmlexec -U Administrator -P Administrator -I C:\OracleBI\server\Sample\samplesales\samplesales.udml -B C:\OracleBI\server\Sample\samplesales\samplesales.rpd -O C:\OracleBI\server\Sample\samplesales\samplesales2.rpd

nqudmlexec : This is the actual import command
-U: This is the user flag, in my case Administrator
-P: This is the password flag, in my case Administrator since I'm using sample sales
-I: This is the input script. In this case, the input to this is the output from the first command
-B: This is the base repository. In this case, your base repository will be your target repository, the one where you want to migrate the users to.
-O: This is the output repository. This command makes a copy and applies the changes in the UDML to that copy. So you need to specify an output file. This is the file that will have the changes. The base file will not have the new users since it is just used to make this copy.
 Example;


EXPORT;
C:\oracle\OBIEE\OracleBI\server\Bin\nQUDMLGen.exe -U Administrator -P xxx-R D:\ALL\repository\temps\yaz\050310_XXX_BAW_CS.rpd -O D:\ALL\repository\temps\yaz\tekin.udml

IMPORT;
C:\oracle\OBIEE\OracleBI\server\Bin\nQUDMLexec.exe -U Administrator -P xxx -I D:\ALL\repository\temps\yaz\tekin.udml -B D:\ALL\repository\temps\yaz\050310_BAW.rpd -O D:\ALL\repository\temps\yaz\050310_BAW.rpd

0 comments: