Hi All,
Please help me out.
I have to create CDT for table in Oracle DB nd I have created xsd nd imported while trying to map to db from data store it's throwing error like. Column type miss match found timestamp expected date . But my Oracle table contains timestamp as data type only nd u gave date and time still it throwing error. Even for one more column also . Found char expected varchar2(1) to this also I mapped properly in Xsd stil this error. Please help me out
Discussion posts and replies are publicly visible
Make sure you reference Appian's resource on Mapping Custom Data Types. There is a grid listing the field types in different systems. (ie. MySQL, Oracle DB, etc).
https://docs.appian.com/suite/help/17.4/Mapping_CDTs_to_Pre-defined_Database_Tables.html#field-types
Make sure you are correctly creating your XSD file. You can reference this link in Appian including examples on how to create XSDs.
https://docs.appian.com/suite/help/17.4/Supported_XSD_Elements_and_JPA_Annotations.html