Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

Creating a Database Table data set that uses the relational database

Updated on May 17, 2024

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.

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us