Data stores
A data store in Appian is used to define a connection to a database and the CDTs to store. You will learn later how to store and query data to and from the database using that data store.
An important feature of a data store is that it allows Appian to automatically manage tables and fields in the database. This feature must be enabled in the Appian Administration Console.
Figure 9.12 – Enabling schema management in the Administration Console
When this is enabled, Appian will perform non-destructive changes automatically. Appian will never delete any tables or fields, leading to the loss of data. It will also never modify the type of an existing field, as this also might lead to data loss.
I highly recommend this way of managing the database, as it makes overall development in Appian a lot easier. There are other opinions on this approach. A database admin might want to enforce certain naming conventions for database objects. Some...
