Question
Class and Rule Set creation for MS SQL Database table
Hi Team,
Thank you for your support.
I have connected to MS SQL Server Database from Pega, now I wanted to create the Class , Ruleset and Objects for corresponding to the Database table ( Employee ).
I tried to create the class from DataModle ----> Class & Properties ----> Database Class Mapping, but it is asking me to select the existing rule set for creating the class. not sure which one do I need to select? Can't I create the new Ruleset for this table Employee ? Is it necessary to create the new Ruleset or Class ?
Please guide me on this.
Hi Vamsi,
If you have the table in the external database and you want to access it into your existing Pega application then you can map the external table with the Class in your application by using Database Class Mappings wizard as shown in the attachment.
For example, in my scenario i created a new table TABLE1 in my PegaData database under PRPC722DATA schema and wants to map this table to a Class in my application which is shown in my attachment.
To create the Class OSM47A-Jenkins-Data-TABLE1 we need to choose the Ruleset name and version, in my scenario i am trying to map my table into my existing application Jenkins which has the ruleset Jenkins.
Hope this information is clear to you.
Regards
Mahesh