Reg: RPD migration using patching

Question

Hi Team,

Can we migrate latest RPD changes (like connection details and other columns changes) from one environment to other environment using patching? Is this kind of approach is suggested.

Also without using EM, can we deploy the same RPD we have only client installation in our machine can anyone suggest on this.

Thanks in Advance

Thomas Dodds · Answer

Please mark the question answered ... helps those with similar issues find working solutions.

Newuser1 · Answer

Hi Syed \ Thomas,

Thanks for your reply .

Issue got resolved able to merge the changes into Master RPD.

Thanks,

Syedsalmancs110 · Answer

Example:

a) Create Patch between Current DEV RPD(DEVRPDV2.rpd) with latest changes and Original DEV RPD(DEVRPD.RPD) without latest changes..

Here Original DEV RPD(DEVRPD.rpd)  should be same as current RPD in SIT(SITRPD.rpd) but with different RPD password and connection pool details in SIT environment:

comparerpd -P Sadmin123 -C D: \OBIEE11119\RPDPatching\DEVRPDV2.rpd -W Sadmin123 -G D: \OBIEE11119\RPDPatching\DEVRPD.rpd -D D: \OBIEE11119\RPDPatching\Release.xml

b) From same location on same command console use generated Patch file Release.xml in above example to generate a new Patched RPD by using patchrpd command.

Example:

patchrpd.exe -P Admin123 -C D: \OBIEE11119\RPDPatching\SITRPD.rpd -Q Sadmin123 -G D: \OBIEE11119\RPDPatching\DEVRPD.rpd -S Sadmin123 -I D: \OBIEE11119\RPDPatching\Release.xml -O D: \OBIEE11119\RPDPatching\Final.rpd -V D: \OBIEE11119\RPDPatching\Outputfile1.csv