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

Hi Vamsi,

Thanks for posting on PSC.

As suggested in your previous post(https://collaborate.pega.com/question/dashboard-creation-external-database), you need not create Class, rulesets and objects for external database table(employee) as external mapping tool does it for you. 

Could you explain, what you mean by trying to create Data Model(DataModle)? Yes, there you need to select an existing ruleset from drop down. Database mapping table rule needs to be associated with a ruleset, thus you need to select one.

You can create a new ruleset prior to using database mapping tool and then the newly created ruleset would also appear in the drop-down for selection and then class name is automatically populated based on concatenating your database table name and standard "Data-" hierarchy.

To answer your question, is it necessary to create the new Ruleset or Class:-

It's not necessary at all, though it's as per your business requirements. Also, the class is automatically created as explained in the link provided above in the comment.

Hope it clarifies your doubt, kindly notify if it does.

Regards,

Asif