Use the updaterpdvariables command to upload a JSON input file or a modified JSON file containing variable information to a specific server instance.
Use this and the listrpdvariable
utility when you need to update more than one variable.
You can create and upload a JSON input file that contains new repository variables, names and values.
You can also upload an updated JSON file containing modified repository variables, names or values. Use the listrpdvariable
command to create a JSON file containing a list of repository variables for a specific service instance. Modify the variable information in this file and then upload it to the service instance using the updaterpdvariables
command.
Note:
You must not modify the uid
values for variables in the file. See Overview of User and Application Role Commands.
You execute the utility through a launcher script, datamodel.sh
on UNIX and datamodel.cmd
on Windows. If the domain is installed in default folder then the location of the launcher script looks like the following:
Oracle_Home/user_projects/domains/Domain_Name/bitools/bin/datamodel.sh
or datamodel.cmd
on Windows
If the client install doesn't have domain names, the launcher script location is as follows:
Oracle_Home\bi\bitools\bin\datamodel.cmd
Syntax
updaterpdvariables -C <rpdVariablesList.json> -SI <service_instance> -U <cred_username> [-P <cred_password>] [-S <hostname>] [-N <port_number>] [-SSL] [-H]
Where
C
specifies the name of the JSON file that you want to upload. Note this file must not contain modified uid
values for variables. See the Creating a JSON Input File section and the JSON Input Repository Variable File example that follows below.
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 you specified for U
. If you do not supply the password, then you are prompted for the password when the command is run. Oracle recommends that you include a password in the command only if you are using automated scripting to run the command.
S
specifies the Oracle BI EE host name. Only include this option when you are running the command from a client installation.
N
specifies the Oracle BI EE port number. Only include this option when you are running the command from a client installation.
SSL
specifies to use SSL to connect to the Oracle WebLogic Server to run the command. Only include this option when you are running the command from a client installation.
H
displays the usage information and exits the command. Use -H
or run .sh
without any parameters to display the help content.
Example
datamodel.sh updaterpdvariables -SI ssi -U weblogic -P password -S slc01.example.com -N 7777 -C listrpdvar.json
Creating a JSON Input File
Use the JSON file that was generated when you ran the listrpdvariable
command as a model for a JSON input file. Using the outputted JSON file as a model ensures that the new file's syntax is valid. See List Repository Variables Command.
When writing the input file, note the following information:
uid – This element can be any text.
variable – This element is the new variable's name.
value – This element is the new variable's value. Use singular quotes inside of double quotes. For example "'VALUE'".
JSON Input Repository Variable File Example
{ "Title":"List Rpd Variables", "Rpd-Variables":[ { "uid":"80000000-3335-155c-991a-0af2537d0000", "variable":"RPD_ST_VARIABLE", "value":"'rpdStatic Variable My value'" }, { "uid":"c0000000-33c0-155c-991a-0af2537d0000", "variable":"DYNAMIC_REPO_VAR_NEW_NAME", "value":"'dynamic repo var'" }, { "uid":"New1", "variable":"NEW_VAR_NAME", "value":"'new value for new variable'" } ] }