We need to integrate Appian with a system that has a MS SQL Server database with

Simply edit the XSD and add the @Column() annotation to specify the specific data type as explained here: forum.appian.com/.../Defining_a_Custom_Data_Type.html

This is an example to map an Appian Text Field to a CHAR(40) Non-nullable column:

<xsd:element name="name" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(columnDefinition="CHAR(40) NOT NULL")
</xsd:appinfo>
</xsd:annotation>
</xsd:element>

when editing the XSD you need to delete the CDT and re-upload the new version then run impact analysis or manually remap the data store so it points to the latest version of the CDT.

Simply edit the XSD and add the @Column() annotation to specify the specific data type as explained here: forum.appian.com/.../Defining_a_Custom_Data_Type.html

This is an example to map an Appian Text Field to a CHAR(40) Non-nullable column:

<xsd:element name="name" type="xsd:string">
<xsd:annotation>
<xsd:appinfo source="appian.jpa">
@Column(columnDefinition="CHAR(40) NOT NULL")
</xsd:appinfo>
</xsd:annotation>
</xsd:element>

when editing the XSD you need to delete the CDT and re-upload the new version then run impact analysis or manually remap the data store so it points to the latest version of the CDT.