Skip to main content

Using scripting with direct connection to the database and the prpcUtils tool

Suggest edit
Updated on August 25, 2021

Use the prpcUtils tool if you have a direct connection to the database to manage system management actions even if you do not have an active instance of Pega Platform.

If you need to run asynchronous operations, or you do not have a direct connection to the database, use the prpcServiceUtils tool. For more information about the prpcServiceUtils tool, see Using service-enabled scripting and the prpcServiceUtils tool.

Configure the prpcUtils.bat or prpcUtils.sh script actions in the prpcUtils.properties file.

You can also pass arguments to the script to override settings in the prpcUtils.properties file.

  • Use the properties file to set property values for reuse to minimize errors in entering commands.

  • Use the command-line arguments to augment or override values in the property file, for example, to customize one script action. The use of these arguments is optional. Each argument should be preceded with two hyphens (--).

prpcUtils script arguments

Use the command-line arguments to augment or override values in the property file, for example, to customize one script action. The use of these arguments is optional. Each argument should be preceded with two hyphens (--).

prpcUtils script argument Value
connPropFileThe full path to the connection.properties file that includes information for multiple targets.
driverClassYour JDBC driver class. For example, oracle.jdbc.OracleDriver.
driverJARLocation of your JDBC .jar file.
dbTypeDatabase vendor type, such as mssql, udb, oracledate, postgres, and db2zos.
dbURLJDBC URL to the database.
dbUserDatabase user name.
dbPasswordDatabase password.
archivePathFull path to the archive to be imported or exported.
propFileThe full path to the properties file, to override the default prpcUtils.properties.
hfixActionIf manageHotfixes is selected, sets the hotfix operation. Valid values are commit, rollback, generateDDL, install, and scan.
rulesSchemaThe rules schema.
dataSchemaThe data schema.
noFailOnErrorSet to true or false. When enabled, instances that fail to import are skipped and import continues instead of failing.
UPega user name.
PPega password.
accessGroupAccessGroup in which the Rule-Declare-Index of the classes being exposed exists. Applicable for the expose utility if --U or --P are not provided.

Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us