Which property types in pega are mapped to which column types in MS SQL Server

General
, , ,
1

We have a table in MS SQL Server DB, this table has column types such as int, money, bit, char(2).

We want to create a class in Pega and map it to such table. Is there a way we can map such columns to properties in Pega?

If not then can you please clarify which column types should correspond to following property types in Pega? (For MS SQL Server)

Property Type Column Type
Integer ?
Decimal ?
TrueFalse ?
Date ?
DateTime ?

We are using Pega 8.5

Thank you!

Taras

2

In case anyone else is wondering the answer is yes.

For int column type we map to Integer property, for money - Decimal, for bit - TrueFalse for char - Text.

Best Regards,

Taras Podoroha

3

@TarasPodoroha Can you tell me what column type in DB did you use to Map Date Type Pega properties ?. We are trying to Map Date type properties in Pega to Date Type property in DB column in the class external mapping and receiving a message “of unsupported type date”