Question
EPAM
ES
Last activity: 17 Mar 2022 14:09 EDT
Which property types in pega are mapped to which column types in MS SQL Server
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
Accepted Solution
Updated: 16 Sep 2021 9:57 EDT
EPAM
ES
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
Ernst & Young LLP
US
@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"