I was cleared about the concepts of Report Definitions and Data Page. But, I still have a query about the DATA CLASS MAPPING TOOL. What is the significance of the data class mappig tool. In this exercise there are three rows. 1-DATABASE NAME=PegaDATA 2-sae2_hr_plan 3-Class Name. I just want to know what is the significance of the Class ame and how the "Data Class Mapping Tool" is associated with it ? Please help me out to understand the concept of "Data Class Mapping Tool" with some suitable example.
The Data Class Mapping Tool is used to create a new Data class in Pega thathas properties that map to the columns of interest in a table of a 3rd party database.
In the SAE class the sae2_hr_plan table is in the Pega database but it is important to understand that it is a standard SQL type table that was created using 3rd party DB tools, it is not a table in Pega, we simply leveraged the same DB Pega is using to keep the class VM simple.
DataBase Name: PegaData - references aDatabase rulethat would need to be created ahead of time. In the exercise for simplicety we are using the built in rule PegaData. The DataBase rule contains the connection string information needed be Pega to communicate with a Database.
Table Name: sae_hr_plan - once you supply Pega with the DataBase rule it can query the database for a list of tables. You use this field to choose the table in the 3rd party DB that you wish to base your new data class of off.
Class Name: SAE-HRServices-Data_HRPlan - this is the name of the data class that the wizard will create for you. After running the wizard if you open the definition for this class you can test the connection to the table by clicking the "Test Connection" button at the bottom of the classes definition. Also note it has recorded the primary key for the class and on the External Mapping tab it has saved your mappings. The class has everything it needs to do a lookup to retrieve a single record based on the key as well as send a sql statement you create, using a report rule in the class, to the 3rd party DB. These two techniques are used to populate Datapages so you now have easy access to the data in the 3rd party DB table.
Cecil Howell, CSA | Senior Instructor | Pegasystems Inc.