Friday, January 22, 2010

Oracle BI - RPD Change Java Tool

Hello World!

This is my first JAVA tool for Oracle BI, so "Hello World!" :)

I had to change RPD very frequently in NQSConfig.INI and restart services. This tool helps people working on OBIEE on Windows system and looking for a shortcut to change RPD and restart services on just one click or one line of command.


System Requirements:

  • Microsoft Windows 98 / XP / Vista
  • JRE 1.6 or above
  • Oracle BI EE 10g


How to use?

Type java –jar ChangeRPD.jar <RPDFileName> [Restart OBI Server [Restart OBI Presentation Server [NQSConfig File]]]

RPDFilename: Name of RPD file including ".rpd" extension. Parameter is required.

Restart OBI Server: Y restarts Oracle BI Server. Default is not to restart the server. Parameter is optional.

Restart OBI Presentation Server: Y restarts Oracle BI Server. Default is not to restart the server. Parameter is optional.

NQSConfig File: NQSConfig File is path to NQSConfig.INI including filename. Default is C:\OracleBI\server\Config\NQSConfig.INI. Parameter is optional.

Type java –jar ChangeRPD.jar help gives usage direction.

Download    Source


This is how I use it. I have created a .bat file


########### CR.BAT ###########

java –jar ChangeRPD.jar %1 %2 %3 %4

##############################


Then, I copied CR.BAT and ChangeRPD.jar to C:\WINDOWS.



Example:

To change RPD, I type CR samplesales.rpd Y

That changes Star    =    samplesales.rpd into the config file and restarts Oracle BI Server.



This is free to use, modify, distribute. You can do enhancements over it, if you like. Share your views about it.

No comments: