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

forum.appian.com/.../Defining_a_Custom_Data_Type
refer this datatypes

SQL Server DECIMAL types are not supported...This means that it is not possible to integrate Appian to any database with this type? I can't believe this. Is this type so unusual?

Would you mind explaining what you mean by "We have problems defining our DataStores in Appian" how are you trying to define these fields in your XSD? an example would be useful

Find 3 files:
1. Screen of the error
2. XSD file with the CDT definition
3. Design view of the corresponding SQL Server table

ExpenseReport.xsd

@Jp
You might have selected Number(Integer) for field in CDT
it should be Number(Decimal).

This is the CDT definition. It seems right to me...

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.

It worked! Thank you so much! We can move on.