Back Forward Database Table form
Completing the Database tab

About Database Table data instances

Use this tab to associate a database table or view with the class that you identified as the key of this data instance.

Field

Description

Database  
Database

SmartPromptIdentify a Database instance that corresponds to the database containing the table or view. TURBT 8/19/02

Reports Database

SmartPrompt Optional. Identify a database instance that contains a copy of this table, replicated through database software. GRP-445 5.5 DSILA See How to use a reports database.

Complete this field only if a database administrator has created a separate "mirror" or "slave" database with tables — identical in name, structure and indexes to the PegaRULES database tables — sufficient to support reporting needs, and established a replication process. The replication process may be "near real time", or with a longer latency, depending on the system resources available for replication and management reporting needs.

The table can support list view and summary view data retrieval, to reduce the processing workload on the primary PegaRULES database. To cause report processing to use the alternate database, select the Use alternate database? checkbox on the Contents tab of a list view or summary view rule.

NoteIf a list view or summary view presents data from multiple tables — for example by using a JOIN facility — all required tables must be in one database — either the master PegaRULES database or a single reports database. The sources for a report cannot span multiple databases.

NoteYou can disable the use of the reports database — causing all reporting to occur against the primary PegaRULES database regardless of the Use alternate database? settings in list view or summary view rule, by adding the following entry to your prconfig.xml file:

<env name="database/useReportingDatabase" value=false" />

The default if omitted is true. DSILA 9/16/08

Catalog Name

Optional. Identify the database catalog containing the schema that defines the table or view. GENTJ 2/6/03 03-02

In special situations, a catalog name is needed to fully qualify the table. See Pega Developer Network article PDNPRKB-12448 How to use fully qualified table names in the PegaRULES database.

Schema Name

Optional. Identify the name of the schema (within the catalog) that defines the table. As noted above, this required in some cases, especially if multiple PegaRULES database schemas are hosted in one database instances. GENTJ 2/6/03 See Pega Developer Network article PDNPRKB-23183 Troubleshooting: "Obj-Save is trying to write to a non-existent column".

Table Name

Enter the name of the specific table that is to hold instances of the specified class or class group.

NoteWhen allowed by the database account, enter only an unqualified table name. Preferably, the database account converts the unqualified table name to the fully qualified table name.

A few Database Table instances created when your system is installed identify database views rather than tables. Views are used only for reporting. By convention, the names of views in the initial PegaRULES database schema start with pwvb4_ or pcv4_.

Advanced featureIf you create additional views in the PegaRULES database, you can link to them to a class using a database table instance. The view data then becomes available for reporting with list view and summary view rules.

 Test Connectivity  

After you save this Data Table form, you can test connectivity to the database and table. This test does not alter the database. The test uses information on this form, the associated database data instance, and in some cases information from the prconfig.xml file or application server JDBC datasources.B-21216 BUG-1162

Up About Database Table data instances