Note: With Pega 7.1.7 local data storage replaces data tables. Do not create new data tables.

Create a Database Table data instance by selecting Database Table from the SysAdmin category.

Before you create a Database Table instance, confirm that:

• The table or view is present in the database schema
• The PRPC class (Rule-Obj-Class instance) exists.

You don't need to create a Database Table instance for each concrete class. At runtime, to locate a database table for an object, the system uses pattern inheritance and class groups to locate the appropriate table. If none is found, it uses the "catch-all" default table pr_other.

Database Table instances created automatically

The following tools and wizards let you create database tables indirectly, without using the Database Table form:

• Connector and Metadata Accelerator — Creates a class and database table instance for an external table
• Database Class Mappings gadget — Creates a class and database table instance for an external table
• Data Tables wizard — Optionally creates a dedicated table in the PegaRULES database, and a corresponding database table instance, to hold the rows of the data table.

The key to a Database Table instance is the name of a PRPC class:

About the Connector and Metadata Accelerator About the Data Table wizard Data Model category — Property Tree, Class Relationships, and Database Class Mappings tabs

About Database Table data instances

Open topic with navigation