Here is steps on how to download and upload RPD in OBIEE 12c
Upload RPD:
**********************************************************************
Step1:
Go to the following path
/obiee/Oracle/Middleware/Oracle_Home/user_projects/domains/biee/bitools/bin
[root@obiee bin]$ cd <$DOMAIN_HOME>/bi/bitools/bin
Step2:
Enter the following commands in shell to upload the RPD:
Go to the following path
/obiee/Oracle/Middleware/Oracle_Home/user_projects/domains/biee/bitools/bin
[root@obiee bin]$ cd <$DOMAIN_HOME>/bi/bitools/bin
Step2:
Enter the following commands in shell to upload the RPD:
Syntax:
./datamodel.sh uploadrpd -I /home/bose/Sample.rpd -W RPDPasword -SI ssi -U weblogic -P WeblogicPassword
Example:
[bose@oracle bin]$ ./datamodel.sh uploadrpd -I /home/pcs_user/Sample.rpd -SI ssi -U weblogic -P Admin123 -W Admin123
./datamodel.sh uploadrpd -I /home/bose/Sample.rpd -W RPDPasword -SI ssi -U weblogic -P WeblogicPassword
Example:
[bose@oracle bin]$ ./datamodel.sh uploadrpd -I /home/pcs_user/Sample.rpd -SI ssi -U weblogic -P Admin123 -W Admin123
Service Instance: ssi
Operation successful.
RPD upload completed successfully.
Operation successful.
RPD upload completed successfully.
Download RPD:
*****************************************************
Example:
[bose@oracle bin]$ ./datamodel.sh downloadrpd -O /home/bose/Sample.rpd -SI ssi -U weblogic -P Admin123 -W Admin123
Operation successful.
RPD download completed successfully.
Step1:
Go to the following path
cd $ORACLE_BI_DOMAIN_HOME/bi/bitools/bin
[root@obiee bin]$ cd $DOMAIN_HOME/bi/bitools/bin
Step2:
Enter the following commands in shell to download the RPD
Go to the following path
cd $ORACLE_BI_DOMAIN_HOME/bi/bitools/bin
[root@obiee bin]$ cd $DOMAIN_HOME/bi/bitools/bin
Step2:
Enter the following commands in shell to download the RPD
Syntax:
./datamodel.sh downloadrpd -O /home/bose/Sample1.rpd -W RPDPassword -SI ssi -U weblogic -P WeblogicPassword
./datamodel.sh downloadrpd -O /home/bose/Sample1.rpd -W RPDPassword -SI ssi -U weblogic -P WeblogicPassword
Example:
[bose@oracle bin]$ ./datamodel.sh downloadrpd -O /home/bose/Sample.rpd -SI ssi -U weblogic -P Admin123 -W Admin123
Operation successful.
RPD download completed successfully.
If Your OBIEE is installed in Windows Server or using window shell script, Use datamodel.cmd instead of datamodel.sh
Syntax:
I - Input Directory
O - Output Directory
P - Admin Password
W - Repository Password
U - Admin User Name
SI - Service Instance
Cheers!
Bose
Does this command also update the rpd connections pools when migrating rpd to new environment say test to prod?
ReplyDeleteHi Bastrop,
DeleteWhen you are migrating for very first time as a new setup, We have to update the target environment database connection details in the connection and variable if any and then deploy in rpd.
for e.g: we might have different database for dev, uat or prod. if it is same for all the environment then there would be no issue. otherwise, we have to update in rpd for first time.
Hope it helps!
thanks,Bose
I can’t believe focusing long enough to research; much less write this kind of article. You’ve outdone yourself with this material without a doubt. It is one of the greatest contents. YouTube Vanced
ReplyDeletePlease explain the process of migrating reports from development to production.
ReplyDeleteIf OBIEE is installed on another Linux server, how do you specify the server address?
ReplyDeletelike below you have to mention :
DeleteC:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\datamodel.cmd downloadrpd -O E:\Repdown.rpd -SI ssi -U weblogic -P Admin123 -S ipaddress -N 9502
Hi, after uploading the RPD we should restart OBIPS service ? because after I upload the new RPD , analytics page remain blocked in signing in page , until I restart the service and clear the browser cache.
ReplyDeleteThanks in advance