Categories
- All Categories
- 135 Oracle Analytics News
- 24 Oracle Analytics Videos
- 14.6K Oracle Analytics Forums
- 5.6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 51 Oracle Analytics Trainings
- 9 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 3 Oracle Analytics Industry
- Find Partners
- For Partners
Reg: RPD migration using patching
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
Answers
-
Hi,
Yes you can migrate RPD changes from one environment to another using Patching.
https://docs.oracle.com/cd/E14571_01/bi.1111/e10540/mngreposfiles.htm#BIEMG950
Please Note: Keep appropriate RPD backup on both the environment before generating patch and applying the same on other environment RPD.
Do you want to deploy Patched RPD without using EM?
Then the answer is NO ,even though there is an approach for same but its complicated(it involves stopping OBIS1 services,renaming current RPD and replacing current RPD with current RPD name, starting OBIS1 services) and its not standard way of deploy RPD.
Thanks and Regards,
Syed Hamd Salman
0 -
Hi Syed,
Thanks for your reply.
Please find the below steps which we have done.
1. We have Master RPD in DEV envr copied the same in PROD envr as well.
2. For DEV RPD we did the changes and compared with PROD RPD and generated the Patch.xml file.
3. To apply the patch, opened the PROD RPD merged the patch file after patching 2 RPD's generated automatically (Master_original_extract, Master_patched_current_extract) .
But changes was not merged in both of these RPD's and showing the same Master RPD. Can anyone suggest on this.
Thanks in Advance,
0 -
https://bicoach.wordpress.com/2014/09/05/working-through-rpd-patch-files/
CAUTION: doing the above results in having your connection info (user/pwd) in plain text in your patch file ... some places this is a no-no.
0 -
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
\OBIEE11119\RPDPatching\DEVRPDV2.rpd -W Sadmin123 -G \OBIEE11119\RPDPatching\DEVRPD.rpd -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\OBIEE11119\RPDPatching\SITRPD.rpd -Q Sadmin123 -G \OBIEE11119\RPDPatching\DEVRPD.rpd -S Sadmin123 -I \OBIEE11119\RPDPatching\Release.xml -O \OBIEE11119\RPDPatching\Final.rpd -V \OBIEE11119\RPDPatching\Outputfile1.csv0 -
Hi Syed \ Thomas,
Thanks for your reply .
Issue got resolved able to merge the changes into Master RPD.
Thanks,
0 -
Please mark the question answered ... helps those with similar issues find working solutions.
0