Question
Truviq Systems
NL
Last activity: 4 Jan 2023 7:27 EST
Creation of new DB table from pega , provided we are not using datatype rule .
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?
Accepted Solution
Updated: 4 Jan 2023 7:27 EST
JPMC
IN
@Ankush AgrawalOpen 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.
Updated: 4 Jan 2023 7:27 EST
Infosys Limited
IN
You need to use the option configure local source in the data designer to create a new table automatically.
Accepted Solution
Updated: 4 Jan 2023 7:27 EST
JPMC
IN
@Ankush AgrawalOpen 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.