OBIEE 12c does not have GUI as 11g did to upload an RPD. In the 12c version, we now have to upload the RPD file using a command script. This blog will quickly walk through the command lines needed to upload an RPD.

From the command prompt, change the directory to the “bin” folder that holds the data-model-cmd file.

Syntax:
uploadrpd -I <RPDname> [-W <RPDpwd>] -SI <service_instance> -U <cred_username> [-P <cred_password>] [-S <hostname>] [-N <port_number>] [-SSL] [-H]

Where,

I – Specifies the name of the repository that we want to upload.

W – Is the repository’s password. If we do not supply the password, then we will be prompted for the password when the command is run. For security purposes, Oracle recommends that we include a password in the command only if we are using automated scripting to run the command.

SI – Specifies the name of the service instance.

U – Specifies a valid user’s name to be used for Oracle BI EE authentication.

P – Specifies the password corresponding to the user’s name that we specified for U. If we do not supply the password, then we will be prompted for the password when the command is run. For security purposes, Oracle recommends that we include a password in the command only if we are using automated scripting to run the command.

S – Specifies the Oracle BIEE host name. Only include this option when we are running the command from a client installation.

N – Specifies the Oracle BIEE port number. Only include this option when we are running the command from a client installation.

Here is an example of what the upload syntax might look like:

2

After running the command, there should be a message indicating that the RPD has been uploaded successfully.

Questions or comments? Please feel free to email me below:

Kiel Briggs kbriggs@ecapitaladvisors.com

References:

http://docs.oracle.com/en/middleware/middleware.html