More about Database data instances

After you complete a database data instance, you can create Database Table data instances to associate the relational tables and views in that database with Pega Platform classes.

Use the Databases form to identify databases or to change database connection properties such as the name, location, or password.

Reviewing a database schema

You can use the Modify a Database Schema wizard to examine the table structure of a database identified by a database data instance. (In addition, if the database account identified in the Database data instance has the appropriate privileges, you can modify the database schema to expose properties using this wizard.)

JDBC libraries

Your Pega Platform server requires a vendor-specific JDBC driver library to connect to an external database. If the database you are to define requires a library not yet installed, follow these steps before attempting to connect to the database:

1. Download and install the JDBC library from ibm.com, oracle.com, sybase.com, microsoft.com or other sites.
2. Update server Environment variables to reference the library.
3. Update the prconfig.xml file to reference the library.
4. Restart the Pega Platform server.

Consult database vendor installation instructions for more details.

Use Connect SQL rules ( Rule-Connect-SQL rule type) to access relational databases other than the PegaRULES database.

JNDI Datasource

Your Pega Platform server can use a JNDI datasource to access the PegaRULES database, using the database/databases/pegarules/dataSource element in the prconfig.xml file. See the Installation Guide for your platform for instructions.

Tracing JDBC connections

Vendor-supplied tools can help debug JDBC connections. For suggestions and a list of links to tools, see PDN article Troubleshooting JDBC problems with tools from Pegasystems and others.