Creation of new DB table from pega , provided we are not using datatype rule .

General
, , , , , , , ,
1

I am trying to created a new DB table from pega.

The steps I have followed is as below:

  1. created a class rule

  2. added that to data designer

  3. trying to create a DB rule instance , but at test connectivity I am getting the error as table doesn’t exist .

Is there any way to create DB table directly from pega , without writing SQL in Database?

2

@Ankush20

You need to use the option configure local source in the data designer to create a new table automatically.

3

@Ankush20 Open the class from Data types explorer , click on Records tab and under it click on “Configure source” button

select or add the properties for which columns needs to be created and also select the class keys , finally click on Submit button.

This creates a table in database.