Skip to main content

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Creating a Database Table data set that uses the relational database

Suggest edit Updated on April 5, 2022

Create a Database Table data set to query and save data in the Pega Platform relational database.

  1. In the header of Dev Studio, click CreateData ModelData Set.
  2. On the Create Data Set form, in the Label field, enter a name for the data set.
  3. In the Type list, select Database table.
  4. In the Context section, select the appropriate application, class, and ruleset for the data set.
  5. Click Create and open.Result: The form displays the database table details, such as the table name, the database type, and the partitioning keys. The details are retrieved automatically from the class definition.
    Database Table data set form
    The data set is linked to the mkt work table in the relational
                                database. The py ID property is mapped to a key.
  6. On the Edit Data set form, in the Selectable keys section, click Add key, and then define a property.
    Add as many keys as necessary, and map each key to a property. To ensure good query performance, use properties that are mapped to an indexed database column.
  7. In the Partitioning key section, select a property to distribute the data into partitions across the nodes.
  8. Click Save.
Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us