Question
Does 7.2.1 generate connector rules wizard for external database support clob datatype ?
I generated rules for an external database using the following wizard.
select Designer Studio > Integration > Connectors > Connector and Metadata wizard.
It was not able to create corresponding properties, activities for a column of clob datatype.
Does anyone have an alternative to get those properties created for clob. Looks like pega property type doesn't have clob type.
Thanks
SKR
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Hi Siva,
You wont be able to map the CLOB column to any property in Pega directly. However, you can try make using use of pyLargeColumn property qualifier introduced from Pega 7.2.1 for supporting CLOB.
A property qualifier can be a supplement information in a property that extends or restricts the given functionality. Property qualifier rules are instances of Rule-Obj-Property-Qualifier and stored in pr4_rule_property table.
When 'pyLargeColumn' qualifier is set on a property, it will be treated as a CLOB column when it is optimized.