The Data Class Mapping Tool is used to create a new Data class in Pega that has 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 a Database rule that 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.

Sincerely,

Cecil Howell, CSA |  Senior Instructor  |  Pegasystems Inc.