Use the list connection pool command listrpdvariable
to create a list of repository variables in JSON format for a specific service instance.
Use the listrpdvariable
and the updaterpdvariables
utility when you need to update more than one variable.
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
The listrpdvariables
command takes the following parameters:
listrpdvariables -SI <service_instance> -U <cred_username> [-P <cred_password>] [-S <hostname>] [-N <port_number>] [-V <comma or new line separated FILE containing selected variables names>] [-O <outputFile.json>] [-SSL] [-H]
Where
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.
V
is an optional argument that specifies the repository variable names that you want to list. You must separate the variable names with commas. If you do not pass the V
argument or pass the V
argument without listing any variable names, then by default all repository variables are returned.
O
specifies the output file name with the .json
suffix.
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 listrpdvariables -SI ssi -U weblogic -P password -slc01.example.com -N 7777 -V selectedvar.csv -O listrpdvar.json
Sample JSON List Repository Variable Output
{ "Title":"List Rpd Variables", "Rpd-Variables":[ { "uid":"80000000-3335-155c-991a-0af2537d0000", "variable":"RPD_ST_VARIABLE", "value":"'rpdStatic Variable'" }, { "uid":"c0000000-33c0-155c-991a-0af2537d0000", "variable":"DYNAMIC_REPO_VAR", "value":"'dynamic repo var'" } ] }
Sample JSON Output
Note:
If there is no match, meaning none of the variable names included in the V
argument matched the repository variables in the repository, then the JSON output is an empty array list.
{ "Title":"List Rpd Variables", "Rpd-Variables":[ ] }