I have a CDT that maps to a table. The CDT and the table has an ID column. Is th

Have you tried just writing an instance of the CDT with an ID pre-assigned to the table? I could be misunderstanding what exactly you want to do, but I think it might do what you want.

Thanks for the reply.

I tried that approach, I set the ID of the CDT to 100 (which doesn't exist in the table). A row was inserted into the table, but with different ID. The assigned value (100) was ignore by Appian.

I also tried not to use @GeneratedValue and Sequence for the ID column in my schema file, but then the schema will not be loaded.

Hi guozhang,
we can insert a new row into the table with pre-assigned Id value by these two annotations
@Id
@Column(name="id").

import the attached xsd file and give your own Id value to insert data, it will work.
hope it helps to you

TestGeneratedId.xsd

That works. Thank you so much.