Which sequence of actions is required to incorporate a new database column into an Appian project that uses a CDT and datastore?

Which sequence of actions is required to incorporate a new database column into an Appian project that uses a CDT and datastore?

• A. Update the database table; Update the CDT; Save and publish data store; Verify datastore
• B. Verify datastore; Update the database table; Save and publish data store; Update CDT
• C. Update CDT; Save and publish data store; Update the database table; Verify datastore
• D. Update the database table; Update the CDT; Verify datastore; Save and publish data store

Answer: (A)

When adding a new database column used by an Appian CDT and datastore, you must synchronize the physical schema, the CDT definition, and the datastore metadata in the correct order. Start by updating the actual database table to include the new column. Next, update the CDT so it includes the new field and maps to the column’s data type. After that, save and publish the datastore to refresh Appian’s metadata and align the datastore with the updated CDT and table. Finally, verify the datastore to confirm the new column is recognized correctly and that there are no configuration issues. This order ensures Appian can map the new field accurately and avoids mismatches between the database, CDT, and datastore.

When adding a new database column used by an Appian CDT and datastore, you must synchronize the physical schema, the CDT definition, and the datastore metadata in the correct order. Start by updating the actual database table to include the new column. Next, update the CDT so it includes the new field and maps to the column’s data type. After that, save and publish the datastore to refresh Appian’s metadata and align the datastore with the updated CDT and table. Finally, verify the datastore to confirm the new column is recognized correctly and that there are no configuration issues. This order ensures Appian can map the new field accurately and avoids mismatches between the database, CDT, and datastore.