About Database Table data instances
About the Modify Schema wizard
Working with the PegaRULES database
How to detect long database connection waits
How to limit connections to the PegaRULES database
Installation of Pega 7 creates a single Database data instance, identifying the PegaRULES database. You can create additional database data instances to identify a Correspondence Output Server database, to hold Pega 7 objects, or to allow Pega 7 to access external databases.
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 7 classes.
Use the Databases form to identify databases or to change database connection properties such as the name, location, or password.
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.)
Your Pega 7 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:
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.
Your Pega 7 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.
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.
About Database data instances