Teiid-wildfly Odata4 Server side validation

Question

Please let me know if we can configure server side validation logic in vdb.xml file to validate the user input before insert values into database using teiid wildfly odata4 service.

Thanks.

Answer 1

To perform custom validation in a way that is exposed to odata, you can create a view that has an insert trigger. See Teiid wildlfy - Table column encrypt/decrypt - where a trigger is used to encrypt a value before it enters the database.