Posted: 28 Oct 2020 23:20 EDT Last activity: 29 Oct 2020 6:33 EDT
Creating Data Classes: Can I adopt business data models the Client has available? [LSA Data Excellence]
As of Pega 8.5 there is an "Import from Spreadsheet" option available when adding new Case and Data Types to allow existing XLSX or CSV files containing existing business data to drive the new Case/Data Type's data model.
Be mindful that the spreadsheet provided may reflect the Client's physical data model. That is, it could have come from an export from the database tables in the Client's System of Record. It may not meet your Application's need to align its Data Classes with the existing System of Record structure. Your job as the LSA is to navigate this and proposed a justifiable design to support the needs of the Application to be delivered.
If the import capability is desired, there is a step in this process that provides you an opportunity to rename the fields from the spreadsheet, so that the Data classes can reflect business-friendly names and labels, rather than those from the source of the spreadsheet which may reflect database naming conventions or constraints.