How to create dataStore entity for mssql table?

Did you follow these steps?
docs.appian.com/.../Data_Stores.html

Did you follow these steps?
docs.appian.com/.../Data_Stores.html

Hey Shaym,
I did this but the problem is table already created in mssql. So how can I allow appian to create it automatically? I mean if i will do so then it would create table in mysql I need to map the one which is already there in mssql

Data store is similar to Database.
Data store entity is similar to a table/view.
Publishing the Datastore validates that the DB is accessible and the CDT mappings to DB table(s) are correct.

1) Add the mssql database as datastore in Appian. Once you add it successfully, it will be available in the drop-down (jdbs/<TheDSName>).
2) Add the DSE (CDT mapping) and verify, the data store. The verification will be successful only if CDT and the DB table match.

Hi Shyam,

Thanks for your response. My issue is now resolved, Actually it was the XSD file where we need to make changes that are compatible with SQL, I did that and now its executing fine. Thanks for your suggestions