Hi, i have created external data source by using appian admin console. post creation i trying to create CDT for the existing postgre SQL Data base table.
below warning are populating due to data type miss matched. can some one suggest me how to overcome this problem ?
we are using external DB(PostGres Databae)
Discussion posts and replies are publicly visible
I recommend using Text as the field type which will maintain the UUIDs. You would need to set uniqueness restraints on your database to ensure there are no duplicates
Hi Danny,
Thank you for reply.
but, while creating CDT in appian which are having UUID data type the columns are not coming in fields. these are showing as not allowed to added.
how to do here ?
After you create the CDT, you can manually add more fields
OK.. let me try this.
by default UUID is unique right in table. why i need to set uniqueness restraints on your database to ensure there are no duplicates ?