External Mapping of Column/Property in Data Class

General
,
1

How to do external mapping of column that we manually created in database by running query for creating column in table to the class present in pega.

Can someone please share the step-by-step configuration.

Thanks in advance.

2

Hi @AbhishekC1725: If you have created the column names as same as the property names, it should work automatically. Please try by saving the class and database table instance. You can also do the mapping in the instance. Open the class, and navigate to external mapping tab to do the mapping. Please see this for details.

Thanks.

3

@ArulDevan

Hi,

Just want to know, that old data will come in the column after saving the class and database table instance.
Or do we need to write activity to save all instances of that table?

4

Hi @AbhishekC1725: No. To get the data from the BLOB to the exposed columns, you may need to use column population (or) utilities (or) it will get exposed to the columns when there is a next write operation to the specific row.

Thanks.