Defining the database driver
You can define a JDBC driver in Pega Platform by using the Import Wizard and creating or updating a dynamic system setting. When you define a driver, your application can connect to database platforms that are different from the Pega Platform database.
Before you begin: Download the appropriate driver from your database vendor.
See the vendor documentation to confirm the appropriate driver file. The Java version of
the driver must be compatible with the Java version of your application server.
- In the header of Dev Studio, click .
- Select the database driver file that you obtained from your database vendor and follow the steps in the Import Wizard to complete the import.
- Expand the SysAdmin category, and then click Dynamic System Settings.
-
Search for the dynamic system setting instance whose Setting
Purpose equals
prconfig/database/drivers/default
.- If the instance does not exist, click Create,
enter the following values, and then click Create and
open.
- Short description –
prconfig/database/drivers/default
- Owning Ruleset –
Pega-Engine
- Setting Purpose –
prconfig/database/drivers/default
- Short description –
- If the instance already exists, click the row to open the instance.
- If the instance does not exist, click Create,
enter the following values, and then click Create and
open.
-
In the Value field, enter the fully qualified class name
for the JDBC driver that you imported. If the Value field
is already populated, separate individual driver class names with a semicolon
(
;
). See your database vendor documentation for the class name. - Click Save.
-
Restart the nodes in the cluster so that all tiers in the system recognize your
new database driver, using the method appropriate for your deployment.
- For Pega Cloud Services environments, create a new support ticket to restart the environment.
- For on-premises systems, manually restart each node.