Search This Blog

Thursday 1 November 2018

Downloading and Uploading RPD in OBIEE 12c

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:
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

Service Instance: ssi
Operation successful.
RPD upload completed successfully.

Download RPD:
*****************************************************
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
Syntax:
./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

7 comments:

  1. Does this command also update the rpd connections pools when migrating rpd to new environment say test to prod?

    ReplyDelete
    Replies
    1. Hi Bastrop,
      When 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

      Delete
  2. 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

    ReplyDelete
  3. Please explain the process of migrating reports from development to production.

    ReplyDelete
  4. If OBIEE is installed on another Linux server, how do you specify the server address?

    ReplyDelete
    Replies
    1. like below you have to mention :
      C:\Oracle\Middleware\Oracle_Home\bi\bitools\bin\datamodel.cmd downloadrpd -O E:\Repdown.rpd -SI ssi -U weblogic -P Admin123 -S ipaddress -N 9502

      Delete
  5. 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.
    Thanks in advance

    ReplyDelete

OBIEE 12c to OAS Migration

 Hi All, I have migrated successfully few projects from BI 12c to OAS 6.4. If  anyone wants help then please reach Me! Cheers! Bose

Recent Posts